Using ChatGPT to Write SQL

Working in technology, I’ve heard a number of things about ChatGPT from various news sources.

I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I heard a teacher talking about how this was the new ‘calculator’ that teachers need to learn how to leverage in their curriculums.… Read the rest

Continue reading »

Introducing: Roll for Database!

Alright, so I’m playing around with something. I’ve developed a bit of a TikTok addiction after exploring the platform to connect with my 14-year-old. One of the post types I’ve enjoyed is the “Roll for ______” type, where the content creator uses dice typical to Dungeons and Dragons to choose combinations of things that are sometimes magical, sometimes ridiculous, and occasionally disgusting.… Read the rest

Continue reading »

The Most Shocking Differences I’ve Seen Between Db2 and MySQL (so far)

As I’ve been learning the details of MySQL, there have been a lot of similarities with Db2, and a number of differences. Some of those differences have been things I was expecting, while others have been a bit more shocking. If others are making the transition from Db2 to MySQL (using InnoDB) or vice versa, or are supporting both, maybe something here will help.… Read the rest

Continue reading »

SQL Anti-Pattern: Indexing Every Column Individually

Indexes are magic, right? Add one and magically the performance of a query improves.

Well, not really. Each index has a cost, and thoughtful multi-column indexes will go a lot further than individual indexes. Let’s dig into the details.

What an Optimizer Does

Relational databases require queries to specify what data they want returned with no specification of where that data is on disk.… Read the rest

Continue reading »