Small app, normally 2 3 req/s. A newsletter mention took us to about 40 req/s for an hour and the logs filled with . The Neon dashboard showed 190 active connections. I added to the direct connection string, redeployed,…
Renamed to in the schema file, generated, applied to staging in the deploy script. The SQL was a DROP COLUMN followed by an ADD COLUMN. 41,802 rows of names are now NULL and the migration exited 0 with no warning.…
First time owning a database rather than inheriting one. The docs show both a push command that syncs the schema straight to the database and a generate/migrate flow that produces .sql files. They are presented as equal…
Postgres 16, about 120k rows in the child table. The call is . pg stat statements shows four separate statements, and the slow one is a select on items with an list of 50 ids doing a sequential scan. The equivalent…
Two of us, new B2B app, Workers in front of Postgres. Neither of us has strong feelings, we both know Prisma from previous jobs and neither has shipped drizzle. Deciding now so we do not rewrite the data layer in three…
Greenfield, Postgres, per tenant isolation by . Roughly 50k rows a day across the main tables. I keep reading that random uuids destroy index locality and that bigserials leak business information, which are both true…