v2.24.2 - PostgreSQL Support

Features

• PostgreSQL Support: reportgen now supports both SQLite and PostgreSQL databases
• Backward Compatible: Existing SQLite deployments continue to work without changes
• Flexible Connection Options: Support for PostgreSQL DSN string or individual connection parameters
• SSL/TLS Support: Full SSL/TLS configuration options for secure database connections

Technical Details

Database Abstraction Layer

• Automatic SQL dialect conversion (SQLite ↔ PostgreSQL)
• Parameter binding transformation (? → $1, $2, ...)
• Helper functions for date/time operations across dialects

Connection Methods

SQLite (existing):

reportgen -db /path/to/database.db [other flags]

PostgreSQL (DSN):

reportgen -pg-dsn "postgres://user:password@localhost:5432/dbname" [other flags]

PostgreSQL (individual parameters):

reportgen -pg-host localhost -pg-port 5432 -pg-user user -pg-password pass -pg-dbname dbname [other flags]

Deployment

• Stateless Architecture: No local YAML configuration files required
• Network-Agnostic: Can run on any node with database network access
• Multi-Node Support: Horizontal scaling without master/slave constraints
• CI/CD Ready: Works with Kubernetes, Docker Compose, Cron jobs

See DEPLOYMENT_GUIDE.md for comprehensive deployment patterns and best practices.

Documentation

• Updated README.md with PostgreSQL examples
• New DEPLOYMENT_GUIDE.md with architecture and deployment patterns
• Updated CHANGELOG.md

Compatibility

Database	Support	Status
SQLite 3	✅	Fully supported
PostgreSQL 12+	✅	Fully supported

Breaking Changes

None. This is a backward-compatible release.