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
TeamDesk
Score 9.0 out of 10
N/A
TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.
Simple stories & templates work nicely - like for our Insider program. Stories that include a lot of images may be challenging to create & have look appealing.
TeamDesk is a phenomenal service for our practice. Each legal practice area has unique characteristics that are important to successful practice. Generalized practice management services do address those unique elements because they are created for a mass audience. What makes TeamDesk so helpful is that it can be customized to account for any unique issue that we confront. We use TeamDesk for matter management. It can handle general issues like billing, matter notes, etc.; but it also allows us to track specific details unique to our practice area across each matter and make comparisons that are useful to our practice. Additionally, we have been able to customize it to facilitate our client development efforts.
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.
The ease of customization has been very helpful. As we use the system longer and decide what works for us and what needs changed, it's a matter of moments to be able to make any desired changes. Much more flexible than anything else we've used in the past.
The customer service has been excellent. Any issues that have arisen have been quickly and fully addressed.
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.
The only down side that I see, is that you have to be willing to spend some time creating your database. You start with a blank canvas and all the tools you need to design a custom database. But, you have to take the time to do it. If you take that time, it is well worth it.
I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark
Prior to Teamdesk we used Excel, an Access database, an online time and expense tracking system, and Dabble DB. Excel and Access had limitations with simultaneous access on the LAN, the online T&E system did only that and was not flexible, and Dabble was flexible, but how can you rely on a company whose goal is to exit, when you want to run your business on their platform. Teamdesk has everything we need.
