Postgres Hosting
Options for hosting your Postgres database
Dirstarter requires a Postgres database to work. This guide covers various hosting options for your database, from managed services to self-hosted solutions.
Hosted Postgres services
Hosted Postgres services are a great way to get started with Postgres. They are easy to set up and use, and most of them offer a generous free tier.
Neon
Neon is a serverless Postgres service with a generous free tier.
- Serverless architecture
- Branching for development/staging
- Automatic scaling
- Free tier with 500MB storage
Supabase
Supabase provides Postgres databases with additional features like authentication and storage.
- Full Postgres support
- Additional services (auth, storage, etc.)
- Free tier with 500MB storage and 5GB data transfer
- Simple dashboard
Prisma Postgres
Prisma Postgres is a managed Postgres service with a generous free tier.
- Serverless architecture
- Automatic scaling
- Free tier with 1 GB storage
Self-Hosted Options
Docker
You can run Postgres in a Docker container:
docker run --name dirstarter-postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgresThen use this connection string:
DATABASE_URL="postgres://postgres:postgres@localhost:5432/postgres"Local Installation
Install Postgres directly on your machine:
- Download from postgres.org or using Homebrew
- Install and set up a password
- Create a database
Then use this connection string:
DATABASE_URL="postgres://postgres:yourpassword@localhost:5432/dirstarter"Last updated on