The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

Best Practices and Recommendations for Distributed SQL on Kubernetes

YugabyteDB and Kubernetes have very complementary design principles because they both rely on an extensible and flexible API layer, as well as a scale-out architecture for performance and availability. In this blog post we’ll look at best practices and recommendations when choosing Kubernetes as the cluster foundation for a distributed SQL system. This will begin with a review of relevant architectural decisions of the YugabyteDB.

Read More

Getting Started with PGAdmin on a Distributed SQL Database

If you’re a database developer, you already understand the importance of a tool to manage your databases. Whether it is for creating schemas, ad-hoc querying, backups, or diving deeper to troubleshoot a database issue, a database tool can make your life much easier and increase your productivity. In a previous post we covered how to get started with DBeaver,

Read More

YugaByte DB Engineering & Community Update – Aug 9, 2019

We are pleased to announce that YugabyteDB 1.3.1 is live! You can read the release notes of this and previous versions here. This release is shipping with 22 new features, enhancements and bug fixes. This release also brings us closer to our 2.0 release which will be shipping in a few weeks. The flagship feature in 2.0 will be the YSQL API becoming generally available.

Read More

Getting Started with SQL Workbench/J on a Distributed SQL Database

Although most databases ship with a command line utility to administer the instance, these utilities often come with a steep learning curve. If using the command line and learning sometimes arcane syntax makes you uncomfortable, there are graphical tools that can help you speed up many daily DBA tasks. In fact, you can find a comprehensive list of tools on the PostgreSQL wiki here.

Read More

PostgreSQL How To: Installing the Chinook Sample DB on a Distributed SQL Database

In this post we are going to walk you through how to download and install the PostgreSQL version of the Chinook sample DB on the YugaByte DB distributed SQL database with a replication factor of 3.

What’s YugaByte DB? It’s a high performance distributed SQL database for global, internet-scale apps. YugaByte DB is a PostgreSQL-compatible database.

Read More

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,

Read More

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