The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

How Abra Controls Transforms Energy Companies with Yugabyte Cloud

Abra Controls provides wireless pressure monitoring and data aggregation solutions. It serves energy companies in the U.S. and Canada. Its customers optimize hydraulic fracturing operations and ensure regulatory compliance.

The company’s marquee offering is its mobile sensors and in-the-field service. Part of its service is a cloud IoT application. As a result, it collects and aggregates massive amounts of sensor data from hydraulic fracturing sites.

Read More

Announcing YugabyteDB 2.11: The World’s Most PostgreSQL-Compatible Distributed SQL Database

This morning we announced the general availability of YugabyteDB 2.11, a major release which extends PostgreSQL compatibility of the open source distributed SQL database! These updates allow application developers to use powerful and familiar PostgreSQL features without compromising resilience, scale, or performance. You can find out how to evaluate PostgreSQL compatibility in YugabyteDB and other popular distributed databases by registering for our upcoming livestream.

Read More

Is Your Distributed Database PostgreSQL Compatible, and Why Does This Matter?

Most companies now realize that compatibility with a widely adopted SQL API is essential to ensure the success of their modern distributed SQL databases.

But, there are many SQL database options available and each one takes a different approach to PostgreSQL compatibility. This can have major implications for the developers and applications leveraging these databases.

In this on-demand webinar,

Read More

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1.

Read More

Using the PostgreSQL Recursive CTE – Part Two

Computing Bacon Numbers for actors listed in the IMDb

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code.

Read More

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read More

YugabyteDB Fundamentals Training Q&A – Jan 28, 2021

Yesterday we had almost 200 folks show up for the latest “YugabyteDB Fundamentals and Certification” training session. We had a lot of questions during the session and weren’t able to get to them all! In this blog I have compiled the majority of them and provided answers in a simple Q&A format.

Missed yesterday’s training? You can catch our next training session,

Read More

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

Read More