Articles for people who
ship the stack
Rewrites on React, Node.js, TypeScript and AI. A translated body is shown when it exists. If it does not, you see the English text and a note that says so.
Tagged: Databases
Drizzle vs Prisma: Choosing a TypeScript ORM Without the Hype
Compare Drizzle and Prisma on schema design, query style, nested writes, migrations, transactions and performance, with advice on which one fits which team.
7 min readThe GraphQL Query That Exhausted the Database Pool
One nested GraphQL document burned out a production database. Why rate limits, HTTP timeouts, and DataLoader failed — and the four bounds that finally contained it.
7 min readBuilding MongoDB Aggregation Pipelines with $match, $group and $lookup
Learn how MongoDB aggregation stages filter, group, reshape, join and sort documents, and how to chain them into a pipeline that answers real reporting questions.
4 min readCutting Prisma and PostgreSQL Load Before You Pay for a Bigger Database
Fifteen practical techniques, from EXPLAIN ANALYZE and composite indexes to N+1 fixes, counters, pooling and vacuum, for reducing Prisma database operations.
8 min readRaw SQL, Prisma or Drizzle: Choosing a Database Layer for Type Safety and Control
How raw SQL, Prisma and Drizzle differ in control, type safety and developer experience on PostgreSQL, and a practical way to pick one for a TypeScript app.
15 min readCommon Node.js and Database Misconceptions That Cause Production Bugs
Learn why async/await, connection pooling, and ORMs don't automatically prevent race conditions, connection exhaustion, or SQL injection in Node.js apps.
6 min readVector Databases Explained: How Machines Search by Meaning
How a vector database turns text into embeddings so semantic search finds results by meaning, and how it differs from a traditional row-and-index database.
7 min read
About these articles
Request a 24h estimate
Need the same stack in a production operator layer? Send the brief — estimate within 24 hours.