70: Previewing a new UI

Introduction

Manfred Moser is joined by Peter Kosztolanyi to talk about the origins, current status, and future of the new Preview Web UI for Trino, before we play around with it in a demo.

Video

• Introduction (0.0s)
• Trino 470 release update (68.0s)
• Introducing Peter Kosztolanyi (538.0s)
• History from legacy UI to preview UI (675.0s)
• Switching between UIs (1088.0s)
• Supported authentication types (1232.0s)
• Start of demo time (1270.0s)
• Looking at the source code and development (1860.0s)
• Call out for other contributors and look at next screens to implement (2870.0s)
• Rounding out with announcements (3320.0s)

Audio

Host

• Manfred Moser, Director/Open Source Engineering at Starburst - @simpligility

Guests

• Peter Kosztolanyi, Analytics Platform Lead at Wise

Releases

Following are some highlights of the Trino releases since episode 69:

Trino 470

• New DuckDB connector
• New Grafana Loki connector
• Support for WITH SESSION for SELECT queries
• Raise minimum runtime requirement to Java 11 for JDBC driver and CLI
• Remove Kinesis connector
• Deprecate use of the legacy file system support for Azure Storage, Google Cloud Storage, IBM Cloud Object Storage, S3 and S3-compatible object storage systems - check out the blog post

As always, numerous performance improvements, bug fixes, and other features were added as well.

Introducing Peter Kosztolanyi

Peter Kosztolanyi is the Analytics Platform Lead at Wise and he presented about their data lake with Abdullah Alkhawatrah at Trino Summit 2024. Peter has a lot of experience in the data and business intelligence fields.

He also contributes to the Trino Python client, and worked on his own phone and messaging app for iOS and Android in the past.

Trino legacy web UI

The existing main web UI for Trino has been around for a long time, and sees very limited development and maintenance. It lacks documentation, a modern look, a clean codebase, and is inconsistent across screens. It is also very technical and developer focussed, and lacks features like a SQL console to run queries.

Efforts for a new UI

While we all knew about the problems of the old UI, nobody with enough UI coding knowledge or time and motivation ever took up the banner to change the situation. We did however get a great new UI contributed in Trino Gateway, and that motivated some people in the community, especially Peter.

Peter started with the same stack, pulled in maintainers like Mateusz Gajewski and Manfred Moser, and kept working on improvements. We talk more about the following aspects:

• Problems with the old UI and its technology stack
• Trino Gateway UI
• Roadmap issue and discussion around the new UI
• What is the stack now?
• Look at the codebase, tools, development, and documentation
• Current status and next steps
• What do we need from others?

Demo time

Peter shows us the new UI from his development setup - the latest and greatest set of features.

Resources

• Preview Web UI documentation
• Preview Web UI codebase
• Roadmap issue
• Legacy Web UI documentation

Rounding out

Join us for upcoming events and let us know if you want to be the next guest.

• Trino contributor call, 27th of February
• Trino Community Broadcast 71 with Jan Waś about the new Faker connector, 27th of February

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.