pg-test-suite-is-backend-parity
IN premise
`test_pg.py` is a parity test suite: every behavior tested has a corresponding expected behavior from the SQLite backend, validating that PgApi returns the same dict shapes and enforces the same invariants to ensure backend interchangeability.
Summary
The PostgreSQL test suite exists specifically to guarantee that the Postgres backend behaves identically to the SQLite backend. Every test in it mirrors an expected SQLite behavior, checking that both backends return the same data shapes and enforce the same rules, so they can be swapped without breaking anything.
Details
| Source | entries/2026/05/05/tests-test_pg.md |