replit-data-handling

# Replit Data Handling ## Overview Manage application data securely across Replit's three storage systems: PostgreSQL (relational), Key-Value Database (simple cache/state), and Object Storage (files/blobs). Covers connection patterns, security, data validation, and choosing the right storage for each use case. ## Prerequisites - Replit account with Workspace access - PostgreSQL provisioned in Database pane (for SQL use cases) - Understanding of Replit Secrets for credentials ## Storage Decision Matrix | Need | Storage | API | Limits | |------|---------|-----|--------| | Structured data, queries | PostgreSQL | `pg` npm / `psycopg2` | Plan-dependent | | Simple key-value, cache | Replit KV Database | `@replit/database` / `replit.db` | 50 MiB, 5K keys | | Files, images, backups | Object Storage | `@replit/object-storage` | Plan-dependent | ## Instructions ### Step 1: PostgreSQL — Secure Connection ```typescript // src/services/database.ts import { Pool, PoolConfig } from 'pg'; function createPool(): Pool { if (!process.env.DATABASE_URL) { throw new Error('DATABASE_URL not set. Create a database in the Database pane.'); } const config: PoolConfig = { connectionString: process.env.DATABASE_URL, ssl: { rejectUnauthorized: false }, // Required for Replit PostgreSQL max: 10, idleTimeoutMillis: 30000, connectionTimeoutMillis: 5000, }; const pool = new Pool(config); // Log errors without exposing connection string pool.on('error', (err) => ...