database
11 articles tagged with "database"
Tech Feeds
Commentary: Confluent Data Streaming World Tour 2026 Mumbai
The Confluent Data Streaming World Tour 2026 in Mumbai highlighted a significant shift in how we look at and process the data. The core message was simple: if you want AI to work in production, real-t...
Why monitoring your search engine matters: Manticore ➡ Prometheus ➡ Grafana
One of our users reached out recently with a familiar problem: search had suddenly become noticeably slower, even though nothing looked obviously broken. The service was up, no errors in the logs, CPU...
PostgreSQL Internals: Inside the Storage Engine
Post 2 gave you the data structures: B+Tree, B-Tree, LSM Tree - how they're shaped and the tradeoffs they do. This post traces an INSERT and a SELECT through both PostgreSQL and MongoDB, step by step,...
Announcing Amazon Aurora PostgreSQL serverless database creation in seconds
AWS introduces a new express configuration for Amazon Aurora PostgreSQL, a streamlined database creation experience with preconfigured defaults designed to help you get started in seconds. With Aurora...
From firefighting to building: How AI agents restored our team’s core productivity
Abstract Grab’s Analytics Data Warehouse (ADW) team supports over 1,000 users each month and manages an extensive repository of more than 15,000 tables, which powers approximately 50% of all queries w...
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...