Microsoft SQL Server vs Presto: What are the differences?
Developers describe Microsoft SQL Server as "A relational database management system developed by Microsoft". Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. On the other hand, Presto is detailed as "Distributed SQL Query Engine for Big Data". Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes.
Microsoft SQL Server can be classified as a tool in the "Databases" category, while Presto is grouped under "Big Data Tools".
"Reliable and easy to use" is the primary reason why developers consider Microsoft SQL Server over the competitors, whereas "Works directly on files in s3 (no ETL)" was stated as the key factor in picking Presto.
Presto is an open source tool with 9.22K GitHub stars and 3.12K GitHub forks. Here's a link to Presto's open source repository on GitHub.
Microsoft, Intuit, and Stack Exchange are some of the popular companies that use Microsoft SQL Server, whereas Presto is used by Airbnb, Facebook, and Netflix. Microsoft SQL Server has a broader approval, being mentioned in 470 company stacks & 425 developers stacks; compared to Presto, which is listed in 19 company stacks and 11 developer stacks.
What is Microsoft SQL Server?
What is Presto?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to add, upvote and see more prosMake informed product decisions
What are the cons of using Presto?
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions
We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.
Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.
Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.
Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.