Today I Learned

Short notes on things I am learning. Inspired by Simon Willison's TILs.

Browse By Topic

Recent TILs

PG will not run CTEs unreferenced

Postgres will not run any CTEs not referenced in the main query. It’s a form of optimization in newer versions.E.g.,WITH will_not_run AS (SELECT 1/0), ok AS (SELECT 1)SELECT * FROM ok;

Primary and second replicas in Postgres

database

In Postgres, you can have a primary read/write instance, and a read only hot-standby to serve requests at a high volume. When you update the primary replica, it sends updates via a stream of logs to the replica.If the...

All TILs By Topic

database

llm