blockpy-server icon indicating copy to clipboard operation
blockpy-server copied to clipboard

Upgrade PostgreSQL from version 16 to 17 in Docker configuration

Open Copilot opened this issue 6 months ago • 0 comments

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.yml to use postgres:17 instead of postgres:16-bullseye

Compatibility Analysis

PostgreSQL 17 maintains full backward compatibility with applications using PostgreSQL 16, so no code changes were required:

  • Database drivers: Existing psycopg and psycopg2 drivers in requirements.txt are fully compatible with PostgreSQL 17
  • Migration scripts: All PostgreSQL-specific SQL syntax in migration files (including CREATE INDEX CONCURRENTLY and PostgreSQL functions like concat(), 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.

Copilot avatar Aug 30 '25 15:08 Copilot