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
Day 8 - Relational Database 101 - PostgreSQL Internals
3+ hour, 15+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...
Why Parameterized Queries Matter for SQL Security
3+ hour, 36+ min ago (559+ words) SQL injection is one of the classic examples of what can happen when an application mixes user input directly into a database query. The underlying problem is simple. The application expects data. The database may interpret part of that data…...
Recursive CTEs: How SQL Secretly Learned to Loop
4+ hour, 31+ 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
31+ 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 …...
EXPLAIN Describes a Query. Production Is Everything Else That’s Running.
2+ hour, 25+ min ago (1398+ words) A while back I wrote about migrating a terabyte of banking data from Oracle to PostgreSQL with no downtime. The part people …...
I Replaced Chroma, Qdrant, and Pinecone With a SQLite File
2+ hour, 21+ min ago (165+ words) I needed a vector DB that didn’t require a daemon. SQLite was already there. Every RAG tutorial starts the same way. Step one: install …...
Every text-to-SQL benchmark score you've seen was measured without access control
7+ hour ago (955+ words) Spider, BIRD, LiveSQLBench. If you have evaluated a text-to-SQL system in the last five years you have quoted a number from one of them. All three ask the same question: given a schema and an English question, does the system…...
IEnumerable vs. IQueryable in C#
9+ hour, 4+ min ago (429+ words) This distinction sounds simple stated this way, but it has real, concrete consequences for where computation happens, how much data crosses the network, what C# expressions are even legal to write, and a specific, common class of bug that this…...
Pattern #007: Moving / Rolling Windows in SQL
8+ hour, 58+ min ago (33+ words) How to calculate what happened over the last N days — without confusing it with a running total A product manager asks: “What was our average daily …...
Expand, migrate, contract: the only database migration pattern a small team needs
15+ hour, 45+ min ago (195+ words) Small teams don't get a DBA or a staging cluster that matches production. The one rule that carries most of your safety: never change a live schema in place. Expand, migrate, contract. Why: on a 40M-row table, a naive in-place…...