Articles for people who
ship the stack
Original rewrites on React, Node.js, TypeScript and AI — practical notes from the same engineering practice behind our operator software. Article bodies are in English.
Tagged: databases
The 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.
1617 wordsRead articleBuilding 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.
1020 wordsRead articleRaw SQL, Prisma, or Drizzle: How to Actually Choose a Database Layer
Understand how raw SQL, Prisma, and Drizzle differ in control, type safety, and developer experience, and learn a practical way to pick the right one for a project.
3519 wordsRead articleCutting 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.
1747 wordsRead articleCommon 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.
1442 wordsRead articleVector Databases Explained: How Machines Search by Meaning
Learn how vector databases convert text into numerical embeddings to enable semantic search, and how they differ from traditional databases.
1497 wordsRead article
About these articles
Request a 24h estimate
Need the same stack in a production operator layer? Send the brief — estimate within 24 hours.