Tootfinder

Today I managed to write a #Postgres query using 2 CTEs and a window function to delete some duplicate values (which should have been prevented by a proper unique constraint..) with only a tiny peek into the docs (I forgot the name of the `row_number()` function).

One more reason to choose #Postgres over #MySQL
https://tanin.nanakorn.com/one-more-re

Hm. I normally use #postgres container because I can just increase the version in my

GitHub - pgautoupgrade/docker-pgautoupgrade: A PostgreSQL Docker container that automatically upgrades your database
A PostgreSQL Docker container that automatically upgrades your database - pgautoupgrade/docker-pgautoupgrade

#PgBouncer is useful, important, and fraught with peril
https://jpcamara.com/2023/04/12/pgbouncer-is-useful.html