Daniel Holt - Dan The Engineer

Dan The Engineer

Sign in Subscribe

Daniel Holt

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

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

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

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

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

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,

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

Making Friends in the Cloud: A Humorous Guide to Integrating CockroachDB with Other Services

Making Friends in the Cloud: A Humorous Guide to Integrating CockroachDB with Other Services

If you're running a distributed SQL database like CockroachDB in the cloud, you know that integration with other cloud services is crucial for success. But how do you make sure your database is playing nice with all the other kids on the block? Here are some tips for integrating CockroachDB

Optimising Performance and Availability with CockroachDB Monitoring Tools

Optimising Performance and Availability with CockroachDB Monitoring Tools

In my experience as a seasoned Database Administrator and Engineer, monitoring tools play a crucial role in the efficient maintenance of databases. With the aid of these technologies, administrators can enhance the performance of their systems, spot problems early, fix them, and ultimately give users better services. A database that

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

Synthetic vs Non-Synthetic Benchmarking: Understanding the Difference

As technology advances, businesses are finding themselves dealing with massive amounts of data. Databases play a significant role in storing and managing this data, and businesses need to ensure their databases perform optimally. Benchmarking is one way to assess the performance of a database, and there are two types of

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

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

Running a Database on Kubernetes

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

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.

CockroachDB vs MongoDB

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 CockroachDB CockroachDB was created with high fault tolerance and scalability in

Database Indexes: Trigram

Database Indexes: Trigram

An introduction to Trigram Indexes