The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

YugaByte DB Engineering Update – May 29, 2019

YugaByte DB Release Updates

We are pleased to announce that YugaByte DB 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:

YSQL Updates

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

  • [#725] – DEFAULT VALUES, OVERRIDING and ON CONFLICT and now supported as optional INSERT clauses. With DEFAULT VALUES, when a new row is created and no values are specified for some of the columns, those columns will be filled with the assigned default values. OVERRIDING can be useful when copying values between tables and want to override any restrictions on a specific column.
  • [#1332] – The COMMENT ON statement is now supported. COMMENT ON is used to store a comment about a database object. Comments can be viewed using PostgreSQL’s \d family of commands.
  • [#1310] – Support for the CREATE and DROP DOMAIN commands has been added. A domain is a data type with optional constraints e.g., NOT NULL, CHECK, etc. Domains are useful for centralizing the management of fields with common constraints. For example, some tables might contain the text columns that require a CHECK constraint to ensure that values are not null and that they also do not contain a space.

System, Usability and Deployment Improvements

Community Shoutouts

Thanks to @aegershman, @dodlip, @swayamraina, @hiqbn, @RashmiPanthangi, @jinfengnarvar, and @lokeshlal for logging issues and enhancement requests.

New Documentation, Blogs, Tutorials, and Videos

Upcoming Meetups and Conferences

We will be at a number of conferences and meetups over the next few months, below are some select few with the highlights. Do stop by, say hello and ask us any questions you have.

PostgreSQL Meetups

SpringOne Tour

SpringOne Platform

AWS re:Invent

We are Hiring!

YugaByte is growing fast and we’d like you to help us keep the momentum going! Check out our currently open positions:

Our team consists of domain experts from leading software companies such as Facebook, Oracle, Nutanix, Google and LinkedIn. We have come a long way in a short time but we cannot rest on our past accomplishments. We need your ideas and skills to make us better at every function that is necessary to create the next great software company. All while having tons of fun and blazing new trails!

What’s Next?

  • Compare YugaByte DB in depth to databases like CockroachDB, Google Cloud Spanner and MongoDB.
  • Get started with YugaByte DB on macOS, Linux, Docker, and Kubernetes.
  • Contact us to learn more about licensing, pricing or to schedule a technical overview.

Related Posts