Product

CDC Queries are SQL-like statements that allow you to (1) filter (2) transform (3) and choose the schema of your data stream. Instead of the headaches of sidecar services or downstream tools, filtering and transforming streaming data is now as simple as a SQL query. Here is a quick video tutorial about how to use CDC Queries that accounts for all the new functionality as of the CockroachDB 23.1 release:

We’re giving CockroachDB’s interactive SQL shell a face lift in v23.1! The SQL shell is the interactive read-eval-print loop (REPL) bundled inside CockroachDB under the command cockroach sql. It is also available as the standalone and more modestly sized cockroach-sql downloadable program, as well as our development tool cockroach demo.

In CockroachDB v23.1, we are introducing a new feature which enables external SQL query editors to provide contextual suggestions on SQL syntax to developers. As a proof of concept, we have integrated this feature in CockroachDB’s own interactive SQL shell to provide a long and often requested UX enhancement: tab completion!

Large enterprises with hundreds of developers building thousands of applications and services have a suite of database options to choose from. They also typically have a full team dedicated to maintaining these offerings. The saying “use the best tool for the job” is why they offer so many options, since different workloads have different requirements. Over the past few years, the “best tools” have changed because of the increasing demand on infrastructure generated by business-critical, high-volume, workloads.

Cassie McAllister

May 18, 2023

In this post Rob and I explain how we built Silo, a fully functioning multi-region Next.js application combining CockroachDB multi-region serverless and a multi-region Node.js (Lambda) API backed by a Geographically aware Route 53 Hosted Zone. Both the API and CockroachDB have been deployed to AWS. The Next.js app has been deployed using Vercel. There are a number of reasons why you’d want to choose a multi-region strategy; to optimize latency, maintain high availability and, in some cases, to comply with regional regulations. But, rather than tell you about the benefits, I’d like to show you.

Rob Reid

May 17, 2023

Today we released a series of exciting updates to give you even more flexibility to run CockroachDB how you want, where you want, more efficiently than ever before. Customers often tell us they want the benefits of the cloud (elastic scale, consumption-based costs, operational ease of managed services, etc.), without the drawbacks of being locked-in to a single provider’s platform or proprietary services. We built CockroachDB from the beginning to maximize flexibility and control while still delivering the automation and efficiency we have all come to expect from cloud-native tools. The new capabilities we’ve made available today strengthen those values.

Meagan Goldman

May 16, 2023

When building a multi-region application, one of the first things to consider is how and where data will be placed. For example, when building a gambling application deployed across the country, you want to make sure users have quick access to their data no matter their location. Gamblers and the platforms they use both need low latency access to real-time data. It can make or break the user experience. This is an easy example because money is won and lost, but the requirement for applications to deliver low latency experiences to a global user base is obviously applicable to every other industry as well.

Upserts are useful for anyone who works with a database to know, but the term “upsert” might not even appear in your DBMS’s documentation! So what is an upsert, anyway? And why might it not be mentioned in your docs?

Charlie Custer

May 8, 2023

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.