Home

plex-postgresql Wiki

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

Latest release: v0.9.30

• 798 unit tests across 24 suites with GitHub Actions CI on every push
• Single-row streaming mode for all READ queries (PQsetSingleRowMode) (v0.9.28)
• Connection isolation fix — streaming connections protected from concurrent use (v0.9.29)
• Dummy shadow statement fallback — eliminates shadow SQLite dependency for READ queries (v0.9.29)
• JSON ->> operator rewritten to native col::json->>'key' — Plex v1.43 compatible (v0.9.26)
• 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