Low-privilege database accounts that cannot read a single application table can still be used to run code on the database server itself, a researcher has shown, by reaching memory-corruption bugs in the engine code behind ordinary SQL. The exploits, published yesterday, are the researcher's proofs…
Two readers asked me the same question from opposite sides last week, and I have been running it ever since. itsvicmoreno asked it on my piece about claiming a delivery once: the processed-keys table stops the second copy, but what if the receiver crashes between writing the key and charging the…
Database performance work usually begins with someone proposing a bigger instance, and it usually ends with the discovery that one query was doing a sequential scan over four million rows on every page load. The hardware was never the constraint. The plan was. That pattern is consistent enough to…
When building a database engine from scratch, one of the most important concepts you need to understand is serialization and deserialization . You might be wondering: How does a database store data on disk? How does it convert a C structure into bytes? How does it read those bytes back into memory?…
Summary: Should you keep the default initialization parameters or apply a predefined configuration baseline? Instead of relying on experience or copying someone else's settings, this guide shows how to run a reproducible comparison test for GBase Database(GBase 8s), measure the results, and…
The Fake 96,000-Patient Database That Sank Hydroxychloroquine... And Medicine's Growing Black-Box Authored by Maryanne Demasi via Brownstone Institute , On May 22, 2020, the Lancet published a study that changed the course of the Covid-19 pandemic. It purported to analyze the medical records of…
A Database Table Is Not a Business Object You have a Customers table. Do you have a Customer? You have a SalesOrder table. Do you have a Sales Order? If your answer is "yes, because that is where they are stored," you have treated two different things as one. Even experienced developers make this…
When developing an application, the database structure rarely stays the same. At the beginning of a project, you might have only a users table. A few weeks later, you may need to add an email column, create a products table, introduce new relationships, or modify existing constraints. But here's a…
SaaS Image Storage: Object Storage vs Database Blobs vs Local Disk (My Choice) Short answer: use object storage for generated images, keep metadata in your database, and treat the object key as the join between them. It is the least complicated production shape once images get large or the app…
A 48-byte record holds a 4-byte column you actually need. Reading that one column through a row-oriented layout pulls twelve times more bytes from memory than the query uses, because the CPU cannot fetch four bytes without fetching the 44 bytes sitting next to them. Multiply that by a hundred…