Home

plex-postgresql Wiki

Run Plex Media Server with PostgreSQL instead of SQLite. Zero Plex modifications required.

Latest release: v0.9.35

• 278 unit tests (220 SQL + 41 shadow elimination + 17 connection isolation) with GitHub Actions CI
• Docker reliability: fresh-install crash fix, claim flow fix, migration fixes (v0.9.33)
• SQL fix: GROUP BY / NULLS FIRST no longer corrupt DELETE/UPDATE statements (v0.9.33)
• Shadow SQLite elimination: decltype, column metadata from PostgreSQL (v0.9.32)
• Single-row streaming mode for all READ queries (PQsetSingleRowMode) (v0.9.28)
• Auto-reconnect after PostgreSQL restart (v0.9.18)

Pages

• How It Works — Architecture, SQL translation, stack protection
• Modules — Code organization, test suites, caching architecture
• Benchmarks — SQLite vs PostgreSQL performance comparison
• Troubleshooting — Common issues, debugging, known limitations
• Changelog — Release history and bug fixes
• README en Español — Documentación en español