pg-fixture-uses-uuid-isolation

IN premise

Each `pg_api` test fixture partitions its data by a unique UUID v4 `project_id` rather than using transactions or ephemeral databases, enabling safe concurrent test execution against a shared database.

Summary

Tests sharing the same database avoid stepping on each other by giving each test its own random UUID as a project ID, so every test only sees its own data. This means tests can run in parallel without needing separate databases or transaction rollbacks for isolation, which keeps the test suite fast and simple.

Details

Source

entries/2026/04/29/tests-conftest.md