// DATABASE

CONNECT YOUR DATA.

Connect managed databases, configure connection pooling, and optimize database performance for your deployments.

SUPPORTED DATABASES

Connect any database that supports standard connection strings. Boottify works with all major database providers.

PostgreSQL

MySQL

MongoDB

Redis

SQLite

PlanetScale

Supabase

Neon

Turso

CONNECTION STRINGS

Store your database connection strings as environment variables. Never commit credentials to your repository.

bash

# Add database URL as environment variable in the dashboard
# Settings > Environment Variables > Add Variable

DATABASE_URL="postgresql://user:pass@host:5432/db"
REDIS_URL="redis://user:pass@host:6379"

# Or add to your .env file locally for development

SECURITY: Environment variables are encrypted at rest and in transit. Use different credentials per environment.

CONNECTION POOLING

Applications with multiple replicas can exhaust database connections quickly. Use connection pooling to manage connections efficiently.

PgBouncer

Connection pooler for PostgreSQL. Use with Supabase, Neon, or self-hosted.

Prisma Data Proxy

Built-in connection pooling for Prisma with edge runtime support.

Drizzle HTTP Proxy

HTTP-based queries for edge deployments with connection management.

typescript

// Example: Prisma with Data Proxy
// prisma/schema.prisma
generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
  directUrl = env("DIRECT_URL") // for migrations
}

BEST PRACTICES

Use Nearby Databases

Deploy databases close to your application server to minimize latency.

Enable SSL

Always use SSL connections for production databases.

Separate Credentials

Use different database users for preview and production environments.

Connection Limits

Configure connection limits based on your database tier.