Dan The Engineer (Page 2)

Dan The Engineer

Sign in Subscribe

CockroachDB and Analytic Workloads - Part 2

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

Want to speed up your 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

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

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

Magic Quadrant: 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

EXPLAIN ANALYZE : What You Need To Know

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

Top 5 Show Commands in 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

Ensure 24/7 Availability of Your Retail or E-Commerce Application with CockroachDB: A Resilient, Scalable, and Consistent Database Solution

Ensure 24/7 Availability of Your Retail or E-Commerce Application with CockroachDB: A Resilient, Scalable, and Consistent Database Solution

Retail and e-commerce companies operate in a highly competitive environment where customer satisfaction is the key to success. Customers expect an always-on 24/7 application and website. Any downtime can lead to customer dissatisfaction, loss of revenue, and damage to the brand reputation. To ensure continuous availability of their application

CockroachDB meets the Gaming Industry

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

Migration de base... Why so serious?

Migration de base... Why so serious?

[English version here] Récemment, j'ai discuté de la manière dont vous pouvez migrer vers Cockroach DB. J'ai parlé des adaptations de schéma, des changements d'application, etc. Ces articles n'étaient pas vraiment amusants à lire. J'ai donc décidé de rendre la migration de base de données amusante. La réponse est évidente

Why so serious about database migration?

Why so serious about database migration?

[Version française ici] Recently, I discussed how you can move to Cockroach DB. I discussed schema adaptations, application changes, etc. Those posts weren't really funny to read. So I decided, how can we make database migration fun? The answer is obvious in 2023... Use ChatGPT! Starting with CoPilot I used

Monitor your CockroachDB Cluster from your Smartphone

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 and Analytic Workloads

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

Comparing RAFT, PAXOS, and Calvin Consensus Algorithms: Why CockroachDB Chose RAFT

Comparing RAFT, PAXOS, and Calvin Consensus Algorithms: Why CockroachDB Chose RAFT

Consensus algorithms are essential for distributed databases, enabling nodes in the cluster to agree on a single version of the data. RAFT, PAXOS, and Calvin are three popular consensus algorithms used in distributed systems. In this blog post, we will compare these algorithms and discuss why CockroachDB chose RAFT as

CockroachDB and the Symfony Framework

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

Migrez vers CockroachDB - Partie 2

Migrez vers CockroachDB - Partie 2

[English version available here] Dans la première partie, nous avons vu comment transformer et adapter vos schémas ou vos documents JSON pour les utiliser dans CockroachDB. Selon que vous veniez d'une base de données NoSQL comme Cassandra, MongoDB, Couchbase, etc., ou d'une base de données relationnelle comme Oracle, Postgres, MySQL,

Migrating to Cockroach - Part 2

Migrating to Cockroach - Part 2

[Version en Français ici] In the first part, we discussed how to transform and adapt your schema or JSON documents to be used in CockroachDB. Depending if you're coming from a NoSQL database like Cassandra, MongoDB, Couchbase, etc., or from a relational DB like Oracle, Postgres, MySQL, etc. you have

CockroachDB is a great fit if your business is 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

Cloud Agnosticism and Regulatory Compliance in Financial Services and Fintech

Cloud Agnosticism and Regulatory Compliance in Financial Services and Fintech

Cloud computing has become increasingly popular in the financial services and fintech industries as a means of improving operational efficiency, scalability, and innovation. However, the adoption of cloud computing in these industries is subject to regulatory requirements around data privacy, security, and operational resilience. In this blog post, we will

The Importance of Encryption for Database Platforms: Protecting Your Data

The Importance of Encryption for Database Platforms: Protecting Your Data

Hello everyone, having worked in the database industry for over 30 years, I know firsthand the importance of protecting your data. One of the most effective ways to do this is through encryption, which transforms sensitive information into a code that only authorised parties can decode. In this blog post,

Reliable banking with CockroachDB

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

Migrez vers CockroachDB - Partie 1

Migrez vers CockroachDB - Partie 1

[English version available here] La migration d'une base de données vers une autre n'est jamais une tâche facile. Quelle que soit votre solution, le passage à un autre outil nécessite une préparation et une adaptation. C'est souvent une tâche que vous allez gérer comme un projet. Pour aborder ce sujet,

Migrating to Cockroach - Part 1

Migrating to Cockroach - Part 1

[Version en Français ici] Migrating from one database to another is never an easy task. Whatever your solution, switching to another tool requires preparation and adaptation. It is often a task that you will manage like a project. To address this topic, I have decided to break the problem down

The Cost of Downtime: How Database Outages Impact Revenue, SLAs, and Brand Reputation (And Why CockroachDB is Critical for Resilience)

If you have ever been involved in resolving an outage, you know that downtime can be costly. But do you know just how costly a database outage can be? Let's take a look at the numbers: Revenue Loss Database outages can have a significant impact on top line revenue. In