Posts tagged "databases"
7 posts tagged with databases.
UUID vs ULID vs Nano ID vs CUID: Which Identifier Should You Use?
Random IDs are everywhere, but the trade-offs differ. We compare collision odds, sortability, length, and database performance for the four most common modern ID schemes.
How Snowflake IDs Power Twitter, Discord, and Distributed Systems
When monotonic auto-increment IDs break at scale, Snowflake IDs step in. We unpack the 64-bit layout, clock-skew problems, and why every major distributed system has its own variant.
Data Normalization Explained: 1NF, 2NF, 3NF Without the Jargon
Normalization rules sound abstract until you see what a denormalized table looks like after six months of updates. This guide explains the normal forms using simple, concrete examples.
How SQL Query Planners Decide What Your Query Does
You write SQL declaratively, but the database engine decides how to execute it. We open up Postgres EXPLAIN to show how query planners actually choose strategies.
Understanding Database Indexes: How They Work and When to Use Them
An index can turn a ten-second query into a millisecond query — or slow down your writes significantly if misused. Understanding the data structure behind indexes makes both outcomes predictable.
NoSQL vs SQL: Choosing the Right Database for Your Project
The choice between SQL and NoSQL is not about which is better — it is about matching the data model to your access patterns. Here is a framework for making that decision with confidence.
SQL Basics: From Zero to Writing Real Queries
SQL is one of the most valuable skills a developer can have — and the fundamentals are surprisingly approachable. Start here to write your first real queries confidently.