Dirty reads, phantom reads, and the setting that quietly decides how safe your Django data really is. Every Django developer uses database transactions. Far fewer know that transactions come with a dial: a setting called the isolation level that silently…
Your API returns "200 OK". Your monitoring dashboard shows no errors. And you might have just exposed another customer's data. That's what makes cross-tenant data leaks dangerous. They don't always crash your application. They don't necessarily trigger database errors. Sometimes, the…
Short version for the impatient: before you pick an Oracle to PostgreSQL migration tool, ask it for the list of things it refuses to convert. That list is your quote. The converted DDL is the cheap part. If you quote…
LINQ looks like a tidy query language and is really two very different engines — in-memory delegates vs database expression trees — behind one syntax. Knowing which one you're in, and when it runs, is the whole senior game. This is 30 questions…
I had a nightly job that reads a partner CSV and sums the amount column, just to sanity-check a total before the real import runs. Boring code. row.Split(','), grab field one, parse it, add it up. It worked the…
Moving to transaction-mode PgBouncer broke our schema resolution and took prod down on the pool cutover. The fix was to stop setting search_path from the app. Tagged with postgres, docker, devops, springboot. Liquid syntax error: Unknown tag 'endraw' Templates let you…
Before optimizing, you must understand what the server actually does. The aggregation pipeline is not a single monolithic operation — it's a sequence of stages, each transforming a stream of documents. The query optimizer builds an execution plan that can reorder,…
Read a PostgreSQL execution plan node by node, compare estimated and actual rows, spot sequential scans, spilling sorts and loops, and choose the right fix. This is for developers and DBAs who have a slow query and want a repeatable…
I've started letting Claude Code and Codex work against my dev databases, and the part that worried me was the database itself. Claude Code checkpoints rewind files. A bad DELETE stays done. Permission prompts help, but they live in the…
Here's the post, ready to paste. I haven't read the challenge page, so I picked the "ghost" reading myself. Change it if the page points elsewhere. I left [brackets] wherever I don't know the facts: the AI model, any demo…
SQL, Bash/PowerShell, and scientific computing languages for analysis and ops.
An article joins this feed when it matches these terms. Each one is also a search of its own.