The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

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

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

Why We Changed YugaByte DB Licensing to 100% Open Source

We are excited to announce that YugaByte DB is now 100% open source under the Apache 2.0 license. This means previously closed-source, commercial, enterprise features such as Distributed Backups, Data Encryption and Read Replicas are now available in the open source project and are completely free to use. Same applies to upcoming new features like Change Data Capture and 2 Data Center Deployments.

Read More

YugaByte DB Engineering & Community Update – July 10, 2019

YugaByte DB Release Updates

We are pleased to announce that YugaByte DB 1.2.12 is live! You can read the release notes of this and previous versions here. This release is shipping with 11 new enhancements and bug fixes. This also means we are getting closer to our 2.0 release at the end of the Summer in which the YSQL API will become generally available.

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

Relational Data Modeling with Foreign Keys in a Distributed SQL Database

Primary and foreign key constraints are as essential to a relational database as are tables and columns—without these, you cannot implement a design that conforms to the relational model. Their implementation is a technical challenge. For example, when child rows are inserted, their parent rows must be efficiently restricted; and when parent rows are deleted, multi-table transactions are needed. Nevertheless,

Read More

GO-JEK’s Performance Benchmarking of CockroachDB, TiDB & YugaByte DB on Kubernetes

Iqbal Farabi and Tara Baskara, Systems Engineers from GO-JEK Indonesia, recently presented the results of their benchmarking of cloud native databases on Kubernetes at KubeCon Europe in Barcelona. The three databases they benchmarked were CockroachDB, TiDB and YugaByte DB. This post brings their presentation (video recording) and slides (PDF) to the attention of our readers.

Read More