Documentation

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

Railway

Railway offers simple Postgres provisioning with automatic deployments.

  • Easy setup
  • Integrated with deployments
  • Reasonable pricing
  • Good developer experience

Self-Hosted Options

Docker

You can run Postgres in a Docker container:

Terminal
docker run --name dirstarter-postgres -e POSTGRES_PASSWORD=postgres -p 5432:5432 -d postgres

Then use this connection string:

DATABASE_URL="postgres://postgres:postgres@localhost:5432/postgres"

Local Installation

Install Postgres directly on your machine:

  1. Download from postgres.org or using Homebrew
  2. Install and set up a password
  3. Create a database

Then use this connection string:

DATABASE_URL="postgres://postgres:yourpassword@localhost:5432/dirstarter"
Edit on GitHub

Last updated on

On this page