63: Querying with JS

Introduction

Emily Sunaryo from Starburst joins us to talk about her journey to learn about Trino and develop a web application that queries Trino with the trino-js-client.

Video

• Introduction (0.0s)
• Trino 452 and 453 (150.0s)
• Trino Gateway 10: and Trino Contributor Call (515.0s)
• Guest Emily Sunaryo (700.0s)
• Data application with JavaScript and Trino (795.0s)
• Trino clients (1065.0s)
• Tech stack and overview (1197.0s)
• Start of demo and user interface (1300.0s)
• Looking at the details in the code (1630.0s)
• SQL queries (2198.0s)
• Application flow and component setup (2865.0s)
• Trino JS client in VSCode (3080.0s)
• Wrapping up project talk (3576.0s)
• Upcoming events (3695.0s)

Audio

Hosts

• Manfred Moser, Director of Trino Community Leadership at Starburst, (@simpligility)
• Cole Bowden, Developer Advocate at Starburst

Guest

Emily Sunaryo, DevRel Intern at Starburst

Releases and news

Trino 452

• Add Exasol connector.
• Add support for the euclidean_distance(), dot_product(), and cosine_distance() functions.
• Add support for using the BigQuery Storage Read API when using the query table function with the BigQuery connector.
• Add query table function for full query pass-through to the ClickHouse connector.
• Numerous improvements on the Delta Lake, Hive, Hudi, and Iceberg connectors and the related file system support in Trino.

Trino 453

• Improved performance for non-equality joins.
• Support for setting the SQL path for JDBC driver and CLI.
• New execute procedure to run arbitrary statements in the underlying data source.
• Support for reading pgvector vector types in PostgreSQL connector.
• Support for views when using the Iceberg JDBC catalog.

As usual, numerous performance improvements, bug fixes, and other features have been added as well.

Other noteworthy topics:

• The Trino Gateway 10 release is out, and includes some major refactoring and new features.
• The Trino Contributor Call recap is available. Note that the file system support will soon switch to the new Trino-native implementations as default.

Guest Emily Sunaryo

Emily Sunaryo is a recent UC Berkeley graduate working in the Developer Relations team at Starburst. She has a passion for both technical development and also enablement of developer communities. With her degree in Data Science, she is also interested in learning more about modern approaches to data analytics and how emerging technologies can drive innovation in this space.

Trino clients

Trino clients come in many shapes and forms, but all of them allow users to run SQL queries in Trino and access the results. They all use the Trino client REST API. To make it easier for developers of these applications, as well as any custom application, we provide a number of drivers as language-specific wrappers. These include the JDBC driver, the Python client, the Go client, and others.

JavaScript

Filipe Regadas agreed to transfer his trino-js-client project to trinodb and is now subproject maintainer. We are in the process of getting to a first release ready to ship. We would love for you to help us!

Learning about Trino

Emily’s journey and bringing it all together. From university and Starburst internship to the Trino Community Broadcast, and a working demo web application.

Demo time

Emily talks about her demo web application using React, npm, and various other libraries and tools to build a data application. The data resides in Trino, specifically in Starburst Galaxy to make the management easier, and she uses the trino-js-client in her application to run some pretty complex SQL queries again the NYC rideshare data set.

Find more details in the source code repository.

Rounding out

• Trino Summit 2024 is coming on the 11th and 12th of December, and registration, call for speakers, and sponsorship opportunities are open.
• Next Trino Contributor Call on the 22nd of August.
• Next Trino Community Broadcast 64 with the Stackable team about OPA on the 22nd of August.

If you want to learn more about Trino, check out the definitive guide from O’Reilly. You can get the free PDF from Starburst or buy the English, Polish, Chinese, or Japanese edition.