The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

PostgreSQL How-to: SportsDB Running on a Distributed SQL Database

SportsDB is a sample dataset compiled from multiple sources, encompassing a variety of sports including football, baseball, ice hockey and more. It also cross-references many different types of content media. It is capable of supporting queries for the most intense of sports data applications, yet is simple enough for use by those with minimal database experience. The database itself is comprised of over 100 tables and just as many sequences,

Read More

How-to: The PGExercises PostgreSQL Tutorial Running on a Distributed SQL Database

PgExercises is a sample dataset used to power the PostgreSQL Exercises website. The site is comprised of over 80 exercises designed to be used as a companion to the official PostgreSQL documentation. The exercises on the PGExercises site range from simple SELECT statements and WHERE clauses, through JOINs and CASE statements, then on to aggregations, window functions,

Read More

YugabyteDB Engineering & Community Update – July 19, 2019

We are pleased to announce that YugabyteDB 1.3.0 is live! You can read the release notes of this and previous versions here. This release is shipping with 24 new features, enhancements and bug fixes. Beyond enhancements and fixes, the other big news is that we have open sourced the entire core database code! This means that previously closed features like distributed backups,

Read More

How-to: The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database

The Northwind database is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The Northwind database contains the sales data for a fictitious company called “Northwind Traders,” which imports and exports specialty foods from around the world. The Northwind database is an excellent tutorial schema for a small-business ERP,

Read More

Announcing Distributed SQL Summit Presented by YugaByte and PostgresConf

YugaByte is excited to announce in partnership with PostgresConf, that the inaugural Distributed SQL Summit is taking place on September 20, 2019 in San Jose, California! The Distributed SQL Summit is the first ever event to focus exclusively on sharing best practices and technical knowledge on the cloud-native approach to deploying, operating and scaling distributed SQL databases.

Read More

YugabyteDB Engineering Update – June 27, 2019

We are pleased to announce that YugabyteDB 1.2.11 is live! You can read the release notes of this and previous versions here. This release is shipping with stored procedures support, plus 30 new features, enhancements and bug fixes. Here’s a few highlights from the 1.2.11 release.

What’s YSQL? It’s YugabyteDB’s PostgreSQL-compatible, distributed SQL API.

Read More