Blog
Product
A sports betting app saved millions switching from PostgreSQL to CockroachDB
The challenges facing sports betting platforms are rigorous: they have to be fast and consistent in a way that’s similar to high-frequency trading platforms. At the same time, they have a variety of data-locality requirements to comply with depending on which states or countries they serve. In this blog, we’ll look at a real-world example of a North America-based sports betting platform that designed a gaming and sports betting architecture that not only meets the performance, consistency, and compliance requirements of the industry; but also enabled the business to swiftly enter new regional markets without requiring a massive engineering effort.
Michelle Gienow
February 9, 2024
No Dirty Reads: Everything you always wanted to know about SQL isolation levels (but were too afraid to ask)
Every relational database needs to establish a balance between accuracy and performance. Transaction isolation levels have a direct, though often unrecognized, impact on both.
Michelle Gienow
February 8, 2024
What is a DBaaS, and why would you want one?
What are the advantages and disadvantages of managed database-as-a-service offerings, and why should you consider letting someone else operate your database?
Charlie Custer
February 1, 2024
Performance
What is distributed SQL? An evolution of the database
Distributed SQL combines the consistency and structure of the early relational databases with the scalability, survivability, and performance first pioneered in NoSQL. Distributed SQL databases like CockroachDB use this architecture to provide a single logical database that replicates data across multiple physical nodes at any scale, on any infrastructure, and anywhere in the world.
Jim Walker
February 1, 2024
Isolation levels without the anomaly table
Forget the anomaly table. Here's what the different transaction isolation levels mean for the design and implementation of *your* app.
Ben Darnell
January 31, 2024
Physical Cluster Replication: Your Disaster Recovery Plan
When you are an enterprise application owner, whether architect or operator, regional survivability is at the top of your list of must-have database features.
Michelle Gienow
January 29, 2024
How we stress test and benchmark CockroachDB for global scale
How do we know what our database is actually capable of? We test it. A lot. Here's a summary of some of the tests and benchmarks we run regularly to ensure CockroachDB is performant even at global scale.
Stan Rosenberg
January 25, 2024
Product
How to build an inventory management system that scales (with reference architecture)
One of the biggest technical challenges of inventory management is keeping data consistent in real time, or as close to it as possible. Particularly with larger operations, this is vital to avoid “overselling” scenarios that can cost the company money or damage its reputation.
Charlie Custer
January 25, 2024
Product
Top Three Reasons Behind Database Migrations
I recently moved into a new house. Boxes are everywhere. Little pieces of styrofoam surprise me everywhere I go. There are many noises I don’t recognize or understand. And the drill I’d forgotten I even owned now occupies a prime spot on my kitchen counter. I use it daily. I didn’t move to a new house because I thought moving would be fun, or even easy. I knew it would be a lot of work. I moved because my family needed more space. Which is just one of many reasons someone might decide to endure the pain of moving: Cost. Quality of life. Proximity to the people/places that are important to you.
Adam Storm
January 24, 2024