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
Stackby
Score8.8 out of 10
N/A
Stackby is designed to bring together the simplicity of spreadsheets, the functionality of databases and integrations with best business APIs to let anyone build their own tools, the way they want. No coding needed. Users can build a database from scratch, import data from pre-existing sources like spreadsheets or Google Sheets, or choose from over 100 pre-built templates across multiple categories. Stackby offers over 25 unique column types like text,…
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Based on my experience, I can provide specific scenarios where Stackby is well suited and others where it may be less appropriate: Project Management: Stackby is an excellent choice for project management scenarios. Its ability to create custom databases, track tasks, assign responsibilities, and collaborate in real-time makes it highly effective for managing and monitoring project progress. CRM and Sales: Stackby is well suited for managing customer relationships and sales processes. Its customizable database structure allows for organizing customer information, tracking leads, managing deals, and generating reports. The ability to integrate with other tools further enhances its usefulness in CRM and sales workflows. Content Planning: Stackby is a great fit for content planning scenarios. Users can create databases to manage editorial calendars, track content ideas, assign tasks to team members, and monitor content performance. Collaboration features facilitate seamless content collaboration and ensure timely publishing.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Implement the same views available on desktop into the mobile app
Internal automations (like Airtable)
Ability to implement and display info as a dashboard (like Airtable)
Polish up the formatting of formulas, inputting them causes user frustration due to the formula input cursor jumping around
Better intelligence and ease of inputting data in bulk i.e have the fields automatically identify what data is being input and format appropriately (like Airtable does)
Stackby is overall pretty easy to use, especially if you're used to something like Airtable or SmartSuite. Some of the pages seem like near exact clones (though they put their own creative spin on things). I'd prefer a slighty fresher interface (like SmartSuite), but I'm willing to sacrifice that for the better price and great customer service.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
I have also tried Ora.Pm. Infinity has better graphical interface, but nowhere near as many features and the UI isn't as effective (i.e, moving around with keys). Grist has a much more technical interface and it comes from being more of a database/interactive spreadsheet vs Stackby. Grist has much more functionality in terms of formulas, but is much harder to learn to use and less other functionalities. Ora.PM is more of a test at a task management app, and doesn't compare - Stackby is much better.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
