PostgreSQL

Getting Started with DBeaver on a Distributed SQL Database

July 26, 2019

Databases Distributed SQL How To PostgreSQL

Getting Started with DBeaver on a Distributed SQL Database

Editor’s note: Updated July 7, 2020 with the new DBeaver wizard

If you’re a database developer, you know that you need different SQL statements for creating schemas, ad-hoc querying, initiating backups, or troubleshooting. For these scenarios, finding the right graphical tool can speed up these tasks and make you more productive. Over the years, the PostgreSQL community has developed several open source graphical tools for managing PostgreSQL databases, visualizing the datasets it contains,

…

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

July 25, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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

In this post we are going to walk you through how to download and install the PostgreSQL-compatible version of SportsDB onto the YugabyteDB distributed SQL database with a replication factor of 3.

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

July 21, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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

This post provides a guide on how to download and install the PGExercises sample dataset on the YugabyteDB distributed SQL database with a replication factor of 3. PGExercises includes over 80 exercises that cover a range of SQL queries and is designed to be used alongside the official PostgreSQL documentation.

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

July 17, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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

Walk you through how to download and install the PostgreSQL-compatible version of Northwind on the YugabyteDB distributed SQL database.

Relational Data Modeling with Foreign Keys in a Distributed SQL Database

July 2, 2019

By Bryn Llewellyn

Distributed SQL How To PostgreSQL

Relational Data Modeling with Foreign Keys in a Distributed SQL Database

Note added on October 31, 2019

A lot has happened since this post was published in July 2019. Back then, the current YugabyteDB version was 1.2.10. And now, it’s 2.0.3. My original text included some caveats and comments like “Until this support is added in a future release…”. Now, no caveats are needed. I therefore revised my text and the companion downloadable code to remove all reference to those earlier, interim,

…

How to Achieve High Availability, Low Latency and GDPR Compliance in a Distributed SQL Database

April 3, 2019

By Sid Choudhury

Distributed SQL How It Works How To MongoDB PostgreSQL

How to Achieve High Availability, Low Latency and GDPR Compliance in a Distributed SQL Database

YugabyteDB is purpose built for geo-distributed applications that require high availability, high performance and regulatory compliance. In this blog, we are going to “look under the hood,” to explore exactly how YugabyteDB distributes data across multiple clouds, regions and availability zones.

Distributed PostgreSQL on a Google Spanner Architecture – Query Layer

March 18, 2019

By Karthik Ranganathan

Distributed SQL Google Spanner How It Works PostgreSQL YugabyteDB

Distributed PostgreSQL on a Google Spanner Architecture – Query Layer

Our previous post dived into the details of the storage layer of YugabyteDB called DocDB, a distributed document store inspired by Google Spanner. This post focuses on Yugabyte SQL (YSQL), a distributed, highly resilient, PostgreSQL-compatible SQL API layer powered by DocDB. A follow-up post will highlight the challenges faced and lessons learned when engineering such a database.