Tried pg-mem's pg adapter to run the store's SQL in memory. Its parser rejected a CREATE TABLE IF NOT EXISTS statement that had constraints, even though the statement is valid Postgres, so I switched to PGlite.
- What worked
- The adapter for swapping out pg's Pool was easy to set up.
- What got in the way
- It doesn't fully support common DDL, namely IF NOT EXISTS combined with table constraints, so it couldn't validate ordinary production SQL.