Distributed SQL

Low Latency Reads in Geo-Distributed SQL with Raft Leader Leases

Low Latency Reads in Geo-Distributed SQL with Raft Leader Leases

Note: This post contains interactive animations that explain how some of these complex algorithms work. Please view this post in a suitable media (at least 1000px by 600px screen resolution) for best results.

In this blog post, we are going to dive deep into the read performance of Raft – why read performance can take a hit and how it can be improved using leader leases. Additionally, we will also look at how to make the correctness guarantees around leader leases stronger.

Read more

Getting Started with PGAdmin on a Distributed SQL Database

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, and in this post we’ll show you how to get up and running with YugabyteDB and PGAdmin.

Read more

2019 Distributed SQL Summit Confirmed Speakers & Schedule is Live!

2019 Distributed SQL Summit Confirmed Speakers & Schedule is Live!

YugaByte is excited to announce that speaker schedule for this year’s Distributed SQL Summit is live!

Distributed SQL Summit is a full day of talks from experts on what it takes to build, deploy and scale distributed SQL databases in the cloud and on Kubernetes.

Presented in partnership with PostgresConf, the inaugural Distributed SQL Summit is taking place on September 20, 2019 in San Jose,

Read more

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

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. In a previous blog we explored the DBeaver database management tool,

Read more

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

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 YugabyteDB distributed SQL database with a replication factor of 3.

What’s YugabyteDB? It’s a high performance distributed SQL database for global, internet-scale apps. YugabyteDB is a PostgreSQL-compatible database. Similar to Google Spanner, YugabyteDB gives you all the scalability characteristics of NoSQL, without sacrificing the ACID transactions or strong consistency you are accustomed to with PostgreSQL.

Read more

Getting Started with DBeaver on a Distributed SQL Database

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,

Read more

YugabyteDB Engineering & Community Update – July 19, 2019

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, data encryption and replicas are now open sourced. This also means that upcoming features like change data capture and 2 datacenter deployments will open source as well.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free