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.
July 17, 2019
Category: Distributed SQL
July 16, 2019
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.
…
July 16, 2019
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 9, 2019
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,
…
July 2, 2019
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
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.
…
June 20, 2019
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.
…
June 12, 2019
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.
…
June 6, 2019
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
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!
…