View all

When building a table in a SQL database, one of the most important decisions is what to use for a primary key. This can have a big impact on the efficiency of your queries. It also becomes critically important when you start creating relationships between tables.

Full text indexing and search is such a common feature of applications these days. Users expect to be able to find a restaurant, a product, a movie review, or any number of other things quickly by entering a few search terms into a user interface. Many of these apps are built using a relational database as the data store, so the apps aren’t generally dedicated to search, but incorporate that as an added feature.

Michael Goddard

July 27, 2022

In order to learn how to use CockroachDB with a JPA provider like Hibernate, let’s build a Spring Boot application that stores details of video game leaderboards in a CockroachDB database hosted on the CockroachDB Serverless platform.

Back in April 2021, Cockroach Labs completed our first SOC 2 Type II audit. Now, thanks to collaboration between multiple teams led by the Compliance team, we have completed our second. As CockroachDB continues to evolve and add new products and features, we need to ensure that those new products and features meet various sets of security and compliance standards. This latest SOC 2 Type II audit covers a full 12 month review period for both of CockroachDB’s managed services offerings, CockroachDB Dedicated and CockroachDB Serverless. But before we get more in-depth on this new addition, let’s quickly recap what a SOC 2 Type II audit covers and why it’s important.

Star Wars and SQL began together. In 1977, the first (eventually fourth) Star Wars film debuted in theaters. In that same year an emerging English language-based structured query language for data, originally called SEQUEL, was renamed to SQL*. For the Rebellion, it was A New Hope to fight the Empire. For the rest of us, it was the birth of a nifty little world-changing technology known as the relational database.

Michelle Gienow

July 22, 2022

The 2022 Cloud Report represents our deepest dive yet into how the three public clouds – AWS, GCP, and Azure – perform for OLTP applications. And while we’ve highlighted some of the most interesting findings in the report’s Insights section, the full report runs nearly 80 pages. There are many interesting details that didn’t make it into that top-level summary.

Charlie Custer

July 21, 2022

With so many things out there for an application developer to learn, we are often asked: why should I spend time learning SQL? It’s a valid question! With ORMs available to translate most popular programming languages into SQL, it’s quite possible to develop an application that uses a SQL database without actually needing to know much SQL. But there are lots of reasons why devs should still learn SQL. In fact, SQL is an important tool that can help with everything from performance optimization to debugging. Let’s take a look at just a few of the reasons why developers should learn SQL:

Charlie Custer

July 20, 2022

In a cluster spanning multiple geographical regions, Global Tables let database clients in any region read data with region-local latencies. Imagine a table with data that is read from all over the world: say, for example, a table of exchange rates in a global bank’s database. Queries ran on behalf of users anywhere might access these rates. This is in contrast to other types of data (say, a user’s account data) which have an affinity to the user’s own region. Global Tables make accessing these exchange rates fast.

There are two different ways to use CockroachDB as a managed service and enjoy DBaaS benefits: CockroachDB Dedicated is a fully managed single-tenant service used by companies to store their data while adhering to their enterprise compliance requirements. CockroachDB Serverless offers automatically scalable service for building new and nimble applications while paying for only what you use.