Start Now

PostgreSQL Compatibility in YugabyteDB 2.0

The team at Yugabyte and members of the community were excited to announce the general availability of YugabyteDB 2.0 this week. One of the flagship features of the release was the production readiness of the PostgreSQL compatible, Yugabyte SQL API (YSQL). In other blogs we covered Jepsen testing results, new performance benchmarks and ecosystem integrations including the GraphQL projects Hasura and Prisma. In this post we’d like to take the opportunity to dive a little deeper into the PostgreSQL compatibility features to demonstrate what’s supported and what’s around the corner.

Read more

YugabyteDB’s Distributed SQL API Jepsen Test Results

Note: You can join the discussion on Hacker News here.

We are very excited to announce that the SQL API of YugabyteDB v1.3.1.2 passed Jepsen testing performed by Kyle Kingsbury [Edit] (with the exception of transactional DDL support, which almost no other distributed SQL database vendor supports, and we plan to support soon. The real-world impact of this open issue is minor as it is limited to cases where DML happens before DDL has fully completed).

Read more

Getting Started with TablePlus 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 posts we covered how to get started with DBeaver, PGAdmin, and SQL Workbench/J. in this post we’ll show you how to get up and running with YugabyteDB and TablePlus.

Read more

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

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!

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

YugabyteDB 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.

What’s YSQL?

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. 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

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

Get started in any cloud, container or data center