Install
Please confirm you are human
This browser or connection looks automated. Press and continuously hold the control for 3 seconds to enable Google-hosted web results and, when separately allowed, AI-assisted answers.
A successful check enables 100 search requests. Interactive access does not authorize scraping, systematic collection, or reuse of search output.
News
MySQL Overselling: Why SELECT Isn't Enough and How SELECT... FOR UPDATE Solves It
8+ hour, 3+ min ago (431+ words) Imagine you’re running an online store, there’s exactly one item left in stock. Two customers click... Tagged with database, mysql, backend, softwareengineering....
Data Substrate Versus Vector Db Rag
7+ hour, 54+ min ago (1246+ words) This week’s headlines highlight the rapid evolution of AI in China, with models like Qwen and DeepSeek pushing the frontier of capability. But as these models grow more sophisticated, the conversation around how data is stored, queried, and used as…...
Two Transactions, One Row: What Does MySQL Actually Let You See?
8+ hour, 4+ min ago (554+ words) Two users, One database row, Both reading and writing at almost exactly the same time. Who sees... Tagged with database, mysql, softwareengineering, backend....
Day 8 - Relational Database 101 - PostgreSQL Internals
19+ hour, 34+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...
Recursive CTEs: How SQL Secretly Learned to Loop
20+ hour, 49+ min ago (454+ words) Ask a SQL query to find "all employees under this manager," and things get ugly fast if you don't know how many levels deep the org chart goes. A regular join handles one level. Two joins handle two levels. Nobody's…...
The SQL Queries That Lie to You With a Straight Face
16+ hour, 50+ min ago (191+ words) Seven queries that run without error, return a result, and are still wrong — and how to stop writing them. Some SQL mistakes throw an error …...
Nile isolates Postgres tenants with a tenant_id column and one session variable
1+ day, 14+ hour ago (364+ words) Disclosure: I have no affiliation with Nile. Nobody asked me to write this and nobody paid for it. I signed up for their free tier like anyone else would. I'm on my way to test products and share my findings…...
How Database Connection Pooling Actually Works
1+ day, 12+ hour ago (22+ words) Your database looks fine. Your app still hangs. Here's how connection pooling actually works and why the two aren't the same problem....
Window Functions Are the SQL Superpower Nobody Taught You
1+ day, 17+ hour ago (26+ words) Running totals, top-N-per-group, and row comparisons — without the self-join headache. A practical walkthrough with real code and a cheat sheet. Tagged with sql, dataengineering, database, programming....
Stop Trusting the App: Enforcing Append-Only at the Database Layer
1+ day, 19+ hour ago (419+ words) Most "audit logs" are append-only by convention, not by enforcement. The application inserts a row and politely promises never to UPDATE or DELETE it. That promise holds right up until the moment someone does one of these: If a third…...