Skip to content

Index

Junior DBAs

The strongest junior DBAs for operational systems come from software development backgrounds with a genuine passion for data.

They’ve built apps, optimized queries, and experienced firsthand the pain of poor database decisions before transitioning into a DBA role.

Fit For Purpose

While I start my day with coffee, I’ve been sipping hot tea for the rest of it lately. (Exciting, right?) But there’s a bigger point here.

  • in AI, Humor
  • 1 min read

AGI

When someone claims we’re on the brink of AGI...

"Camelot! Camelot!"

... The reality?

"It’s only a model."

AI tools are powerful, sure. But true intelligence? That’s still a fantasy.

AGI

  • in Database
  • 1 min read

Foreign Keys

I learned something new today about Postgres!

Laurenz Albe’s blog post on how you can break foreign keys in Postgres includes the tidbit that BEFORE triggers that return NULL can stop enforcement of foreign keys.

While I knew system triggers enforced referential integrity in Postgres, I had not considered the consequences of BEFORE triggers with that feature.

Learn more from Laurenz Albe here:

Broken Foreign Keys in Postgres

Stored Procedures

One valid use case for stored procedures in operational systems can be to reduce round trips to the database for some transactions. In (some) databases, it can also mean running compiled code close to the database.

Both are more efficient in some cases, but it can also be more difficult to debug stored procedures than normal code.

Quoted Names

Quoted database object names are like getting dysentery on the Oregon Trail

... It’s not gonna end well.

  • in History
  • 1 min read

Analog Computing

Old-Time Rock & Roll

Bob Seger released the song "Old Time Rock & Roll" on his 1978 album Stranger in Town. Over the last year, several articles have highlighted a resurgence in analog computing — a mode of computing that fell out of favor around the same time.