Faster Prisma + StackRender Workflow Designing a database schema is often one of the slowest parts of starting a new backend project. You either spend time wri...
Full‑Text Search for a Next.js Blog PostgreSQL + Neon + Drizzle ORM > Based on the workshop by Brian Holt Frontend Masters. The goal is to add a fast, relevanc...
!Cover image for The N+1 Insert Loop That Slowed Our API to a Crawlhttps://media2.dev.to/dynamic/image/width=1000,height=420,fit=cover,gravity=auto,format=auto/...
Most developers know about SQL injection. Few know about search_path hijacking. It’s just as dangerous. What is search_path? PostgreSQL’s search_path determine...
Recently I started learning Docker and trying to understand how it actually works behind the scenes—how the Docker Engine works, how containers are isolated, an...
Problem js // ❌ Dangerous: Transaction on pool async function transferFundsfrom, to, amount { await pool.query'BEGIN'; await pool.query'UPDATE accounts SET bal...
It was 3 AM. PagerDuty woke me up. Our API was returning 500 errors. The database was fine. CPU was fine. Memory was fine. But every query was timing out. FATAL...
Quick Install bash npm install --save-dev eslint-plugin-pg Flat Config js // eslint.config.js import pg from 'eslint-plugin-pg'; export default pg.configs.reco...
Article URL: https://obeli.sk/blog/announcing-obelisk-0-32/ Comments URL: https://news.ycombinator.com/item?id=46424789 Points: 9 Comments: 1...
The Problem: The Full Table Scan Imagine a library with 1 million books. If you want to find The Great Gatsby and the books aren't organized, you have to look...
The database serves as the primary foundation of Academic Suite. In an online exam system, improper database schema design can lead to serious bottlenecks, espe...
What Happened? Imagine you have a table called organizations full of precious data. You decide to add a new column called plan. If you add it as NOT NULL, ever...
