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 →

Notes on the talk… If it’s not SQL it’s not a database. Watch, you’ll get to hear why… ha! Then Jonathan covers the recent history (sort of recent, the last ~20ish years) of the industry and how we’ve gotten to this point in database technology. It takes 5+ years to build a database. Also the... Continue reading →