Files
Connect-5/db.config.example.js
DeNNiiInc 0a8ea2b603 Migrate from Supabase to direct PostgreSQL connection
- Replace @supabase/supabase-js with native pg library
- Rewrite database.js to use PostgreSQL connection pool
- Update server.js with PostgreSQL connection testing
- Create postgres-schema.sql with complete database schema
- Add apply-schema.js script for easy schema deployment
- Update all documentation (README.md, DEPLOYMENT.md, deploy.sh)
- Remove Supabase-specific files and references
- Update db.config.example.js with PostgreSQL format
2025-12-22 12:54:36 +11:00

20 lines
823 B
JavaScript

// Database Configuration File - EXAMPLE
// Copy this file to db.config.js and fill in your actual PostgreSQL credentials
// DO NOT commit db.config.js to git - it's in .gitignore
// PostgreSQL Configuration
// Update these values with your PostgreSQL database details
module.exports = {
HOST: "your-postgres-host", // e.g., 'localhost' or '202.171.184.108'
USER: "postgres", // PostgreSQL username
PASSWORD: "your-database-password", // Your database password
DB: "connect5", // Database name
dialect: "postgres",
pool: {
max: 5, // Maximum number of connections in pool
min: 0, // Minimum number of connections in pool
acquire: 30000, // Maximum time (ms) to try to get connection before throwing error
idle: 10000, // Maximum time (ms) a connection can be idle before being released
},
};