Dan The Engineer

Dan The Engineer

Sign in Subscribe

Problèmes d'isolation?

Problèmes d'isolation?

Il y a peu, j'ai écrit sur les différents niveaux d'isolation disponibles sur les bases de données et le fait que finalement on reste souvent sur le niveau par défaut malgré les risques occasionnés (https://dantheengineer.com/cest-quoi-une-transaction-acid/). Comme on peut s'en douter, une isolation entre les transactions imparfaite peut

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

Managing CockroachDB as Code with Terraform

Managing CockroachDB as Code with Terraform

Managing everything as code ensures no configuration drift ensuring predictable results. This is critical when managing applications at scale. Cockroach Dedicated is a Database as a Service (DBaaS) offering that allows companies the ability to outsource the day to day delivery and operations of a relational database that is reliable

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 avec DotNet et Dapper

[English version available here] Dans l'écosystème dotnet, il est courant d'utiliser Entity Framework. Mais vous pouvez également utiliser Dapper pour gérer l'accès à votre base de données. Dapper est un mappeur d'objets simple et facile à utiliser. Pour ce blog, je vais montrer comment utiliser Dapper pour communiquer avec CockroachDB.

Using CockroachDB with DotNet core and Dapper

[Version en français disponible ici] In the dotnet ecosystem, this is common to use Entity Framework. But you can also use Dapper to manage your database access. Dapper is a simple object mapper and is easy to use. For this blog, I'll show how to use Dapper to communicate with

CockroachDB vs Vitess

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: 1. 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

CockroachDB vs Citus Data

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

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

Multi-language guide to connecting to 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

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

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

Votre première API REST avec GO et 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

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

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

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 complexe Le cache permet de rapprocher

Using AWS DMS to Replicate Data from Aurora RDS to CockroachDB

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

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

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

Applications and CockroachDB go together like peaches and cream

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

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

Beginners Guide to JSONB in 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 tables * Populating data * Select data and subsets of data * Filtering data * Updating data * Matching between tables * Performance tuning * How to making life

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

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

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.

CockroachDB: Multi-Region refresher

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