First published on the Tech Style blog. Most Oracle to PostgreSQL projects are priced before anyone has read the code. Someone counts tables and guesses at the PL/SQL, and the expensive surprises turn...
Oracle AI Database 26ai Release 23.26.4 introduces support for combining Top-N queries using the FETCH FIRST clause with FOR UPDATE [SKIP LOCKED]. This enhancement allows applications to retrieve and ...
Introduction Imagine your application has only 50 users during development. Everything works fine, and your database queries are fast. A few months later, your application grows. Now, your users col...
Chapter 12 spent several pages arguing that the only guard against assigning the same product to the same category twice is a unique constraint on (category_id, product_id). It rejected a pessimistic ...
Nov 2nd 2026
Across ten years of backend work I've shipped production systems on MySQL, PostgreSQL, DynamoDB, MongoDB, Elasticsearch, Neo4j, Redis, Redshift and BigQuery. The rule I keep coming back to: write down...
Nov 2nd 2026
Who are the friends of my friends? in Graph Databse Continue reading on Medium »
Command TimeoutException — the call-out word of this blog. This means that the Redis client sent a command to the server, but the server… Continue reading on Medium »
A database can store millions of customer records — perfectly indexed, structured into elegant star schemas, and running on high-end cloud… Continue reading on Medium »
Nov 2nd 2026
Taking DuckDB beyond the local process: Memory boundaries, network listeners, and remote client connections. Continue reading on Medium »
An Introduction to Structured Query Language, Database Systems, and How They Work Together Continue reading on Medium »