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:

YSQL Updates

What’s YSQL? It’s YugabyteDB’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

• [#950] – With this issue we implemented RPC heartbeats which allowed us to deliver sub 5 second failovers after a network partition. You can read more details about this fix in the blog, “Achieving Fast Failovers After Network Partitions in a Distributed SQL Database.”

Community Shoutouts

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

New Documentation, Blogs, Tutorials, and Videos

• How to Handle Runaway Queries in a Distributed SQL Database
• 5 Reasons Why Apache Kafka Needs a Distributed SQL Database
• Develop IoT Apps with Confluent Kafka, KSQL, Spring Boot & Distributed SQL
• Achieving Fast Failovers After Network Partitions in a Distributed SQL Database
• My Experience as a YugabyteDB Engineering Intern

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

• June 4: Silicon Valley PostgreSQL Meetup Group
• July 25: Boston PostgreSQL Meetup Group
• July 10: Chicago PostgreSQL Meetup Group

SpringOne Tour

• June 4-5: San Francisco
• June 13-14: Atlanta
• July 9-10: Chicago
• July 15-16: Philadelphia
• July 25-26: Burlington

SpringOne Platform

• Oct 7-10: Austin

AWS re:Invent

• Oct 7-10: Las Vegas

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:

• Software Engineer – Cloud Infrastructure – Sunnyvale, CA
• Software Engineer – Core Database – Sunnyvale, CA
• Software Engineer – Full Stack – Sunnyvale, CA

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 YugabyteDB in depth to databases like CockroachDB, Google Cloud Spanner and MongoDB.
• Get started with YugabyteDB on macOS, Linux, Docker, and Kubernetes.
• Contact us to learn more about licensing, pricing or to schedule a technical overview.