Microsoft SQL Server vs MySQL vs PostgreSQL

Microsoft SQL Server
Microsoft SQL Server

3.4K
717
520
MySQL
MySQL

20.8K
5.8K
3.7K
PostgreSQL
PostgreSQL

15K
5.5K
3.4K

Microsoft SQL Server vs MySQL vs PostgreSQL: What are the differences?

MySQL is the most popular amongst the relational databases and is a widely used one too. Offers a fully-managed database service for Google Cloud platform and is a scalable database with high availability and security at no extra cost. PostgreSQL is a fully managed and scalable relational database with high availability and security built in at no additional charge. It is a fully managed database service for the Google Cloud Platform. Is better in query optimization and query execution as compared to MySQL. Postgres has a storage engine which is suitable for INSERTand complex search applications such as data mining. Microsoft SQL Server developed by Microsoft has multiple editions with different feature sets and user profiles. It has some fantastic features like SQL server on Linux, resumable online index build, machine learning services, query processing improvements, and much more.

- No public GitHub repository available -

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

What is MySQL?

The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.

What is PostgreSQL?

PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.

Want advice about which of these to choose?Ask the StackShare community!

Why do developers choose Microsoft SQL Server?
Why do developers choose MySQL?
Why do developers choose PostgreSQL?
What are the cons of using Microsoft SQL Server?
What are the cons of using MySQL?
What are the cons of using PostgreSQL?
What companies use Microsoft SQL Server?
What companies use MySQL?
What companies use PostgreSQL?
What are some alternatives to Microsoft SQL Server, MySQL, and PostgreSQL?
Oracle
Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
Apache Aurora
Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
MongoDB
MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
MariaDB
Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry. MariaDB is designed as a drop-in replacement of MySQL(R) with more features, new storage engines, fewer bugs, and better performance.
SQLite
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
See all alternatives
What tools integrate with Microsoft SQL Server?
What tools integrate with MySQL?
What tools integrate with PostgreSQL?
    No integrations found
      No integrations found
        No integrations found
        Decisions about Microsoft SQL Server, MySQL, and PostgreSQL
        Alex A
        Alex A
        Founder at PRIZ Guru · | 6 upvotes · 8.4K views
        atPRIZ GuruPRIZ Guru
        PostgreSQL
        MySQL

        One of our battles at the very beginning of the road was choosing the right database. In fact, our first prototype was built on MySQL and back then nothing else was even under a consideration (don't ask me why). At some point, I was working on a project which was running on PostgreSQL and it is only then I understood the full power of it. We have over a billion of records in production instance, and we are able to optimize it to run fast and reliable. Well, now my default DB is PostgreSQL :)

        See more
        Tor Hagemann
        Tor Hagemann
        at Socotra · | 2 upvotes · 2.1K views
        atSocotraSocotra
        Amazon DynamoDB
        PostgreSQL
        MySQL

        Much of our data model is relational, which makes MySQL or PostgreSQL (and family) fit the API's we need to build, in order to meet the needs of our customers.

        Sometimes the flexibility of a NoSQL store like Amazon DynamoDB is very useful, but the lack of consistency really impacts usability and performance long-term, compared with viable alternatives. At our current scale, we've seen huge benefits from moving some of our tables out of Dynamo and doing more in SQL.

        There will always be use cases for NoSQL and key-values stores, but if your model is well understood in your business/industry: relational databases are the way to go after finding product-market fit. Always understand the trade-offs (and a few intimate details) of any data store before you add to your company's stack!

        See more
        Joseph Irving
        Joseph Irving
        DevOps Engineer at uSwitch · | 8 upvotes · 4.1K views
        atuSwitchuSwitch
        Go
        PostgreSQL
        MySQL
        Kubernetes
        Vault

        At uSwitch we use Vault to generate short lived database credentials for our applications running in Kubernetes. We wanted to move from an environment where we had 100 dbs with a variety of static passwords being shared around to a place where each pod would have credentials that only last for its lifetime.

        We chose vault because:

        • It had built in Kubernetes support so we could use service accounts to permission which pods could access which database.

        • A terraform provider so that we could configure both our RDS instances and their vault configuration in one place.

        • A variety of database providers including MySQL/PostgreSQL (our most common dbs).

        • A good api/Go -sdk so that we could build tooling around it to simplify development worfklow.

        • It had other features we would utilise such as PKI

        See more
        Interest over time
        Reviews of Microsoft SQL Server, MySQL, and PostgreSQL
        No reviews found
        How developers use Microsoft SQL Server, MySQL, and PostgreSQL
        Avatar of AngeloR
        AngeloR uses PostgreSQLPostgreSQL

        We use postgresql for the merge between sql/nosql. A lot of our data is unstructured JSON, or JSON that is currently in flux due to some MVP/interation processes that are going on. PostgreSQL gives the capability to do this.

        At the moment PostgreSQL on amazon is only at 9.5 which is one minor version down from support for document fragment updates which is something that we are waiting for. However, that may be some ways away.

        Other than that, we are using PostgreSQL as our main SQL store as a replacement for all the MSSQL databases that we have. Not only does it have great support through RDS (small ops team), but it also has some great ways for us to migrate off RDS to managed EC2 instances down the line if we need to.

        Avatar of Cloudcraft
        Cloudcraft uses PostgreSQLPostgreSQL

        PostgreSQL combines the best aspects of traditional SQL databases such as reliability, consistent performance, transactions, querying power, etc. with the flexibility of schemaless noSQL systems that are all the rage these days. Through the powerful JSON column types and indexes, you can now have your cake and eat it too! PostgreSQL may seem a bit arcane and old fashioned at first, but the developers have clearly shown that they understand databases and the storage trends better than almost anyone else. It definitely deserves to be part of everyone's toolbox; when you find yourself needing rock solid performance, operational simplicity and reliability, reach for PostgresQL.

        Avatar of Brandon Adams
        Brandon Adams uses PostgreSQLPostgreSQL

        Relational data stores solve a lot of problems reasonably well. Postgres has some data types that are really handy such as spatial, json, and a plethora of useful dates and integers. It has good availability of indexing solutions, and is well-supported for both custom modifications as well as hosting options (I like Amazon's Postgres for RDS). I use HoneySQL for Clojure as a composable AST that translates reliably to SQL. I typically use JDBC on Clojure, usually via org.clojure/java.jdbc.

        Avatar of Rajeshkumar T
        Rajeshkumar T uses MySQLMySQL
        • We are used MySQL database to build the Online Food Ordering System

          • Its best support normalization and all joins ( Restaurant details & Ordering, customer management, food menu, order transaction & food delivery).
          • Best for performance and structured the data.
          • Its help to stored the instant updates received from food delivery app ( update the real-time driver GPS location).
        Avatar of Srinivas Adireddi
        Srinivas Adireddi uses MySQLMySQL

        1.It's very popular. Heared about it in Database class 2. The most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. 3. MySQL is an open-source relational database management system. Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language.

        Avatar of ShadowICT
        ShadowICT uses MySQLMySQL

        We use MySQL and variants thereof to store the data for our projects such as the community. MySQL being a well established product means that support is available whenever it is required along with an extensive list of support articles all over the web for diagnosing issues. Variants are also used where needed when, for example, better performance is needed.

        Avatar of ReviewTrackers
        ReviewTrackers uses PostgreSQLPostgreSQL

        PostgreSQL is responsible for nearly all data storage, validation and integrity. We leverage constraints, functions and custom extensions to ensure we have only one source of truth for our data access rules and that those rules live as close to the data as possible. Call us crazy, but ORMs only lead to ruin and despair.

        Avatar of shridhardalavi
        shridhardalavi uses MySQLMySQL

        MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use.

        Avatar of Jeff Flynn
        Jeff Flynn uses PostgreSQLPostgreSQL

        Tried MongoDB - early euphoria - later dread. Tried MySQL - not bad at all. Found PostgreSQL - will never go back. So much support for this it should be your first choice. Simple local (free) installation, and one-click setup in Heroku - lots of options in terms of pricing/performance combinations.

        Avatar of Brillium, Inc.
        Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

        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.

        Avatar of John Galbraith
        John Galbraith uses MySQLMySQL

        I am not using this DB for blog posts or data stored on the site. I am using to track IP addresses and fully qualified domain names of attacker machines that either posted spam on my website, pig flooded me, or had more that a certain number of failed SSH attempts.

        Avatar of Andrew Miller
        Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

        Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

        Avatar of David Flynn
        David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

        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.

        Avatar of Olo
        Olo uses Microsoft SQL ServerMicrosoft SQL Server

        Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

        Avatar of Arbor Health, LLC
        Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

        Managing script output and input, as well as data cleansing.

        How much does Microsoft SQL Server cost?
        How much does MySQL cost?
        How much does PostgreSQL cost?
        Pricing unavailable
        Pricing unavailable
        Pricing unavailable