View all

JSON is a ubiquitous data interchange format supported by many systems, including CockroachDB. Historically, at CockroachDB, the majority of our efforts around JSON focused on supporting various JSON functions, operators, and inverted indexes while our JSON parser did not receive much attention. And for a good reason. If you are reading this blog, then you probably already appreciate Golang. There are many aspects to like in Go, and one of them is an excellent collection of standard (and third party) libraries. Becase Go ships with a “jack-of-all-trades” JSON parser out of the box (encoding/json library), it made sense for CockroachDB to use a standard parser when converting strings to internal JSON representation. However, at some point, we began to wonder if the time had arrived for us to invest in finding a better, more performant alternative.

Upgrading and modernizing your database can sound like an expensive proposition. But it doesn’t have to be. One major electronics company found that shifting from MySQL to CockroachDB saved them $700,000 in their first year, earning them a 149% ROI.

Charlie Custer

March 2, 2023

When you tap a hotel keycard on your door handle and hear the satisfying buzz and click of a deadbolt electronically unlocking you’ve likely just used a SALTO Systems product. SALTO is a leader in cloud-based access management technology. They manufacture advanced, flexible, and secure wireless electronic access control technology. SALTO’s products are available in over 40 countries and they have over 40M daily active users accessing over 5M equipped devices. They are leading the movement to replace mechanical keys with digital keys. As part of their strategy for leading this movement they are building flexible infrastructure with CockroachDB.

Cassie McAllister

March 1, 2023

Every week, the Big Ideas in App Architecture podcast seeks to extract answers to questions like those from the brightest minds in software development. CTOs, CIOs, VPEs, and Architects from companies like Twilio, Greenhouse, Starburst, and others will share their career path, the current landscape of application architecture challenges today, and strategies they’ve employed to build modern, resilient, data-intensive apps and services.

Dan Kelly

February 27, 2023

Modern data architectures contain a multitude of tools including something for transforming, shaping, and analyzing data to help inform better business decisions. For a mission-critical database like CockroachDB it’s important to be able to integrate with such systems to help customer teams leverage data for business. Combing a tool like CockroachDB with analytics services gives businesses transactional consistency and real-time data for making business decisions. In this tutorial we will look at how to send data using change data capture in CockroachDB to Azure Synapse.

Learn how Paul created an open source JavaScript utility package to help convert cloud provider region codes into real locations and country flags.

Paul Scanlon

February 17, 2023

Transactions make up an important part of the database workload for most modern applications. And when it comes time to scale up operations for a growing business, distributing those workloads across multiple hardware systems for horizontal scalability, high availability, and fault tolerance is often an important part of the plan.

Charlie Custer

February 16, 2023

Disclaimer: this blog is not just for sports fans The vast majority of the Super Bowl’s approximately 100 million annual viewers aren’t actually fans of the teams taking the field. They’re just people who are just looking for an excuse to get together with friends, eat healthy amounts of seriously unhealthy food, and watch commercials. But if congeniality and carbohydrates aren’t enough to hold your interest, a little action can make the “Big Game” a bit more interesting. Historically, most of the wagering on Super Bowl Sunday happens not at the big Vegas sportsbooks like Caesar’s or MGM, but instead in people’s homes, with friendly, informal wagers. The reigning champion of gambling games is a simple-to-learn, no-sports-knowledge-needed game commonly called “Super Bowl Squares.”

Aydrian Howard

February 10, 2023

The popularity of sports betting, also called real-money gaming, is exploding. And at least in the US, there’s no bigger moment for sports betting than this weekend. The NFL’s championship game – you know, the game with the name we’re not allowed to say – is likely to be watched by around 100 million people. And with the growing legality and popularity of sports betting apps in the US, it is very likely this game will see more money flowing through betting apps than ever before.

Charlie Custer

February 9, 2023