The Distributed SQL Blog

Thoughts on distributed databases, open source, and cloud native

July 10, 2019

YugabyteDB Engineering & Community Update – July 10, 2019

We are pleased to announce that YugabyteDB 1.2.12 is live! You can read the release notes of this and previous versions here. This release is shipping with 11 new enhancements and bug fixes. This also means we are getting closer to our 2.0 release at the end of the Summer in which the YSQL API will become generally available.

What’s YSQL? It’s YugabyteDB’s PostgreSQL-compatible, distributed SQL API.

To learn more about what’s shipping in the 2.0 release check out “YugabyteDB 2.0: A Distributed SQL Roadmap.”

[#1446] Visually Inspect YSQL Commands

This new feature is especially useful to SQL developers.

…

Announcing Distributed SQL Summit Presented by YugaByte and PostgresConf

July 9, 2019

By Jimmy Guerrero

Distributed SQL

Announcing Distributed SQL Summit Presented by YugaByte and PostgresConf

YugaByte is excited to announce in partnership with PostgresConf, that the inaugural Distributed SQL Summit is taking place on September 20, 2019 in San Jose, California! The Distributed SQL Summit is the first ever event to focus exclusively on sharing best practices and technical knowledge on the cloud-native approach to deploying, operating and scaling distributed SQL databases. The Summit will be co-located with PostgresConf Silicon Valley, as a “conference within a conference.”

This one-day event will feature speakers and panelists from some of the biggest names in cloud and database infrastructure including Amazon,

…

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,

…

June 27, 2019

By Jimmy Guerrero

Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – June 27, 2019

We are pleased to announce that YugabyteDB 1.2.11 is live! You can read the release notes of this and previous versions here. This release is shipping with stored procedures support, plus 30 new features, enhancements and bug fixes. Here’s a few highlights from the 1.2.11 release.

What’s YSQL? It’s YugabyteDB’s PostgreSQL-compatible, distributed SQL API.

[#1155] Support for FUNCTION and PROCEDURE

Stored procedures allow developers to “bundle up” operations that would otherwise take several queries and round trips into a single function.

…

GO-JEK’s Performance Benchmarking of CockroachDB, TiDB & YugabyteDB on Kubernetes

June 20, 2019

By Sid Choudhury

CockroachDB Distributed SQL Performance Benchmarks

GO-JEK’s Performance Benchmarking of CockroachDB, TiDB & YugabyteDB on Kubernetes

Iqbal Farabi and Tara Baskara, Systems Engineers from GO-JEK Indonesia, recently presented the results of their benchmarking of cloud native databases on Kubernetes at KubeCon Europe in Barcelona. The three databases they benchmarked were CockroachDB, TiDB and YugabyteDB. This post brings their presentation (video recording) and slides (PDF) to the attention of our readers. It also highlights a few areas of collaboration between the GO-JEK team and YugabyteDB Engineering.

…

Best Practices for Deploying Confluent Kafka, Spring Boot & Distributed SQL Based Streaming Apps on Kubernetes

June 12, 2019

By Sid Choudhury

Distributed SQL How To Kafka Kubernetes Spring

Best Practices for Deploying Confluent Kafka, Spring Boot & Distributed SQL Based Streaming Apps on Kubernetes

In our previous post “Develop IoT Apps with Confluent Kafka, KSQL, Spring Boot & Distributed SQL”, we highlighted how Confluent Kafka, KSQL, Spring Boot and YugabyteDB can be integrated to develop an application responsible for managing Internet-of-Things (IoT) sensor data. In this post, we will review the challenges and best practices associated with deploying such a stateful streaming application on Kubernetes.

Challenges of Streaming Apps

Streaming apps are inherently stateful in nature given the large volume of data managed and that too continuously.

…

How Data Sharding Works in a Distributed SQL Database

June 6, 2019

By Sid Choudhury

Distributed SQL How It Works YugabyteDB

How Data Sharding Works in a Distributed SQL Database

Editor’s note: This post was updated August 28, 2020 to include new sharding features available starting in YugabyteDB 2.2

Enterprises of all sizes are embracing rapid modernization of user-facing applications as part of their broader digital transformation strategy. The relational database (RDBMS) infrastructure that such applications rely on suddenly needs to support much larger data sizes and transaction volumes. However, a monolithic RDBMS tends to quickly get overloaded in such scenarios.

…

June 4, 2019

By Sid Choudhury

Community News Distributed SQL YugabyteDB

YugabyteDB Engineering Update – June 4, 2019

We are pleased to announce that YugabyteDB 1.2.10 is live! You can read the release notes of this and previous versions here. This release is shipping with foreign key support plus 16 new features, enhancements and bug fixes. Here’s a few highlights from the 1.2.10 release:

YSQL Updates

What’s YSQL? It’s YugabyteDB’s PostgreSQL-compatible, distributed SQL API.

Basic support for FOREIGN KEY constraints is now available!

…

Spring Data REST Services Powered By Distributed SQL – A Hands-on Lab

May 30, 2019

By Sid Choudhury

Distributed SQL How To Pivotal Container Service (PKS)Spring

Spring Data REST Services Powered By Distributed SQL – A Hands-on Lab

The Spring application development framework is arguably the most popular framework among Java developers. However, given its extensive breadth and depth, it can be difficult to learn for new users. As the name suggests, Spring Boot makes it easy to `boot up` with the Spring framework. It shortens development time by taking an opinionated view of the framework and the associated third-party libraries. Annotation configuration and default codes are two examples of such a view.

…

May 29, 2019

By Rao Vasireddy

Community News YugabyteDB

YugabyteDB Engineering Update – May 29, 2019

We are pleased to announce that YugabyteDB 1.2.9 is live and available for download! You can read the release notes of this and previous versions here. This release is shipping with 20+ new features, enhancements and bug fixes. Here’s a few highlights from the 1.2.9 release:

…

The Distributed SQL Blog

[#1446] Visually Inspect YSQL Commands

[#1155] Support for FUNCTION and PROCEDURE

Learn More to Accelerate Your Retail Business