Paper Dynasty Database - PostgreSQL database service
40c512c665
- Add explicit ORDER BY id to all queries for consistent results across SQLite and PostgreSQL - PostgreSQL does not guarantee row order without ORDER BY, unlike SQLite - Skip table creation when DATABASE_TYPE=postgresql (production tables already exist) - Fix datetime handling in notifications (PostgreSQL native datetime vs SQLite timestamp) - Fix grouped query count() calls that don't work in PostgreSQL - Update .gitignore to include storage/templates/ directory This completes the PostgreSQL migration compatibility layer while maintaining backwards compatibility with SQLite for local development. Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com> |
||
|---|---|---|
| app | ||
| docs | ||
| migrations | ||
| scripts | ||
| storage/templates | ||
| .dockerignore | ||
| .env | ||
| .env.example | ||
| .gitignore | ||
| compose.production.yml | ||
| db_engine.py | ||
| db_migrations.py | ||
| DOCKER_QUICKSTART.md | ||
| docker-compose.yml | ||
| Dockerfile | ||
| LICENSE | ||
| main.py | ||
| MIGRATION_PROGRESS.md | ||
| POSTGRES_MIGRATION_PLAN.md | ||
| PROJECT_PLAN.json | ||
| QUICK_START.md | ||
| requirements.txt | ||
| sheets.py | ||
| VERSION | ||