CockroachDB

A collection of 76 posts

Data

Unlocking the power of data in your business: How to make the right decisions

Why using a data-driven approach to making business decisions is critical to the success of a business

CockroachDB

CockroachDB 22.2 [English]

[Version française disponible ici] Recently, CockroachLabs launched CockroachDB 22.2 with a lot of new features. To name a few, you'll find User Defined Functions, Time-To-Live at row level, and CDC (Change Data Capture) with transformations and filtering. Any of these features is great improvement, but can we get more

Database

Understanding Database Indexes

Although it can be challenging to choose which type to use, database indexes are necessary for enhancing query efficiency. We'll discuss the various database index types, their benefits and drawbacks, and when to utilise each one in this blog post. Read on to discover more about database indexing and how

Cloud

Multi-Cloud Database Deep Dive

A Deep Dive into the benefits and considerations of Multi-Cloud Database

CockroachDB

User Defined Functions

Understanding User-Defined Functions

azure

Blog - CockroachDB 22.2 SSO with Azure Managed Identities

Overview: In this blog post we will be demonstrating how to authenticate and connect to CockroachDB using JWT tokens issued to Azure's Managed Identities. In this example, we will retrieve the JWT tokens from Azure for a test SQL user in CockroachDB and use those for user authentication. At a

CockroachDB

CockroachDB and Google Data Studio

Connecting CockroachDB and Data Studio

CockroachDB

Speedy recovery without Backups

Backups are often thought about in the context of a disaster, the loss of a data centre, SAN or other infrastructure. Fortunately for operators and admins everywhere these are relatively rare occurrences. Backups are also exist to give comfort in the form of regulatory and audit compliance. However, the most

CockroachDB

Auto-Scaling Your Distributed Database: A Bad Idea?

In the past few years, software engineers have become increasingly aware of the importance of scaling data-intensive applications to meet the needs of its users. As with most things, though, there are both good and bad ways to go about it. One particularly bad approach that deserves a closer look

CockroachDB

Why running your own database can be more costly than you think

Running your own database or the other extreme of using Database as a Service? That sounds like an easy choice, right? There are many factors you need to consider before making that choice. Read our article to find out why we believe running your own database can be more costly

Data

Why Is Database Isolation Level So Important? You Might Be surprised.

You’ve probably heard the term database isolation level before, but how important is it? In other words, should you let your database admin worry about it, or should you care enough to be familiar with it? And if you should care, what are these different isolation levels anyway? The

CockroachDB

CockroachDB: Dedicated Security - Authentication

CockroachDB Dedicated has 2 Levels of Authentication * CockroachDB Cloud Console * SQL Users In this Blog, we will discuss how both of these should be used to secure your Cockroach Cloud Organization account. Website Link for further Details - https://www.cockroachlabs.com/docs/cockroachcloud/console-access-management.html CockroachDB Cloud Console Within

Database

The Advantages of OLAP and OLTP Database Separation

When it comes to designing your data strategy, you have several options for where you can store your data and how it will be processed. Two that you’ll likely hear about are the OLAP (online analytical processing) and OLTP (online transactional processing) databases, and whether or not they should

Distributed SQL

5 Reasons Why Distributed SQL databases are optimised for the Cloud

In this article, we’re going to explore why SQL databases are fast becoming the database of choice for enterprises looking to store their data in the Cloud. The reasons are many and varied, but there are five key reasons why distributed SQL databases are optimised for the Cloud and

CockroachDB

Bank of England Worried About Concentration of Risk in the Cloud

In the Bank of England’s semi-annual Financial Stability Report, the central bank expressed its concern about risks associated with cloud computing data centres, and how that could affect financial stability in the UK. The report identified three reasons for this issue: concentration of data centres; concentration of financial services

CockroachDB

Why Distributed Databases Are Becoming More Popular

We have been hearing about distributed databases for some time now, but what exactly does it mean? Also, why are these databases becoming so popular? Let’s take a look at these questions, as well as some of the real-world applications of distributed databases, to better understand what this technology

CockroachDB

Build a Multi Region Python App with CockroachDB, Django and K8s

A request came across my desk the other day asking whether I had any experience with Django and would I like to see if I could get this working with our multi region capabilities. I had never heard of Django before but never to be one to turn down a

CockroachDB

Database Isolation Levels and Data Anomalies

Database isolation and data anomalies are important to understand. This Blog Post explains details regarding both and how they are linked

CockroachDB

Streaming Data from CockroachDB to Redpanda

Streaming Data from CockroachDB to Redpanda

CockroachDB

Active Passive vs Multi-Active Database Topologies

A Comparison of Active Passive vs Multi-Active Database Deployments

CockroachDB

CockroachDB vs AWS Aurora

This article is all about comparing the feature sets of CockroachDB and Amazon Aurora. These are two of the most popular SQL and databases of the cloud era

CockroachDB

CockroachDB vs SQL Server

A quick comparison of cockroachdb and SQL Server.

CockroachDB Featured

Top 5 Useful Commands with CockroachDB

The Top 5 Commands used to help you become more proficient in administering and using CockroachDB

CockroachDB

Schema Design Considerations with CockroachDB. What is a Hotspot Not?

Want to know what considerations to make when selecting primary keys in cockroachDB? Want to know how CockroachDB diversifies and replicates it data?

CockroachDB Featured

CockroachDB - Fun with Encryption

In this post, Dan shows you how to create multiple store directories for CockroachDB nodes and encrypt them using different encryption keys. Different tables can then be stored and encrypted using different keys.