a3236ae9d5
- Updated `.env` and `.env.test` files to include PostgreSQL connection settings and Redis configuration. - Migrated database from SQLite to PostgreSQL, updating relevant queries and connection logic. - Enhanced error handling and logging throughout the application. - Added new test utilities for PostgreSQL integration and updated user model methods. - Introduced new routes for user authentication and form management, ensuring compatibility with the new database structure. - Created login and registration views in EJS for user interaction.
24 lines
1.1 KiB
Plaintext
24 lines
1.1 KiB
Plaintext
DATABASE_URL=your_neon_production_connection_string_with_sslmode_require # e.g., postgresql://user:password@host:port/dbname?sslmode=require
|
|
# DB_HOST=your_production_db_host_or_service_name # e.g., the service name in docker-compose.prod.yml like 'db'
|
|
# DB_PORT=5432
|
|
# DB_USER=your_production_postgres_user
|
|
# DB_PASSWORD=your_production_postgres_password
|
|
# DB_NAME=your_production_postgres_database_name
|
|
|
|
# Redis
|
|
REDIS_HOST=your_production_redis_host_or_service_name # e.g., the service name in docker-compose.prod.yml like 'redis'
|
|
REDIS_PORT=6379 # Or your production Redis port if different
|
|
REDIS_PASSWORD=your_production_redis_password # Ensure this is set for production
|
|
|
|
# Application specific
|
|
NODE_ENV=production
|
|
PORT=3000 # Or your desired production port
|
|
|
|
# Security - VERY IMPORTANT: Use strong, unique secrets for production
|
|
SESSION_SECRET=generate_a_very_strong_random_string_for_session_secret
|
|
JWT_SECRET=generate_a_very_strong_random_string_for_jwt_secret
|
|
|
|
# Other production settings
|
|
# For example, if you have specific logging levels or API keys for production
|
|
# LOG_LEVEL=warn
|
|
# THIRD_PARTY_API_KEY=your_production_api_key |