It sounds like a small detail, but it was made for a very specific job: letting many workers take tasks from the same table without blocking each other. Oracle used it internally for its own message queues as early as…
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…
If your SQLite app reads PRAGMA user_version to decide which migrations to run, and your backup is a sqlite3.dump, a restore can bring back every row and still be refused. The dump never writes user_version or application_id, so the restored file reads 0 for…
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…
Ever wondered how databases can tell you "this username is definitely not taken" in milliseconds without scanning millions of records? Or how caching systems avoid expensive database lookups for keys that don't exist? The secret is a probabilistic data structure…
A MongoDB replica set can tell your app a write succeeded and then lose it. That isn't a bug, it's what the write concern you choose allows. I wanted to see it happen, count it, and find out where the…
En la Parte 5 de nuestra serie logramos un hito fundamental: desplegar la arquitectura completa de LifeOps en producción 24/7 a coste cero ($0/mes) combinando Netlify, Render y Supabase, optimizando la ergonomía táctil en smartphones e instalando la aplicación como PWA nativa.
Welcome to our weekly log for the Supabase.NET SDK 🎉 So, I have finally some blog posts to share! There are also a couple of entries on Supabase's Changelog: Changelog entries come with their own discussion thread on GitHub, so…
Welcome to our weekly log for the Supabase.NET SDK 🎉 As mentioned in the previous post, I focused on the automatic generation of our feature compliance file, which is now done. The SDK provides annotations we place on public members…
Relational & NoSQL databases, search, caches, streams, ETL/ELT, and analytics stacks.
An article joins this feed when it matches these terms. Each one is also a search of its own.