YugabyteDB Engineering & Community Update – July 10, 2019

We are pleased to announce that YugabyteDB 1.2.12 is live! You can read the release notes of this and previous versions here. This release is shipping with 11 new enhancements and bug fixes. This also means we are getting closer to our 2.0 release at the end of the Summer in which the YSQL API will become generally available.

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

To learn more about what’s shipping in the 2.0 release check out “YugabyteDB 2.0: A Distributed SQL Roadmap.”

[#1446] Visually Inspect YSQL Commands

This new feature is especially useful to SQL developers. You can now “observe” queries happening against the YSQL API, broken out by connections. To try this out, simply create a new database cluster and perform some queries against the DB using ysqlsh. Then you can browse to the utilities page (http://localhost:9000/utilz) which should display an “RPCs in Progress” section:

Now, click on the YSQL RPCs section and you should see something like:

{
    "connections": [
        {
            "db_oid": 12453,
            "db_name": "postgres",
            "query": "insert into article values(1, 'Book #1', Book #1 content', 9, 1);",
            "application_name": "ysqlsh",
            "process_start_time": "2019-07-08 14:27:43.433156-07",
            "query_start_time": "2019-07-08 15:25:25.642456-07",
            "application_name": "ysqlsh",
            "backend_type": "client backend",
            "backend_status": "idle",
            "host": "127.0.0.1",
            "port": "54972"
        },
        {
            "db_oid": 12453,
            "db_name": "postgres",
            "query": "insert into article values(2, 'Book #2', Book #2 content', 9, 1);",
            "application_name": "ysqlsh",
            "process_start_time": "2019-07-08 14:25:07.803284-07",
            "query_start_time": "2019-07-08 14:26:04.796422-07",
            "application_name": "ysqlsh",
            "backend_type": "client backend",
            "backend_status": "idle",
            "host": "127.0.0.1",
            "port": "54917"
        },
        ...
    ]
}

New Documentation, Blogs, Tutorials, and Videos

New Blogs

• Announcing Distributed SQL Summit Presented by Yugabyte and PostgresConf
• Relational Data Modeling with Foreign Keys in a Distributed SQL Database

New Docs

• 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.

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

• July 10: Chicago PostgreSQL Meetup Group
• July 25: Boston PostgreSQL Meetup Group

SpringOne Tour

• July 9-10: Chicago
• July 15-16: Philadelphia
• July 25-26: Burlington

SpringOne Platform

• Oct 7-10: Austin

AWS re:Invent

• Dec 2-6: 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
• Developer Advocate – Sunnyvale, CA
• 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!

Get Started

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!

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.