Awesome Presto

A curated list of awesome PrestoDB and Trino(f.k.a PrestoSQL) software, libraries, tools and resources

Table of Contents

• Awesome Presto
  • Trino
  • PrestoDB
  • GUIs
  • Libraries
  • Plugins
  • Tools
  • Docker Images
  • Resources

Trino

• Trino

PrestoDB

• PrestoDB

GUIs

• Airpal - Web UI for PrestoDB
• Apache Superset (incubating) - Apache Superset (incubating) is a modern, enterprise-ready business intelligence web application
• quix - Presto-based notebook manager
• yanagishima - Web UI for Presto, Hive, Elasticsearch, SparkSQL
• Redash - Query Editor, data visualization and dashboards for multiple databases
• Metabase - Metabase is the easy, open source way for everyone in your company to ask questions and learn from data.

Libraries

• Python client for Presto - Python DB-API client for Presto
• PrestoClient - A .NET client for Presto
• pyHive - Python interface to Hive and Presto
• transport - A framework for writing performant user-defined functions (UDFs) that are portable across a variety of engines including Apache Spark, Apache Hive, and Presto
• Presto User-Defined Functions - Presto User-Defined Functions(UDFs)

Plugins

• Built-in Connectors - Accumulo, Black Hole, Cassandra, Elasticsearch, Hive, JMX, Kafka, Kafka, Kudu, Local File, Memory, MongoDB, MySQL, Phoenix , PostgreSQL, Redis, Redshift, SQL Server, System, Thrift, TPCDS and TPCH Connector
• Presto Pulsar connector - Pulsar SQL: Presto Pulsar connector
• Db2 JDBC connector for Trino - Trino Connector for IBM DB2
• Presto HBase Connector
• Presto Query Audit Log - Plugin for Presto to save queries and metrics into files
• https://github.com/rchukh/presto-querylog
• https://github.com/Shopify/presto-logging-plugin
• https://github.com/sudip02/presto-event-listener-plugin

Tools

• presto-gateway - A load balancer / proxy / gateway for prestodb
• Prestogres - PostgreSQL protocol gateway for Presto
• https://github.com/toyama0919/embulk-input-presto
• usql - Universal command-line interface for SQL databases

Docker Images

• https://hub.docker.com/r/trinodb/trino
• https://github.com/starburstdata/docker-images
• https://github.com/Lewuathe/docker-presto-cluster
• https://github.com/zhicwu/docker-presto
• https://github.com/ChethanUK/PrestoSQL-Docker

Resources

• Presto Newsletter - Monthly Presto Newsletter curated by Starburst
• Presto Summit 2019
• Presto Summit 2018
• Presto Conference 2019 @ Israel