What’s the difference between PrestoDB and PrestoSQL?
Blog post from Starburst
Presto, originally developed at Facebook, is an open-source distributed SQL query engine designed for high-performance analytics across various data sources, and it functions without storing data by using connectors for databases, data warehouses, and data lakes. PrestoDB and PrestoSQL (now known as Trino) emerged from the original Presto project, with Trino evolving after its developers formed the Presto Software Foundation for better collaboration and independence. Trino has seen faster development and broader adoption, offering additional connectors and enhanced performance, making it suitable for both ad-hoc queries and batch ETL/ELT workloads, while Presto remains focused on analytics workloads. Both engines utilize ANSI SQL syntax, facilitating integration with existing analytics tools, and are supported by platforms such as Starburst for easy deployment and management. While Presto excels in high-speed analytics, Trino is noted for its fault tolerance and ability to handle large-scale data operations, often offering a more streamlined solution compared to using both Presto and Spark.