The Distributed SQL Blog

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

August 1, 2019

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.

July 19, 2019

By Jimmy Guerrero

Community News Distributed SQL YugabyteDB

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.

…

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.

Why We Changed YugabyteDB Licensing to 100% Open Source

July 16, 2019

By Karthik Ranganathan

Community News Company News Distributed SQL Open Source YugabyteDB

Why We Changed YugabyteDB Licensing to 100% Open Source

We are excited to announce that YugabyteDB is now 100% open source under the Apache 2.0 license. This means previously closed-source, commercial, enterprise features such as Distributed Backups, Data Encryption, and Read Replicas are now available in the open source project and are completely free to use. The same applies to upcoming new features like Change Data Capture and 2 Data Center Deployments. The result of this change is that we no longer have a Community Edition and an Enterprise Edition of YugabyteDB.

…

Announcing YugabyteDB 1.3 with Enterprise Features as Open Source

July 16, 2019

By Sid Choudhury

Community News Company News Distributed SQL Open Source YugabyteDB

Announcing YugabyteDB 1.3 with Enterprise Features as Open Source

We are very excited to announce the arrival of YugabyteDB 1.3. This post will outline some of the major milestones in this release.

Enterprise Features Move To Open Source

In this release, all the enterprise features in the core DB are now available in open source under the Apache 2.0 license! Effective v1.3, there is no more EE vs CE distinction, there is just one database with all the features you want.

…

July 10, 2019

By Jimmy Guerrero

Community News Release Announcements

YugabyteDB Engineering & Community Update – July 10, 2019

YugabyteDB 1.2.12 is now live with 11 new enhancements and bug fixes. This release brings us closer to the 2.0 version, set for the end of summer, featuring the general availability of the YSQL API

The Distributed SQL Blog

Enterprise Features Move To Open Source

Explore Distributed SQL and YugabyteDB in Depth