database
6 articles tagged with "database"
Tech Feeds
How to Check 10 Million Usernames in Under 1 Millisecond
Every second, platforms like GitHub, Instagram, and Twitter process thousands of username availability checks. A seemingly simple operation that becomes a critical performance bottleneck at scale. I b...
clockworklabs/SpacetimeDB: Development at the speed of light
Development at the speed of light
SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF
SQL Normalization vs Denormalization: A Beginner-Friendly Guide When designing a database, one of the most common questions is: Should I normalize my tables, or denormalize for performance? Let’s br...
FLOSS Weekly Episode 861: Big Databases with OpenRiak
This week Jonathan chats with Nicholas Adams about OpenRiak! Why is there a Riak and an OpenRiak, which side of the CAP theorem does OpenRiak land on, and why is …read more
SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG
Today was one of those SQL days where things look simple… until you actually write the query. I focused on GROUP BY, HAVING, and the basic aggregate functions: MIN, MAX, and AVG. These are things I’ve...