Browsing Tag
database
236 posts
Debugging PostgreSQL Performance
Let’s chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN ANALYZE output fluently? Do…
How to Evaluate Vector Databases in 2026
In 2026, a synthetic performance crisis challenges the vector database market. A GitHub search for “vector database benchmark”…
Your Repository Isn’t a Repository, It’s a DAO
Book: Decoupled PHP — Clean and Hexagonal Architecture for Applications That Outlive the Framework Also by me: Database…
Stop Naming Your Healthcare Columns Wrong — ISO-11179 Explained
If you’ve ever inherited a healthcare database with columns named DOB, PatientID, or CLAIM_NUMBER — this guide is…
O que é ACID?
O que é ACID? Imagine um sistema de compra de ingressos, onde você precisa comprar um ingresso para…
The Day ‘Containers Everywhere’ Met a Database – Part 3
In Part 1, we introduced a client moving from a monolithic system towards a microservices-based architecture on AWS,…
Cache Stampede Prevention
When Your Cache Chokes: Taming the Cache Stampede Ever felt that exhilarating rush when your application is humming…
Cursor Rules for MongoDB: The Complete Guide to AI-Assisted MongoDB Development
Cursor Rules for MongoDB: The Complete Guide to AI-Assisted MongoDB Development MongoDB is the database where “schemaless” gets…
SQLite Is All You Need (Until It Isn’t) — A Practical Guide
I run 4 production SaaS products on SQLite. Not PostgreSQL. Not MySQL. SQLite. Before you close this tab…
SQL Subquery and CTEs( Common Table Expressions)
What is a subquery? Subquery is a query nested inside another query statement. It allows the query to…