How To Determine The Replication Lag
Not something I really worry about, but I'm sure some applications need to care.
Today I Learned
January 2024
How To Get Into Trouble Using Some Postgres Features
Anti-know how for postgres.
How To Monitor CREATE INDEX / REINDEX Progress In Postgres 12+
Another great bit of postgres know how.
Please Identify Yourself! Digital Identity Systems In The EU & Around The World
https://media.ccc.de/v/37c3-12004-please_identify_yourself
Good talk about the future of national digital identity and the complete failures we can learn from.
Do Users Write More Insecure Code with AI Assistants?
https://arxiv.org/abs/2211.03622
Do Users Write More Insecure Code with AI Assistants? The answer is apparently, yes.
Lecture Friday: Impossible Programs
If you don't know what the halting problem is, this is probably the easiest explanation to follow.
Lecture Friday: What Everyone in Tech Should Know About Teaching and Learning
Pedagogy is a skill not enough people who give talks know. Best to learn and practice before you get on stage.
Lecture Friday: Why Isn't Functional Programming the Norm?
Great talk about the history of many languages. I do like that we don't have to commit to purely functional languages. You really should be writing more pure functions though. I get side effects are necessary and mutable state is faster. That doesn't mean you can't collect the mutability and side effects into isolated portions of the whole.
EXPLAIN ANALYZE or EXPLAIN (ANALYZE, BUFFERS)?
I always forget to do this in Postgres. Though arguably it's usually not an issue since most of the performance issues I track down are pretty obvious when you see the query planner trying to run a nested loop join.