Dan The Engineer

Blog - CockroachDB, Azure Data Lake Gen2 and Synapse

CockroachDB is an Distributed SQL OLTP database which is perfect for supporting critical line of business applications that have scale and resiliency requirements. However, an organization’s data architecture will often contain many tools, including something for transforming, shaping & analyzing data to help inform better business decisions. This means

Data

Qu'est-ce qu'une Forme Normale et devez-vous les respecter ?

[English version available here] En comparant les SGBD et les bases NoSQL, la partie "schéma" est souvent utilisée. Dans le monde NoSQL, vous voyez les "schema-less" ou "no schema" comme un avantage. Si cela peut être vrai parfois, vos applications s'appuieront sur un schéma de quelque manière que ce soit.

Data

What is Normal Form and do you need to respect them?

[Version en Français disponible ici] Comparing RDBMS and NoSQL, the schema part is often used. In NoSQL, you see "schema-less databases" or "no schema" as an advantage. If it could be true sometimes, your applications will rely on a schema in any way. You always end up presenting data to

Fintech

Scaling Your Fintech Business for Growth: How CockroachDB Can Help Increase Your Customer Base

One of the main key objectives for businesses operating in the fintech sector is to expand their customer base. It has been a turbulent time for Financial Services companies over the past few years, market conditions caused by Brexit, COVID and the Russian war in Ukraine have caused significant economic

Database

MVCC Databases

Multiple transactions can access and edit the same data concurrently with MVCC (Multi-Version Concurrency Control), a database management technique that preserves the data's integrity. As data is changed over time, MVCC operates by producing and storing numerous versions of that data. This can increase concurrency and performance since it enables

Database

Running a Database on Kubernetes

Since databases have certain demands and requirements that can be tough to achieve in a containerized environment, running a database platform on Kubernetes can be a challenging undertaking. In this post, we'll look at some of the issues that can occur when using Kubernetes to run a database and how

CockroachDB CDC Example

With the aid of CockroachDB's Change Data Capture (CDC) capability, you can keep track of database changes and instantly replicate them to other systems. In order to synchronise data between CockroachDB instances or between CockroachDB and other systems, it is intended to do so in a high-performance and low-latency manner.

Database

CockroachDB vs MongoDB

Both CockroachDB and MongoDB are distributed database management systems, but they each have a particular set of features and functionalities. In this post, we'll examine both databases in more detail and weigh their advantages and disadvantages. A Little on CockroachDBCockroachDB was created with high fault tolerance and scalability in mind

Software Engineering

Application Design Patterns

Application design patterns are a set of rules that specify the organisation and structure of an application. These patterns help to ensure that systems are scalable, maintainable, and simple to comprehend by giving developers a standard language to use when discussing design choices. Applications can be created using a variety

CockroachDB

CockroachDB 22.2 [Français]

[English version available here] Récemment, CockroachLabs a lancé CockroachDB 22.2 avec un grand nombre de nouvelles fonctionnalités. Pour n'en citer que quelques-unes, vous trouverez des User Defined Functions, Time-To-Live au niveau des lignes, et le CDC (Change Data Capture) avec transformations et filtrage. Chacune de ces fonctionnalités est une

Database

Database Indexes: Trigram

An introduction to Trigram Indexes

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

CockroachDB Locality-aware Backups for Azure Blob

Any enterprise-grade database needs to have a mature story when it comes to Backup and Recovery. Historically, due to limitations in their architecture, many relational database technologies relied heavily on backups in the event of a disaster. Using these backups to recover data to a secondary location used for Disaster

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

How To Choose a Database?

[Version française ici] So you have a big idea that’ll change the world. As any company, startup or not, you need to store data. Fortunately, you have plenty of choices for your database… Fortunately? Not so sure! With all the choices, how do you decide which type of database

Comment choisir sa base de données?

[English version here] Vous avez donc une grande idée qui va changer le monde. Comme toute entreprise, startup ou non, vous avez besoin de stocker des données. Heureusement, vous avez l'embarras du choix pour votre base de données... Heureusement ? Pas si sûr ! Avec tous ces choix, comment décider du type

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

Database

Why stored procedures are a bad idea (and what to do instead)

Most people don’t know what stored procedures are, and even fewer people know why they should avoid them like the plague. I’m going to tell you exactly why you should avoid database stored procedures and what to use instead of them. What are database stored procedures? Stored procedures

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