Dan The Engineer

CockroachDB vs Vitess

CockroachDB and Vitess are both popular distributed database systems, but they have different focuses and use cases. Here are some key comparisons between the two: Purpose: CockroachDB is a distributed SQL database designed for general-purpose applications that require strong consistency, high availability, and global scalability. Vitess, on the other hand,

CockroachDB

CockroachDB vs Citus Data

CockroachDB and CitusData are both distributed SQL databases designed to handle large-scale data and offer horizontal scalability. However, there are some key differences between them: Architecture: CockroachDB is a distributed database that uses a distributed consensus algorithm called Raft to ensure data consistency and availability across nodes. CitusData, on the

C'est quoi une transaction ACID

Les transactions d'une base de données relationnelles sont ACID ce qui garantit la cohérence des données. Avec l'arrivée du monde NoSQL, on a souvent introduit le concept de BASE (Basically Available, Soft state, Eventually consistent). Cette logique est associée à la nature distribuée de ces systèmes. Il est plus complexe

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. PythonTo connect to CockroachDB from Python, you can use the psycopg2 library. Here's some

L'importance de la cohérence des données

Dans le monde d'aujourd'hui, les entreprises s'appuient fortement sur les données pour prendre des décisions cruciales, l'approche "data driven" est devenue un avantage nécessaire. L'exactitude et la cohérence de ces données jouent un rôle essentiel pour garantir que ces décisions soient judicieuses et efficaces. Des données cohérentes permettent aux organisations

CockroachDB

Votre première API REST avec GO et CockroachDB

Pour appréhender une nouvelle technologie, quoi de mieux qu'un projet simple et rapide à mettre en place? On a tous en tête un hello world ou une application todo, mais je vais faire un peu plus original! Pour s'approprier Cockroach, je vais vous proposer de suivre un projet de création

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

cdc

Le cache c'est compliqué... ou pas!

There are only two hard things in Computer Science: cache invalidation and naming things. -- Phil Karlton Pour ce qui est du nommage, je n'ai pas encore trouvé de solution miracle, mais pour le cache j'ai de bonnes pistes! Pourquoi l'invalidation de cache est complexeLe cache permet de rapprocher les

Migration

Using AWS DMS to Replicate Data from Aurora RDS to CockroachDB

In this blog I will demonstrate the process of using AWS DMS to aid in a basic migration from Aurora PostgreSQL (RDS) to CockroachDB to simplify your migration needs. Database migration is the process of transferring data from one database to another. There are many reasons why database migration might

Database

How to Choose the Right Database Platform for Your Business: A Guide to Mitigating Risk, Reducing Costs, and Increasing Revenue with CockroachDB

Selecting the right database platform for your business is crucial for ensuring success in today's digital landscape. As a a leader with intimate knowledge of business fundamentals, you understand that your database is a critical component of your company's infrastructure. It supports critical business functions and enables you to make

security

How CockroachDB ensures data privacy and security

Database security is crucial for organisations that rely on databases to store sensitive and confidential data. Databases can contain critical business data, such as customer information, financial records, and intellectual property, which makes them a prime target for cyber attacks. As a distributed database, CockroachDB is designed with security in

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

Databases et SLA

Lorsque l'on parle de SLA, il faut réfléchir à ce que cela signifie pour vous. Il est facile de déployer plusieurs instances d'une application et de mettre en place un load-balancer. Mais que se passe-t-il lorsque celui-ci est en panne ? Au niveau de l'application, nous avons des tonnes de solutions

CockroachDB

Beginners Guide to JSONB in CockroachDB

In this blog we will cover the fundamentals of using JSONB in cockroach and some of the common ways to access and match data. This will cover: Creating tablesPopulating dataSelect data and subsets of dataFiltering dataUpdating dataMatching between tablesPerformance tuningHow to making life easier for ourselves.What is CockroachDB?CockroachDB

Database

Real World Example of a Real time Analytics pipeline using CockroachDB, Kafka and Apache Pinot/Startree.ai

Real-time analytics are becoming increasingly important for line of business transactional use cases such as fraud detection, real-time personalisation, and real-time inventory management. These use cases require the ability to process and analyse large volumes of data in real-time to make quick, informed decisions. To meet this need, many organisations

Multi Region CRDB Dedicated with ccloud CLI

Recently here at Cockroach Labs, we released a CLI (Command Line Interface) tool called "ccloud", this tool allows users to create, manage and connect to CockroachDB clusters that are hosted within our cloud offering, wether that be dedicated or serverless, and it's really simple to use! In this blog I

Demo of CockroachDB horizontal scaling capabilities

One of CockroachDB's capabilities, which makes it great fit for large scale projects, is its horizontal scaleability. In contrast to legacy architectures, which are typical active/passive in nature, CockroachDB provides a multi-active architecture in wich all the nodes of a cluster are able to read/write to the dataset.

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

CockroachDB

Hybrid Deployment Example Using AWS & A Raspberry Pi

A hybrid deployment model combines the use of both on-premises and cloud infrastructure to create a flexible and scalable computing environment. In this blog I'll demonstrate a basic Hybrid deployment using AWS Cloud and A Raspberry Pi I have in my house. But first of all, lets outline a few

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

Database

Comparing B-Tree and LSM Index Structures: Pros, Cons, and Use Cases

Indexes are crucial in the realm of databases for effective data processing and retrieval. An index is a type of data structure that arranges data to make it easier to search, sort, and retrieve information quickly based on certain criteria, like a single value or a range of values. Two

CockroachDB

Magic Quadrant: CockroachDB

We all understand just how crucial it is to find the perfect technology for your organisation. With a lot of options available out there, it can be overwhelming trying to figure out which one will meet your business needs the best. Luckily, there is a tool that can help you

performance

EXPLAIN ANALYZE : What You Need To Know

CockroachDB is an open-source, distributed SQL database that offers consistent, scalable, and highly available data storage. As with any relational database system, one of the most important tasks for a database administrator or developer is optimizing queries for performance. One tool that can be incredibly helpful for this task is

CockroachDB

Top 5 Show Commands in CockroachDB

CockroachDB is a distributed SQL database that provides scalability, fault tolerance, and consistency. It is an open-source database that is highly resilient and provides excellent performance, making it an excellent choice for modern applications. One of the essential features of CockroachDB is its powerful SHOW commands that enable users to