PostgreSQL

Getting Started with TablePlus on a Distributed SQL Database

August 23, 2019

Distributed SQL Ecosystem Integrations PostgreSQL

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.

…

Getting Started with PGAdmin on a Distributed SQL Database

August 14, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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.

…

2019 Distributed SQL Summit Confirmed Speakers & Schedule is Live!

August 9, 2019

By Jimmy Guerrero

Community News Company News Distributed SQL PostgreSQL

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,

…

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

August 1, 2019

By Jimmy Guerrero

Distributed SQL Ecosystem Integrations PostgreSQL

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,

…

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

July 30, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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.

…

Getting Started with DBeaver on a Distributed SQL Database

July 26, 2019

By Jimmy Guerrero

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,

…

PostgreSQL

Explore Distributed SQL and YugabyteDB in Depth