The article delves into the intricacies of indexing in various relational databases: SQL Server, Oracle, MariaDB/MySQL, and PostgreSQL. Each database system’s section elucidates the creation and purpose of different index types, from primary and unique indexes to specialized ones like full-text and spatial indexes. The discussion culminates in a poignant analogy, likening database indexes to... Continue reading →

Here are summaries of each of the tools you’ve mentioned along with examples of how to implement the ETL (Extract, Transform, Load) process using each tool within a Python workflow: Continue reading →

Starting to use, or interested in using MariaDB? This is a getting started post that will get you started with MariaDB and SkySQL. Prerequisite knowledge of SQL is helpful, but I step through every single little detail in this post to get you up and running, with a good context of what you’re getting. Continue reading →

Here is my updated schedule for the two weeks starting the 23rd for my Twitch streams, the basic topics, meetups (a little beyond two weeks), and related events coming up. Series: Thrashing Code General Calamity This is going to be a mix of tech this week. Probably some database hacking, code hacking, samples, and setup... Continue reading →