YugabyteDB Engineering & Community Update – July 19, 2019
We are pleased to announce that YugabyteDB 1.3.0 is live! You can read the release notes of this and previous versions here. This release is shipping with 24 new features, enhancements and bug fixes. Beyond enhancements and fixes, the other big news is that we have open sourced the entire core database code! This means that previously closed features like distributed backups, data encryption and replicas are now open sourced. This also means that upcoming features like change data capture and 2 datacenter deployments will open source as well. You can read more about why we decided to make this licensing change by checking out “Why we changed YugabyteDB licensing to 100% open source.”
This release also brings us closer to our 2.0 release at the end of the Summer in which the YSQL API will become generally available.
To learn more about what’s shipping in the 2.0 release check out “YugabyteDB 2.0: A Distributed SQL Roadmap.”
Now, let’s highlight a few items in this release:
[#1656] Enable DO statements (a.k.a Anonymous Blocks)
DO statements execute “anonymous code blocks” in any of the supported PostgreSQL procedural languages. The code block itself treated as though it were the body of a function with no parameters, returning void. These anonymous code blocks are parsed and executed just once. One popular way to make use of a
DO statement is to rather than create a function, call the function, and then drop (or just ignore) the function that you’ll never need again, it’s easier to simply call a single statement. Here’s a simple test of a
do $; begin raise notice 'Hello'; end $; NOTICE: Hello
Thanks to @bllewell for reporting the issue.
In a nutshell, the
CREATE SEQUENCE command creates a new sequence number generator. This involves creating and initializing a new special single-row table. After a sequence is created, you can use the functions
setval to operate on the sequence. With the resolution of issue #999, you can now also
SELECT from a sequence, for example:
CREATE SEQUENCE test_sequence; SELECT nextval('test_sequence'); nextval --------- 1 (1 row) SELECT nextval('test_sequence'); nextval --------- 2 (1 row) SELECT last_value from test_sequence; last_value ------------ 2 (1 row)
With the resolution of issue #1003,
setval()is now supported. For example:
SELECT setval('test_sequence', 10); setval -------- 10 (1 row)
Thanks to @hectorgcr for reporting these two issues.
- How to: The Northwind PostgreSQL Sample Database Running on a Distributed SQL Database
- Why We Changed YugabyteDB Licensing to 100% Open Source
- Announcing YugabyteDB 1.3 with Enterprise Features as Open Source
- Build a Java App with Spring Data JPA with Hibernate ORM Example
- Build a NodeJS App with a Sequelize ORM Example
- Build a Go App with a GORM ORM Example
- Build a Python App with SQL Alchemy ORM Example
- Build a Ruby App with Rails ActiveRecord ORM Example
- Want to contribute code to the YugabyteDB project? Contributor guides are now live!
- A new Benchmarking guide is also available.
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.
- September 20: San Jose, CA
- July 25: Boston PostgreSQL Meetup Group
- July 25-26: Burlington
- Oct 7-10: Austin
Dec 2-7: Las Vegas
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
- Developer Advocate – Remote
- Senior Technical Writer – Remote
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!
Ready to start exploring YugabyteDB? Getting up and running locally with a three node cluster on your laptop is fast. Just download, extract, create the cluster, check its status and your ready to go!
- 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.