Medium·2yWhy UUID7 is better than UUID4 as clustered index
This post discusses the differences between UUID version 4 and UUID version 7 as clustered indexes in a database. It explores the pros and cons of using UUIDs instead of sequential IDs and explains why UUID version 7 was faster than UUID version 4. The experiments and results are presented, along with an explanation of index locality and buffer pool in relation to the performance differences.
gitconnected·2yMastering SQL Fundamentals
This post provides a comprehensive guide to mastering SQL fundamentals, covering database terminology, relational models, applying SQL to real data, creating a new schema in MySQL, querying data using the SELECT statement, filtering data using the WHERE clause, ordering results using the ORDER BY clause, using logical and special operators, and understanding the importance of query efficiency. Mastery of SQL is emphasized as a valuable skill for data professionals.
TigerData (Creators of TimescaleDB)·2yPostgreSQL vs MySQL: Which to Choose and When
Comparison of PostgreSQL and MySQL as relational databases. Explore their similarities, strengths, and weaknesses. Learn about their features and decide the right database solution based on your project requirements, scale, and data operations.
PlanetScale·2yWorking with geospatial features in MySQL
This post explores how complex data and geographic features can be represented in MySQL. It covers the spatial data types supported by MySQL, the primary spatial data formats, and common spatial functions used for manipulating and analyzing geographic data in MySQL.