The Distributed SQL Blog

Thoughts on distributed databases, open source and cloud native

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! If you are a developer who works with SQL databases, you can appreciate that having foreign keys natively supported in a distributed SQL system is a killer feature! For the uninitiated, a foreign key is defined on a table, but refers to a primary key or a unique key on another table. You can read the docs here, with snippet on how to implement a foreign key below:
create table products(id int primary key, descr text);
create table orders(id int primary key, 
     pid int references products(id) ON DELETE CASCADE, 
     amount int);
  • [#1002] Added support for the ALTER SEQUENCE syntax. With ALTER SEQUENCE you can change the parameters of an existing sequence generator. Any parameters not specifically set in the ALTER SEQUENCE command will retain their prior settings.
  • [#1394] ALTER TABLE .. ADD CONSTRAINT .. UNIQUE now supported.
  • [#717] DROP DATABASE syntax is now supported.
  • [#1134] HASH and RANGE keys are now supported. With range partitioning, a table is partitioned into “ranges” defined by a key column or set of columns, with no overlap between the ranges of values assigned to different partitions. For example, one might partition by date ranges, or by ranges of identifiers for particular business objects. Alternatively, hash partitioning works by partitioning a table on an absolute value and a remainder for each partition. Each partition will then hold the rows for the hash value of the partition key, divided by the specified absolute value and produce the specified remainder.

New Documentation, Blogs, Tutorials, and Videos

New blog posts

New Docs

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?

  • Using YugabyteDB at your company? Tell us about it and we’ll send you a hoodie!
  • 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.

Related Posts