Product

We are thrilled to announce that CockroachDB dedicated, the fully managed single-tenant version of CockroachDB, is now HIPAA-ready and can be used to safely store protected health information (PHI). Any organization working in healthcare needs to comply with HIPAA requirements to protect sensitive patient data, regardless of whether they’re a “covered entity” (hospital, health insurance plan, pharmacy, etc.) or “business associate” (an organization that works with a covered entity).

CockroachDB has lots of customers who’ve switched from Oracle and other legacy SQL databases, saving both money and time. Generally speaking, though, we can’t share their names or specific details about their internal processes and workloads. So in this article we’ll be doing something a bit different. We wanted to tell the story of what it’s like for a finance company to transition from Oracle to CockroachDB. The names and quotes in this narrative are fictional, but the story itself is real. It comes from the things we’ve heard working with real-world customers in the finance industry – including Fortune 50 banks – who are moving transactional workloads off of Oracle and onto CockroachDB.

Charlie Custer

June 15, 2023

It’s 10 o’clock. Do you know where your data is? Chances are, it’s nestled snugly in its database. But chances are that it’s also less secure than you might think. Even in sophisticated systems with backups and failover plans, data loss is possible. And importantly, it can happen without you realizing it’s even possible – at least, not until it’s too late.

Charlie Custer

June 13, 2023

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