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
My Cron Job Double-Fired and Placed the Same Order Twice — Here's My Postmortem
29+ min ago (879+ words) I keep a Mac Mini in a closet running a handful of small scheduled Python jobs. One of them scans market data on a schedule and, when its rules fire, places tiny orders through an exchange API. Positions are around…...
Day 8 - Relational Database 101 - PostgreSQL Internals
5+ hour, 36+ min ago (1576+ words) একবার একটু technological দিকে আসি, আপনি যখন Facebook বা LinkedIn-এ কাউকে message করেন তখন সেটা সরাসরি তার কাছে send হয়। Reason হচ্ছে আপনারা connected। এখানে আপনি directly message ত…...
Why Parameterized Queries Matter for SQL Security
5+ hour, 57+ 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…...
Database Isolation Levels: What Can Concurrent Transactions Actually See?
2+ hour, 20+ min ago (743+ words) Transactions do not execute in isolation from reality. Isolation levels define how much of that reality they are allowed to observe. In the previous topic, we explored Optimistic and Pessimistic Concurrency Control. Now we can go one level deeper. What…...
Recursive CTEs: How SQL Secretly Learned to Loop
6+ hour, 52+ 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
2+ hour, 52+ 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.
4+ hour, 46+ 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
4+ hour, 43+ 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
9+ hour, 21+ min 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…...
Linux common commands every developer should know
10+ hour, 45+ min ago (159+ words) The command line is one of the most powerful and efficient ways to interact with Linux systems. For developers, knowing the commands can make tasks much faster and easier. This article provides a reference of useful Linux commands for developers....