View all

Fintech companies are modernizing how they store and process institutional and retail trades. To understand how, we must first take a quick look at why – what these companies used to do, and why that approach is no longer considered acceptable.

Would you fly in an aircraft that wasn’t tested? Get behind the wheel of a car whose model hadn’t been crash-tested? What about using a distributed database for storing your mission critical data that hadn’t been tested and gone through quality assurance? I’d happily wager that if you are a database developer, then anyone that makes use of your database - whether that be directly (developer or database administrator), or indirectly (you, as the end-user of a product that most likely makes use of a database) - is going to feel a whole lot better when you tell them that you test the database. Testing is a fundamental and well accepted part of building functional software.

One caveat before we dive into this comparison of CockroachDB and Google Cloud Spanner: I am not a Spanner expert. I have studied their documentation, tried the product and know their use cases well enough to state that Spanner is an amazing database. In this blog I am not going to unpack all the architectural details of Spanner as that would be a much longer post and I simply would not feel comfortable doing so. I’m going to point out interesting areas in which CockroachDB is distinct from Spanner. Here’s a short video in case you’d rather consume the information that way:

Jim Walker

April 24, 2023

CockroachDB is an excellent system of record, but no technology exists in a vacuum. Some of our users would like to keep their data mirrored in full-text indexes to power natural language search. Others want to use analytics engines and big data pipelines to run huge queries without impacting production traffic. Still others want to send mobile push notifications in response to data changes without doing the bookkeeping themselves.

Nearly every organization has critical systems that need to be up at least 99.99% of the time. Typically, these systems need to recover from downtime in seconds with no data loss while serving vital customers located across an entire country, many countries, or even continents.

It’s estimated that there’s over 380 million people across the globe that are active on online dating apps – and that number is only growing. In fact, the market for online dating services is projected to reach 9.2 billion USD by 2025. That’s a lot of swiping!

Cassie McAllister

April 16, 2023

In the context of a database and how it’s organized, the term database schema describes the structure of the data and how the elements within the database relate to each other. This information is often presented visually with diagrams that illustrate how different tables and elements connect and to give you a logical view of the entire database. However, the schema itself exists in the database as the coded rules that define the data’s structure and relationships.

Charlie Custer

April 13, 2023

My current employer uses sharded and replicated Postgres via RDS. Even basic things like deploying schema changes to every shard are an unbelievable pain in the ass, and changing the number of shards on a major database is a high-touch, multi-day operation. After having worked with Spanner in the past, it’s like going back to the stone age, like we’re only a step above babysitting individual machines in a closet. Nobody should do this. — HackerNews user GeneralMayhem

Michelle Gienow

April 12, 2023

So you need to scale. That’s a good problem to have! But should you scale up or scale out? There’s no easy answer, so let’s take a closer look at horizontal scaling vs. vertical scaling , how they compare, and what the pros and cons are for each approach.

Charlie Custer

April 10, 2023