blockpy-server
blockpy-server copied to clipboard
Upgrade PostgreSQL from version 16 to 17 in Docker configuration
This PR upgrades the PostgreSQL database version from 16 to 17 in the Docker Compose configuration, as requested in the issue comments where @acbart mentioned they had upgraded to PostgreSQL 17 and needed to update the Docker images accordingly.
Changes Made
- Updated
docker-compose.ymlto usepostgres:17instead ofpostgres:16-bullseye
Compatibility Analysis
PostgreSQL 17 maintains full backward compatibility with applications using PostgreSQL 16, so no code changes were required:
-
Database drivers: Existing
psycopgandpsycopg2drivers in requirements.txt are fully compatible with PostgreSQL 17 -
Migration scripts: All PostgreSQL-specific SQL syntax in migration files (including
CREATE INDEX CONCURRENTLYand PostgreSQL functions likeconcat(),md5(),random()) work correctly with version 17 - Application code: No changes needed as the application uses standard SQL and PostgreSQL features that remain consistent
Benefits
PostgreSQL 17 brings performance improvements, enhanced security features, and better resource management while maintaining the same API compatibility that the BlockPy server currently relies on.
Testing
- ✅ Docker Compose configuration validates successfully with the new PostgreSQL version
- ✅ All PostgreSQL-specific migration syntax confirmed compatible
- ✅ No breaking changes identified in the codebase
Fixes #62.
✨ Let Copilot coding agent set things up for you — coding agent works faster and does higher quality work when set up for your repo.