Paul Lovett - Dan The Engineer

CockroachDB! Why you need it and when you need it

First and foremost, CockroachDB is a distributed SQL database designed to be highly available, scalable, and resilient, making it a suitable choice for various use cases. Here are some scenarios where you might want to consider opting for CockroachDB: 1. High Availability: CockroachDB is built to ensure high availability and

Row Level Security with CockroachDB

Row Level Security (RLS) without RLS. Intrigued? Yes? Then keep reading

From a Security or Multi-Tenant perspective, having the ability to limit access on a row-by-row basis is a must, What happens though if your database of choice does not provide this feature out of the box? At Cockroach Labs we partner with a security provider called Satori to enable this

CockroachDB

Multi-language guide to connecting to CockroachDB

We often get asked how do we interact with CockroachDB from various different programming languages. This blog aims to show you how to do this from languages such as Java, Python and Microsoft code bases 1. Python To connect to CockroachDB from Python, you can use the psycopg2 library. Here's

Need to Geo-Partition your data? Lets see how CockroachDB can help

In todays regulated world businesses need to guarantee where their data resides and know where that data is at all times. Failure to comply can results in mega fines and be a disaster for your business when trust in it erodes and customers turn their backs. In this blog we

app

Applications and CockroachDB go together like peaches and cream

As we know, data rich apps drive the economy. If your business doesn't have an app you are effectively working with your arms tied behind your back. These data rich apps have their own specific list of requirements. they need to be able to provide consistent, reliable data with super

multi-region

CockroachDB: Multi-Region refresher

This post will take us through a high-level refresher of what it takes to be a Multi-Region, distributed SQL database and how we achieve this at Cockroach Labs. But first, here is a little bit of information that will allow you to get up and running with CockroachDB and its

Analytics

CockroachDB and Analytic Workloads - Part 2

In an earlier post we discussed how CockroachDB can indeed be used for Analytics workloads. If you are interested in reading that article its available here In this second post we will give a short refresher on why CockroachDB can be a good fit for analytics and then provide an

fast reads

Want to speed up your reads?

Be a Leader and a Follower :-) In CockroachDB, a follower is a replica of a database that synchronises with the leader to ensure data consistency and availability. The leader is the node that accepts write requests and coordinates updates to the database. The followers replicate the leader's data and

gaming

CockroachDB meets the Gaming Industry

CockroachDB is proving to be a highly successful database in the world of online gaming. Many games companies support and actively promote the use of CockroachDB to develop your games and store your players "in-play" data and subscription details. Online gaming relies heavily on real-time data processing and storage, which

DB Console

Monitor your CockroachDB Cluster from your Smartphone

CockroachDB's web console (DB console) is designed to be intuitive and user-friendly, and provides a rich set of features for managing and monitoring CockroachDB clusters. It is particularly useful for users who are not familiar with command-line interfaces or who prefer a graphical interface for their database administration tasks. Accessing

CockroachDB

CockroachDB and Analytic Workloads

Although CockroachDB lands firmly in the OLTP space its perfectly acceptable to run more analytic type workloads against your cluster CockroachDB is primarily designed as an OLTP (Online Transaction Processing) database, which means it is optimised for handling high transaction volumes and low-latency queries. Its distributed architecture and support for

symfony framework

CockroachDB and the Symfony Framework

CockroachDB is a distributed SQL database that is designed to be scalable, resilient, and highly available. It is compatible with PostgreSQL, which means that applications built to use PostgreSQL can use CockroachDB as a drop-in replacement with minimal modifications. Symfony, on the other hand, is a popular PHP web application

logistics

CockroachDB is a great fit if your business is Logistics

When it comes to logistics we see regularly that there is a clear set of priorities that need to managed in order for your business to be successful. These include, keeping transportation costs down as well as keeping up with customer/industry demands. Sourcing consistent, reliable carrier capacity while keeping

banking

Reliable banking with CockroachDB

There is probably not a day goes by without us accessing our banking apps on our smartphones. Like me, you have probably experienced that time when the app is unavailable to log you in or you have read on social media that a leading high street bank’s payment system

RAFT

CockroachDB and the RAFT Protocol

CockroachDB is a Survivable, Thriveable and Scalable distributed SQL database. A winning formula for modern, mission critical applications at scale. To maintain its goal of being all three it uses the RAFT protocol to align and agree on one single state So, what is RAFT? The RAFT protocol is a

latency

Serialisable Isolation doesn't have to mean slower!

We recently came across a scenario where the assumption was that a current production workload needed to rely on Read Committed isolation to support lower latency requests to and from the database. This assumption albeit it correct made us think. If you can utilise only Serialisable Isolation due to consistency

data locality

Utilise the included demo feature of CockroachDB to discover how to geographically position your data

Example setup, configuration and test 1. Stand up a demo multi-region cluster locally using CockroachDB Demo $ cockroach demo --no-example-database --nodes 9 --global 2. Create a Database CREATE DATABASE db PRIMARY REGION "us-east1" REGIONS "us-west1", "europe-west1"; USE db; 3. Create a table with Region by Row functionality CREATE TABLE public.users

Cockroach Demo

Getting to know the CockroachDB 'demo' feature

Getting started with CockroachDB demo Prerequisite Download the CockroachDB binary from this location (MacOS, Linux or Windows available) What is the CockroachDB demo? The cockroach demo command starts a temporary, in-memory CockroachDB cluster of one or more nodes, with or without a preloaded dataset, and opens an interactive SQL shell

CockroachDB

CockroachDB : The multi-region database

CockroachDB is a distributed database that you can span across multiple geographic regions. To provide this multi-region capability, CockroachDB uses a combination of techniques such as data replication, distributed consensus, and node replication. 1. Data Replication: CockroachDB automatically replicates data across multiple regions to ensure that data is available even