Database
Paperclip uses PostgreSQL through Drizzle ORM. The same schema works across the supported database modes; the difference is where PostgreSQL is running and how Paperclip connects to it. Use this page…
Database
Paperclip uses PostgreSQL through Drizzle ORM. The same schema works across the supported database modes; the difference is where PostgreSQL is running and how Paperclip connects to it.
Use this page when you are choosing between embedded, local Docker, or hosted PostgreSQL.
---
Database Modes
| Mode | Best for | Setup cost | |---|---|---| | Embedded PostgreSQL | Local development, one-command installs | Zero config | | Local PostgreSQL in Docker | A local prod-like database | Low | | Hosted PostgreSQL | Production and shared deployments | Higher |
> Note: The app logic does not change across modes. Only DATABASEURL and the storage location change.
---
Embedded PostgreSQL
This is the default mode when DATABASEURL is not set.