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 (https://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.

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.