2024-01-31
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
2024-01-31
2024-01-30
How To Get Into Trouble Using Some Postgres Features
Anti-know how for postgres.
2024-01-29
How To Monitor CREATE INDEX / REINDEX Progress In Postgres 12+
Another great bit of postgres know how.
2024-01-26
Please Identify Yourself! Digital Identity Systems In The EU & Around The World
Good talk about the future of national digital identity and the complete failures we can learn from.
2024-01-19
Do Users Write More Insecure Code with AI Assistants?
Do Users Write More Insecure Code with AI Assistants? The answer is apparently, yes.
2024-01-19
Lecture Friday: Impossible Programs
If you don't know what the halting problem is, this is probably the easiest explanation to follow.
2024-01-12
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.
2024-01-05
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.
2024-01-03
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.