52: Commander Bun Bun takes a bite out of Yugabyte

Video

• Intro: Episode 52: Commander Bun Bun takes a bite out of Yugabyte (0s)
• Trino releases: 428-430 (108s)
• Concept of the episode: Trino, JDBC, and PostgreSQL (390s)
• Concept of the episode: Introducing YugabyteDB (848s)
• Demo of the episode: Using PostgreSQL with Trino (1293s)
• Demo of the episode: Using YugabyteDB with Trino (1796s)
• Demo of the episode: Failover and resiliency with YugabyteDB (2697s)
• Rounding out: Upcoming events, talks, and Trino Summit (3365s)

Audio

Hosts

• Cole Bowden, Developer Advocate at Starburst
• Manfred Moser, Director of Technical Content at Starburst (@simpligility)

Guests

• Denis Magda, Director of Developer Relations at Yugabyte

Releases 428-430

Unofficial highlights from Cole:

Trino 428

• Reduced memory usage for GROUP BY
• Simplified configuration for managing writer counts
• Faster reads for small Parquet files on data lakes
• Support for query options on dynamic tables in Pinot

Trino 429

• Faster reading of ORC files in Hive
• More types supported for schema evolution in Hive
• Security improvements, including logging out of a session with the Web UI

Trino 430

• Improved performance of GROUP BY
• Support for setting a timezone on the session level
• Table statistics in MariaDB

Concept of the episode: JDBC-based connectors

In Trino, we have a lot of connectors that are based on top of JDBC. JDBC could stand for “just da best connectors,” but it’s really Java database connectivity, and it’s one of the core APIs by which many of the most prominent connectors in the Trino ecosystem function. It’s so common, in fact, that we have an example JDBC connector in Trino to make it easier to go implement your own JDBC-based connector if you need one.

Concept of the episode: YugabyteDB

But if the topic of today’s episode is YugabyteDB, why are we talking about PostgreSQL? Well, if you’re unfamiliar with Yugabyte, lifting from their docs: “YugabyteDB is distributed PostgreSQL that delivers on-demand scale, built-in resilience, and a multi-API interface.” Distributed architecture should be a familiar concept to a community involved with a distributed query engine, and if you understand how Trino is able to leverage it, you should also understand why it makes sense to pair with Yugabyte. We’ll be discussing why Yugabyte got started, what it does differently from other databases, what it does better than other databases, and how you might want to use it with Trino.

Demo of the episode: Trino on YugabyteDB

As part of the episode, we’ll also be showing off how you can use YugabyteDB with Trino. We start with using the PostgreSQL connector, then Denis shows how to use the PostgreSQL connector to run Trino with Yugabyte. It’s always hard to explain demos in show notes, so tune into the YouTube video and take a look for yourself if you’re curious!

Rounding out

Trino Summit, the biggest Trino event of the year, is coming up on the 13th and 14th of December, and like Trino Fest, it’ll be fully virtual. If you’d like to give a talk about anything related to Trino, we’re looking for speakers now. Submit your talk here! If you’d rather attend, you can also go register to attend now.

Prior to Trino Summit, if you’d like to learn about SQL from the absolute experts, we’ve also gotten started with the Trino Training Series that we’ll be running as a buildup to the summit. The recap for the first session is live, but there’s three more to come! Register now and look forward to those great sessions starting from the ground up and ending with some key tricks and Trino specifics that even a seasoned SQL veteran may not know about.

We also have a talk about Trino on Ice and data meshes coming up in Redwood City with Slalom and Starburst. If you’re local, consider signing up and checking it out!

If you want to learn more about Trino, get the definitive guide from O’Reilly. You can download the free PDF or buy the book online.

Music for the show is from the Megaman 6 Game Play album by Krzysztof Slowikowski.