PostgreSQL Database

PostgreSQL database is included in all Chita Cloud plans, starting with 100MB free on shared instances.

Pricing

PostgreSQL is available in all plans:

Free Plan: Includes 100MB PostgreSQL on a shared instance - perfect for testing and small projects.

Paid Add-ons: Available for Freelancer Starter, Professional, or Team Agency plans with dedicated resources and guaranteed performance.

Features

• Automatic Backups: Daily backups with 7-day retention
• EU Hosting: Data stored in Germany (GDPR compliant)
• Connection Pooling: Optimized connection management
• Dashboard Management: Create and manage databases via UI
• High Availability: Available on HA plan with automatic failover
• Performance Monitoring: Query performance insights

Quick Setup

Via dashboard:

1. Click "Databases" in the sidebar
2. Click "Create Database"
3. Select plan (Small, Medium, or Large)
4. Choose database name
5. Click "Create"
6. Copy connection string from dashboard

Connection

Connection String

DATABASE_URL=postgresql://user:pass@host:5432/dbname

The connection string is automatically provided as an environment variable. Learn how to manage environment variables securely.

Migrations

Use your preferred migration tool:

# Prisma
npx prisma migrate deploy
 
# TypeORM
npm run typeorm migration:run
 
# Go migrate
migrate -database $DATABASE_URL -path ./migrations up

Next Steps

• Configure environment variables
• Deploy your first app
• Learn about Redis caching
• Monitor your database