· software
Why isn't 'majority' the default read concern in MongoDB?
TL;DR If you’re used to traditional SQL databases and synchronous request‑response flows—where you read your writes in the same transaction or session—use the...
-
- · software
You Can't Resize a Bloom Filter. Here's What To Do Instead.
What Are Bloom Filters? Bloom filters are a probabilistic data structure that use a bit array and hash functions to reduce the load on main databases. You migh...
- · software
Lazy vs. Eager Loading & JPA Relationships
markdown !Forem Logohttps://media2.dev.to/dynamic/image/width=65,height=,fit=scale-down,gravity=auto,format=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2...
- · software
How JOIN FETCH Reduced Database Load by 94%: A Real-World Case Study
Introduction The N+1 problem is one of the most common causes of high database load in Spring Boot applications. In this article, I’ll show you how to systemat...
- · software
Avoid UUIDv4 Primary Keys
Introduction Over the last decade, when working on databases with UUID Version 4^1 as the primary key data type, these databases have usually had bad performan...
- · software
SQLite JSON at Full Index Speed Using Generated Columns
Article URL: https://www.dbpro.app/blog/sqlite-json-virtual-columns-indexing Comments URL: https://news.ycombinator.com/item?id=46243904 Points: 8 Comments: 1...
- · software
When MySQL InnoDB's Engine Redo Log Saved Your Startup
The Lighthouse Keeper Analogy Think of InnoDB's redo log as a lighthouse keeper's journal. Before modern GPS, lighthouse keepers kept meticulous logs: - “3:15...
- · software
100k TPS over a billion rows: the unreasonable effectiveness of SQLite
Article URL: https://andersmurphy.com/2025/12/02/100000-tps-over-a-billion-rows-the-unreasonable-effectiveness-of-sqlite.html Comments URL: https://news.ycombin...