Presto vs. Sequel Pro

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Presto
Score 2.7 out of 10
N/A
Presto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases. Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.N/A
Sequel Pro
Score 9.0 out of 10
N/A
Sequel Pro is a relational database software solution offered by Sequel Pro.N/A
Pricing
PrestoSequel Pro
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
PrestoSequel Pro
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Best Alternatives
PrestoSequel Pro
Small Businesses
SingleStore
SingleStore
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.0 out of 10
Medium-sized Companies
SingleStore
SingleStore
Score 9.0 out of 10
SingleStore
SingleStore
Score 9.0 out of 10
Enterprises
SAP IQ
SAP IQ
Score 9.0 out of 10
SAP IQ
SAP IQ
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
PrestoSequel Pro
Likelihood to Recommend
7.8
(2 ratings)
8.4
(12 ratings)
Support Rating
-
(0 ratings)
7.5
(3 ratings)
User Testimonials
PrestoSequel Pro
Likelihood to Recommend
Open Source
Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
Read full review
Sequel Pro
It's a great tool when building the software, the ability to add SQL and No-SQL databases. Very convenient to write the queries and generate the filtered data we require. Gives the ability to export, import databases of various formats and generate reports from them. It might not be suitable if you want the data to be seen in a visualized manner
Read full review
Pros
Open Source
  • Linking, embedding links and adding images is easy enough.
  • Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
  • Organizing & design is fairly simple with click & drag parameters.
Read full review
Sequel Pro
  • Table filters are simple and easy to use
  • I love the ability to install plugins: Export tables to Laravel migrations is one of our most used plugins
  • Super easy to connect to local Docker containers, Vagrant and remote DBs through SSH
Read full review
Cons
Open Source
  • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
  • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
  • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
Read full review
Sequel Pro
  • It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES.
  • Can be a bit slow.
  • No way that I'm aware of to query multiple databases in the same query.
Read full review
Support Rating
Open Source
No answers on this topic
Sequel Pro
It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.
Read full review
Alternatives Considered
Open Source
Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
Read full review
Sequel Pro
MySQL Workbench is a wonderful tool, but the routine editing of existing data is note nearly as straightforward as it is in Sequel Pro. The ability to sort a data view with a single click makes Sequel Pro my definite choice. phpMyAdmin is pretty ubiquitous, but the routine editing of existing data is much more cumbersome than it is in Sequel Pro.
Read full review
Return on Investment
Open Source
  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
Read full review
Sequel Pro
  • The user interface is great. Since all of our computers are macOS based, we can all use it and share knowledge with our colleagues
  • It enables me to make things in such a faster way that it enables us to spend our time with coding and providing more solutions to our clients
  • The workflow is much improved with the import and export feature, so we don't waste time with that kind of work.
Read full review
ScreenShots