App comparison

Add up to 4 apps below to see how they compare. You can also use the "Compare" buttons while browsing.

GetApp offers objective, independent research and verified user reviews. We may earn a referral fee when you visit a vendor through our links. Learn more

PostgreSQL vs MySQL Comparison

Add to Compare

Compare similar apps

Microsoft SQL Server logo

Microsoft SQL Server

4.6

Oracle Database logo

Oracle Database

4.6

MongoDB logo

MongoDB

4.7

SQLite logo

SQLite

4.5

Aiven for PostgreSQL logo

Aiven for PostgreSQL

4.7

MariaDB logo

MariaDB

4.7

Good recommendations?

Overview

Category Leaders

PostgreSQL is an open-source relational database management system (RDBMS), which helps businesses store, manage, and scale...

Category Leaders

MySQL is a relational database management system (RDBMS) designed to help businesses record, update, and manage data and...

  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials
  • Platforms supported
  • Web-based
  • iPhone app
  • Android app
  • Windows Phone app
  • Typical customers
  • Freelancers
  • Small businesses
  • Mid size businesses
  • Large enterprises
  • Customer support
  • Phone
  • Online
  • Knowledge base
  • Video tutorials

Video & Screenshots

No videos yet

Pricing

Starting from

0.01

One-time payment

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

Starting from

2000

/user

Per year

  • Free trial available
  • Credit cardless trial
  • Free account
  • Subscription based

User reviews

4.6

410

5

4

3

2

1

274

126

9

1

0

  • Value for money
  • Ease of use
  • Features
  • Customer support
99%
would recommend this app

4.6

2K

5

4

3

2

1

1.3K

688

75

3

0

  • Value for money
  • Ease of use
  • Features
  • Customer support
99%
would recommend this app

Pros

It is an impressive open source software, really reliable. I love its PostGIS spatial module, which enables powerful geospatial functions.
After switching over from Access, it has been nice to be able to have a more robust experience.
It's a great relational database management system. It's open-source, free, reliable and secure.

Pros

Easy to install and free, nice tool to write SQL queries. Important for data analysts and a good tool on the market.
Overall MySQL is an amazing database for any kind of application. It is robust with almost every feature an application needs.
Great database for open-source but commercial products as well. It has very good performance and lots of additional features (like log-based replication) included without additional cost.

Cons

Probably because of bad stats but from time to time the problem happens again.
Lot of features are missing from it as compared to the other products in the market.
I had skipped the few initial classes and missed the part where the professor taught how to use the app.

Cons

Error messages are not well explanatory. If you are stuck with an issue, it is difficult to get a support.
Really large databases become slow and need a lot of maintenance. Error messages are often vague and unhelpful so finding what went wrong requires a lot of work.
Worst thing is that in scenarios with multitenant databases with somewhat mediocre load MySQL starts to leak memory.
  • Vendor responds to reviews
  • Last review5 months ago
  • Vendor responds to reviews
  • Last review9 days ago

Key features

  • Total features22
  • AI/Machine Learning
  • API
  • Access Controls/Permissions
  • Access Management
  • Active Directory Integration
  • Activity Dashboard
  • Activity Tracking
  • Ad hoc Query
  • Alerts/Escalation
  • Alerts/Notifications
  • Anomaly Detection
  • Application Encryption
  • Application Management
  • Application-Level Analysis
  • Asset Tracking
  • Audit Management
  • Audit Planning
  • Audit Trail
  • Authentication
  • Automated Discovery
  • Automatic Backup
  • Backup and Recovery
  • Behavior Tracking
  • Built-In Database
  • Capacity Management
  • Capacity Planning
  • Change Management
  • Charting
  • Cloud Encryption
  • Collaboration Tools
  • Compliance Management
  • Configurable Workflow
  • Configuration Management
  • Content Filtering
  • Corrective and Preventive Actions (CAPA)
  • Credential Management
  • Customizable Fields
  • Customizable Reports
  • Customizable Templates
  • Dashboard
  • Dashboard Creation
  • Data Capture and Transfer
  • Data Connectors
  • Data Dictionary Management
  • Data Extraction
  • Data Import/Export
  • Data Management
  • Data Mapping
  • Data Migration
  • Data Profiling
  • Data Replication
  • Data Retrieval
  • Data Security
  • Data Storage Management
  • Data Synchronization
  • Data Verification
  • Data Virtualization
  • Data Visualization
  • Database Conversion
  • Database Support
  • Diagnostic Tools
  • Disaster Recovery
  • Disk Encryption
  • Document Storage
  • Drag & Drop
  • Event Logs
  • File Encryption
  • Filtering
  • Full Text Search
  • HIPAA Compliant
  • Hardware Integration
  • Historical Trend Analysis
  • IP Filtering
  • Incident Management
  • Intrusion Detection System
  • Intrusion Prevention System
  • Issue Management
  • Issue Tracking
  • Key Management
  • Log Access
  • ML Algorithm Library
  • Metadata Management
  • Mobile Access
  • Model Training
  • Monitoring
  • Multi-Language
  • Multi-Location
  • Multiple Data Sources
  • Multiple Programming Languages Supported
  • Multitenancy
  • NOSQL Database Management
  • Network Monitoring
  • Next-Generation Firewall
  • OLAP
  • P2P Encryption
  • PCI Compliance
  • Password Management
  • Patch Management
  • Performance Analysis
  • Performance Management
  • Performance Metrics
  • Performance Monitoring
  • Policy Management
  • Predictive Analytics
  • Predictive Modeling
  • Prioritization
  • Query Analysis
  • Real-Time Analytics
  • Real-Time Data
  • Real-Time Monitoring
  • Real-Time Notifications
  • Real-Time Reporting
  • Relational Database Management
  • Remote Access/Control
  • Remote Monitoring & Management
  • Reporting & Statistics
  • Reporting/Analytics
  • Resource Management
  • Resource Optimization
  • Risk Alerts
  • Risk Analysis
  • Risk Assessment
  • Role-Based Permissions
  • SSL Security
  • Search/Filter
  • Secure Data Storage
  • Secure Login
  • Security Auditing
  • Server Monitoring
  • Single Sign On
  • Status Tracking
  • Summary Reports
  • Tagging
  • Third-Party Integrations
  • Threat Response
  • Tokenization
  • Transaction Monitoring
  • Troubleshooting
  • Two-Factor Authentication
  • Uptime Reporting
  • User Management
  • VPN
  • Version Control
  • Visual Analytics
  • Vulnerability Scanning
  • Workflow Management
  • Total features145
  • AI/Machine Learning
  • API
  • Access Controls/Permissions
  • Access Management
  • Active Directory Integration
  • Activity Dashboard
  • Activity Tracking
  • Ad hoc Query
  • Alerts/Escalation
  • Alerts/Notifications
  • Anomaly Detection
  • Application Encryption
  • Application Management
  • Application-Level Analysis
  • Asset Tracking
  • Audit Management
  • Audit Planning
  • Audit Trail
  • Authentication
  • Automated Discovery
  • Automatic Backup
  • Backup and Recovery
  • Behavior Tracking
  • Built-In Database
  • Capacity Management
  • Capacity Planning
  • Change Management
  • Charting
  • Cloud Encryption
  • Collaboration Tools
  • Compliance Management
  • Configurable Workflow
  • Configuration Management
  • Content Filtering
  • Corrective and Preventive Actions (CAPA)
  • Credential Management
  • Customizable Fields
  • Customizable Reports
  • Customizable Templates
  • Dashboard
  • Dashboard Creation
  • Data Capture and Transfer
  • Data Connectors
  • Data Dictionary Management
  • Data Extraction
  • Data Import/Export
  • Data Management
  • Data Mapping
  • Data Migration
  • Data Profiling
  • Data Replication
  • Data Retrieval
  • Data Security
  • Data Storage Management
  • Data Synchronization
  • Data Verification
  • Data Virtualization
  • Data Visualization
  • Database Conversion
  • Database Support
  • Diagnostic Tools
  • Disaster Recovery
  • Disk Encryption
  • Document Storage
  • Drag & Drop
  • Event Logs
  • File Encryption
  • Filtering
  • Full Text Search
  • HIPAA Compliant
  • Hardware Integration
  • Historical Trend Analysis
  • IP Filtering
  • Incident Management
  • Intrusion Detection System
  • Intrusion Prevention System
  • Issue Management
  • Issue Tracking
  • Key Management
  • Log Access
  • ML Algorithm Library
  • Metadata Management
  • Mobile Access
  • Model Training
  • Monitoring
  • Multi-Language
  • Multi-Location
  • Multiple Data Sources
  • Multiple Programming Languages Supported
  • Multitenancy
  • NOSQL Database Management
  • Network Monitoring
  • Next-Generation Firewall
  • OLAP
  • P2P Encryption
  • PCI Compliance
  • Password Management
  • Patch Management
  • Performance Analysis
  • Performance Management
  • Performance Metrics
  • Performance Monitoring
  • Policy Management
  • Predictive Analytics
  • Predictive Modeling
  • Prioritization
  • Query Analysis
  • Real-Time Analytics
  • Real-Time Data
  • Real-Time Monitoring
  • Real-Time Notifications
  • Real-Time Reporting
  • Relational Database Management
  • Remote Access/Control
  • Remote Monitoring & Management
  • Reporting & Statistics
  • Reporting/Analytics
  • Resource Management
  • Resource Optimization
  • Risk Alerts
  • Risk Analysis
  • Risk Assessment
  • Role-Based Permissions
  • SSL Security
  • Search/Filter
  • Secure Data Storage
  • Secure Login
  • Security Auditing
  • Server Monitoring
  • Single Sign On
  • Status Tracking
  • Summary Reports
  • Tagging
  • Third-Party Integrations
  • Threat Response
  • Tokenization
  • Transaction Monitoring
  • Troubleshooting
  • Two-Factor Authentication
  • Uptime Reporting
  • User Management
  • VPN
  • Version Control
  • Visual Analytics
  • Vulnerability Scanning
  • Workflow Management

Integrations

  • Total integrations196
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • HubSpot CRM
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite
  • Total integrations228
  • Bitbucket
  • Datadog
  • Dropbox Business
  • GitHub
  • GitLab
  • Google Drive
  • HubSpot CRM
  • Jenkins
  • Jira
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Teams
  • NetSuite
  • PagerDuty
  • ServiceNow
  • Shopify
  • Slack
  • Trello
  • Zapier
  • Zendesk Suite

User reviews that mention these apps

AG
AvatarImg

Albernes G.

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

PostgreSQL logo

PostgreSQL

easy to use and understand

Reviewed 6 years ago

It can operate on platform specifications, including Linux, Windows, Unix. Large storage capacity Good scalability since it is able to adjust to the number of CPU and the amount of available memory optimally, supporting a greater number of simultaneous requests to the database correctly. It supports the types of data, clauses, functions and commands of standard type SQL92 / SQL99 and extended own of PostgreSQL ..

Pros

its graphic environment and considerable savings in operating costs: PostgreSQL has been designed to have a maintenance and adjustment lower than the products of commercial suppliers, while retaining all the characteristics, stability and performance. Stability and reliability: There have been no drops in the database

Cons

That Compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL Support online: There are official forums, but there is no mandatory help It consumes more resources than MySQL .

AvatarImg
AvatarImg

Morgan C.

Information Technology and Services, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

De facto RDBMS for the Internet

Reviewed 6 years ago

We have run many sites on PostgreSQL with Django at high performance. We use NoSQL where appropriate, but in every case we have still used Postgres for the main data store, and used the key value stores for caching and queueing.

Pros

PostgreSQL is open source. We use it for pretty much every site or system we build. It scales well and needs a minimum of tuning. We only fall back to MySQL when absolutely necessary.

Cons

We still encounter software which can only run on MySQL, especially PHP applications. For those we'll tolerate MySQL but otherwise we would prefer PostgreSQL support.

AR
AvatarImg

Verified reviewer

Information Technology and Services, self-employed

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

PostgreSQL logo

PostgreSQL

Robust and reliable database

Reviewed 4 years ago

Parallel query, for example. MySQL doesn't have.

Pros

- Reliability. - Popular. - Free. - Open Source. - Sophisticated - A lot of 3rd party tools.

Cons

- Vacuum. - Poor backup tools. - A litlle complex to administer.

AR
AvatarImg

Verified reviewer

Computer Software, 1,001-5,000 employees

Used daily for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

Your great alternative for database needs

Reviewed 5 years ago

using it with Ruby on Rails which works perfectly fine. also many data just needed to be dumped, where JSONB comes really handy. you can also query based on the JSONB parameter, which is great. just be careful with your index

Pros

- many neat features such as json as a data structure - have a powerful search when you're not ready to commit with elastic search infrastructure - easy to migrate from MySQL in terms of familiarity (not system migration)

Cons

- some command is simpler in MySQL, especially the CMD command

VC
AvatarImg

Vin C.

Information Technology and Services, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

Fully tried and tested.

Reviewed 2 years ago

Really well supported by the open source community.

Pros

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Cons

Cloud pricing tend to be more expensive vs mysql option.

AR
AvatarImg

Verified reviewer

Computer Software, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

The best free RDBMS!

Reviewed 5 years ago
Pros

Compatible with most software frameworks out of the box, supports advanced features like oplog tailing

Cons

pgSQL has a few gotcha's coming from MSSQL and MySQL users

AR
AvatarImg

Verified reviewer

201-500 employees

Used other for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

PostgreSQL logo

PostgreSQL

Develop and manage different databases thanks to this software

Reviewed 6 years ago

We were able to create databases for projects, configure it in different platforms since it is available in almost any Unix, with 34 platforms in the latest stable version, in addition to a native version of Windows in test status.

Pros

- Unlimited installation: You can not sue a company for installing it on more computers than the license allows. - It has a graphical interface and makes it much easier for unskilled users

Cons

- Compared to MySQL it is slower in insertions and updates, since it has intersection headers that do not have MySQL. - Online support: There are official forums, but there is no mandatory help

AR
AvatarImg

Verified reviewer

Computer Software, 1-10 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

Very fast database

Reviewed 4 years ago

Overall its powerful, robust and fast. My next best RDB after MySQL

Pros

This is a very powerful database and it is very fast. If you want your backend to be an RDB then you should surely use PostgreSQL

Cons

Will sit on top of port 8080 permanently as far as it is in your system preventing you from easily using some stock Vagrant config that uses it.

AvatarImg
AvatarImg

Jash T.

Internet, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

My favourite one

Reviewed 5 years ago
Pros

The best of databases available in Linux-based hosting. Very efficient, fast, relational and transactional. It has many more possibilities than MySQL, among other things, a lot of unique keys in one table, UUID as a primary key. This is my favorite database, I have been programming it for over 5 years. I recommend to all those who value order and stability.

Cons

it has no weaknesses, well, maybe only those in love with their MySQL bases :)

AvatarImg
AvatarImg

Alfredo J.

Information Technology and Services, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

Excellent alternative to MySQL when you need more flexibility

Reviewed 2 years ago

I needed a very efficient database that could handle a huge amount of records, views and access for a data-scraping and analysis project. I was able to very easily do this with a combination of python for data processing, tableau for visualization and postgre-sql for the database. It has been running for a few years without any hiccups and with great efficiency.

Pros

User management is very flexible and the query language support many things that MySQL does not out-of-the-box, more inline with oracle database.

Cons

Not as ubiquitous as MySQL so initial setup and admin is slightly more complicated.

AR
AvatarImg

Verified reviewer

Telecommunications, 201-500 employees

Used monthly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

PostgreSQL logo

PostgreSQL

Delivery master/slave postgresql

Reviewed 2 years ago

very good DB for relation data in IOT enviroment

Pros

simple as mysql and easy to setup single istance, easy dump backup and restore

Cons

master/slave configuration a little complex

RS
AvatarImg

Rahul S.

Food & Beverages, 1-10 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

PostgreSQL logo

PostgreSQL

Gaining popularity

Reviewed 5 years ago
Pros

The DB has flexible data type and can scale really well.

Cons

There is a lot of competition from MYSQL and thus the stickiness might be less.

AR
AvatarImg

Verified reviewer

Information Technology and Services, 11-50 employees

Used daily for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

Simple and easy SQL database with a powerful potential

Reviewed 5 years ago
Pros

It works easy principally in Ruby/Rails applications.

Cons

Depending of the backend language/framework it's better to use MySQL because of bigger community.

AvatarImg
AvatarImg

Pawan P.

Computer Software, self-employed

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

PostreSQL review

Reviewed 3 years ago

Overall the experience with PostgreSQL is pretty good. I have been using it continuously with different web development projects with the Django web development framework.

Pros

Yes, PostgreSQL is easy to use. I have been using it for a year. I have been using it with the Django web development framework as an object-oriented database. One thing I love is it's an open-source and free database that gives us the freedom to modify and use it as per our needs. It's a highly fault-tolerant database available. Also, it's available across the cross-platform. Another prominent feature is that MVCC(Multiversion Concurrency Control) allows the running of multiple queries isolating them from each other. Also, its a widely used database by individuals and enterprises.

Cons

One thing that can be improved is the performance with respect to another popular database MySQL.

AvatarImg
AvatarImg

Samantha N.

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend8/10

Share this review:

PostgreSQL logo

PostgreSQL

The best SQL and open source database.

Reviewed 6 years ago

Because range queries are integrated, it is much less effort to query compared to MySQL.

Pros

 It is fast and reliable, manages inserts and updates of tens of thousands of lines impeccably. PostgreSQL implements SQL standards very well and supports advanced SQL stuff, the PostSQL database works very well with hibernation HPA and we have been using it extensively together with the Spring framework, the consistency is also very good, you will never lose data or lose data. JSON support in the latest version has made things easier for us now, since we do not need to migrate the schema as always before.  Finally, the backup methods through pg_dump are easy to use and ensure that you can always back up before any major changes.

Cons

It is not very intuitive, in my opinion, and I think those problems must be solved before I can get the kind of traction that MySQL has, also more open sources admit mysql but not postgres. These are some of the problems with postgres.

AR
AvatarImg

Verified reviewer

Internet, 11-50 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

The faster open source DBMS

Reviewed 6 years ago

Good performances in big websites using open source software.

Pros

PostGreSQL is the fastest and most modern DBMS in the open source market. It's working properly with major tools in web development field. Some patches may be required for example to run Drupal 8 on a customized PostGreSQL instance, but if you stay in the standard, it should run cleanly.

Cons

PostGreSQL is pretty hard to use compared to MySQL, in my opinion. There are some notions that does not exist in MySQL so coming from this tool to PostGreSQL may need some training before being able to use it properly.

RR
AvatarImg

Randall R.

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend6/10

Share this review:

PostgreSQL logo

PostgreSQL

powerful, flexible db mgmt

Reviewed 6 years ago
Pros

Quality database management tool with expanding functionality and growing community of users. More functionality than MySQL

Cons

Documentation and/or community user support can be a bit spotty for some issues. Fairly steep learning curve as far as setup. Web interface for pgAdmin can be glitchy/slow.

AR
AvatarImg

Verified reviewer

Telecommunications, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

Best database with GUI

Reviewed 4 years ago

We use PostgreSQL as our day to day database to manage our applications whole data and the same is in use for years.

Pros

Some additional query features than MySQL, availability of GUI to manage, view, query, etc. database and schemas

Cons

It's ability to handle large datasets with efficiency, but that's the limitation of relational databases. A little difficult to understand the official documentation.

AA
AvatarImg

Ashish A.

Used daily for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support

Share this review:

PostgreSQL logo

PostgreSQL

Open source object-relational database management system for Web Developers

Reviewed 6 years ago
Pros

PostgreSQL or simply Postgres implements the SQL and advanced SQL standard very well. It can handle workloads ranging from small web applications to large data warehousing with many parallel users. Postgres provides a easy to use tool called pgAdmin to interact with and manipulate database. It provides support for complex data types like (multi-dimensional) Array, Json, user-defined types. PostgreSQL provides higher number of connections at cheap price. It support all types of indexing for faster retrieval of data. In my company we replaced our database server from MySQL to PostgreSQL because of PostgreSQL higher db connections connections in cheaper price as compared to MYSQL. It is also available free of cost till 10,000 rows on Heroku.

Cons

PostgreSQL query syntax for some complex queries like array, json, string functions and case operator are bit complicated to write . Installation and configuration of PostgreSQL is not as easy as MySQL. Documentation is not as good as compared to MySQL and it is bit harder to search for help regarding some complex queries and database functions on google. Replication is not yet as well implemented as in MySQL.

AvatarImg
AvatarImg

Gaurav Y.

Computer Software, 51-200 employees

Used other for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

one of the best SQL family database

Reviewed 5 years ago
Pros

PostgreSql is very good SQL family data base which maintain the ACID property very much effectively. And provide more SQL feature than MySql and does better for Geo data. Also, it handles transaction much better.

Cons

It is not fast as Mysql, for me I thinks this is the only negative of this

AvatarImg
AvatarImg

Michael E.

Investment Management, 501-1,000 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

An easy way to access SQL

Reviewed 4 years ago

After switching over from Access, it has been nice to be able to have a more robust experience.

Pros

The easy to understand interface. It is more intuitive than MySql, and is more enjoyable to work within.

Cons

It is a bit more difficult to work within multiple queries. The ability to quickly maneuver between different queries could be improved.

AR
AvatarImg

Verified reviewer

Financial Services, 5,001-10,000 employees

Used other for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

PostgreSQL logo

PostgreSQL

My go to RDBMS

Reviewed 5 years ago

I've been using Postgres for the past few years and it's served me well.

Pros

Postgres is easy to setup and very extensible. I also like the first class JSON support within Postgres.

Cons

Less support and documentation compared to other RDBMS systems like MySQL. Debatably not as easy to get started.

AvatarImg
AvatarImg

Permana J.

51-200 employees

Used weekly for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

Lesser known database which is actually good

Reviewed 6 years ago
Pros

In my company, PostgreSQL is database choice when creating desktop based application or non-cms solution software. Support standard SQL command. Has all SQL great features. Battle tested and stable.

Cons

Not as popular as MySQL database, so it takes more time when a trouble occur, although it rarely happen.

AR
AvatarImg

Verified reviewer

Consumer Services, 501-1,000 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

PostgreSQL logo

PostgreSQL

Reliable Open-Source Database

Reviewed a year ago

Overall I think, additionally to MySQL, PostgreSQL is my favourite relational database because of the already mentioned benefits.

Pros

The biggest benefits PostgreSQL databases offer are in my opinion that they are super reliable, performant, open-source and are working with common SQL standards.

Cons

If you are really honest, compared to some other alternatives, PostgreSQL databases have a low reading speed.

HS
AvatarImg

Harpaul S.

Information Technology and Services, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

PostgreSQL logo

PostgreSQL

Best DBMS

Reviewed 6 years ago
Pros

unlike mysql, PostgreSQL provide supports for both relational as well as json data storage. Provides functionalities of a perfect hybrid database.

Cons

Sometime indexing do not work for complex queries. Also for very heavy like like a few million record, it needs a lot of memory

DZ
AvatarImg

David Z.

Airlines/Aviation, 1,001-5,000 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

MySQL logo

MySQL

Works well, lower cost sql solution

Reviewed 5 years ago
Pros

Lower cost and reasonably easy to use and develop on

Cons

Could have better syntax like postgresql has

AR
AvatarImg

Verified reviewer

Computer Software, 51-200 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

MySQL logo

MySQL

MySQL is the database of choice for your initial application.

Reviewed 2 years ago

In a handful of our microservices application databases, we use MySQL. We picked MySQL because it is simple to use, has extensive documentation (both official and unofficial), has a big userbase, and is simple to maintain and install with little configuration. The final element is likely the most critical for us right now since we need something done soon to make our application available to the user.

Pros

It is simple to grasp. It is compatible with the majority of popular programming languages. It outperforms and is less expensive than other relational database services on the market.

Cons

In comparison to PostgreSQL or SQL Server, it lacks sophisticated functionalities. For big databases, it does not scale as well as PostgreSQL or SQL Server.

AvatarImg
AvatarImg

George L.

Information Technology and Services, 1-10 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

MySQL logo

MySQL

Not your PostgreSQL but pretty good

Reviewed 5 years ago

Free database, what can I complain? It's worked for me pretty well.

Pros

MySQL is a database of itself. It's not a PostgreSQL for sure, but it's got functionality that is very good for it being free and available for use to anyone. I think the best thing is the integration with website scripting languages and common connectors.

Cons

The syntax isn't the PostgreSQL language which is closer to standard SQL in my opinion. Some syntax wont work on MySQL that would work in PostgreSQL.

BS
AvatarImg

Brett S.

Sports, 1-10 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

MySQL logo

MySQL

A great solution for small to medium databases

Reviewed 5 years ago

We have tested several different DB solutions, but MySQL has been the best for us. We use it to store all of the data in our Taekwondo School's table (roughly 1,000 rows of data as of now).

Pros

It's free, powerful, and the syntax is quite intuitive.

Cons

It doesn't scale as well as Oracle or PostgreSQL.

JS
AvatarImg

Júlio S.

Computer Games, 11-50 employees

Used weekly for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

MySQL logo

MySQL

MySQL is omnipresent in web

Reviewed 6 years ago

I've consumed MySQL databases when developing back-end applications

Pros

MySQL is present in most of the web hosting providers, and has integration with almost programming languages. It has a nice set of features, in pair with their competitors.

Cons

Their workbench software is buggy and it misses some features from PostgreSQL

AvatarImg
AvatarImg

Charles C.

Hospital & Health Care, 501-1,000 employees

Used daily for less than 6 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend7/10

Share this review:

MySQL logo

MySQL

MySQL a good open-source sql platform

Reviewed 3 years ago

I started out with MySQL in my career as a data analyst. Then I didn't have any sql platforms to practice coding on. So it came handy.

Pros

I like how it is consistent with other sql-based platforms like MSSQL and PostgreSQL

Cons

I really don't have much to say about this

SR
AvatarImg

Somnath R.

Computer Software, 1,001-5,000 employees

Used weekly for 1-2 years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

MySQL logo

MySQL

One of the best free database softwares

Reviewed 5 years ago
Pros

Free and fast software. Works well for almost all kinds of uses. Using this with phpMyAdmin works great.

Cons

Does not work very well with very large datasets. Tends to slow down in comparison to PostgreSQL.

AR
AvatarImg

Verified reviewer

Computer Software, 10,001+ employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend9/10

Share this review:

MySQL logo

MySQL

MYSQL Review

Reviewed 5 years ago

Overall it's great RDBMS ,very easy to install and manager.Someone with less experience can manage and build dev or lower environment.

Pros

Easy to install this database in comparison to other RDBMS like oracle,postgresql and microsoft sql server

Cons

GUI needs to be improved because handling sessions from the tool is really cumbersome.session management part needs to be improved.

AvatarImg
AvatarImg

MIKHAIL K.

Internet, self-employed

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

MySQL logo

MySQL

De-facto standard in industry

Reviewed 5 years ago

I use it as primary DB solution in large number of own and my customers projects.

Pros

That is the classic, just can't imagine web development without MySQL. Despite nowdays there are plenty of other modern SQL and NoSQL solutions, MySQL is still one of basic tool, allowing to implement and deploy solution of any size, from amateur projects to enterprise-grade. Well-known DB platform with proven architecture and design, well-documented, open source, has huge community - it would be right choice in many cases.

Cons

Lacking of some features compared to closest competitor, PostgreSQL, like SQL windowing, full outer joins, materialized views etc.

SG
AvatarImg

Sarvesh G.

Computer Software, 11-50 employees

Used daily for 2+ years

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend10/10

Share this review:

MySQL logo

MySQL

Relation Database with power

Reviewed 5 years ago

MySQL has been the goto RDBMS for quick prototyping in use cases for web, cloud or large data sets experimentation.

Pros

Designing data model is a breeze with MySQL. There are so many options for sql client tools. Equally effective for hosting on-premise or any cloud environment.

Cons

Companies moved away to MariaDB after acquisition by Oracle. Can be more feature rich like postgresql.

AvatarImg
AvatarImg

Justas T.

Information Technology and Services, 11-50 employees

Used weekly for 6-12 months

Review source

Overall Rating
  • Value for money
  • Ease of use
  • Features
  • Customer support
  • Likelihood to recommend4/10

Share this review:

MySQL logo

MySQL

Falling behind alternatives

Reviewed 5 years ago
Pros

The original database software most of us know and love Still great as a relational database

Cons

Falling behind in features compared to alternatives such as PostgreSQL Windows development options leave a lot to be desired

AR
AvatarImg

Verified reviewer

Information Technology and Services, 10,001+ employees

Used other for 6-12 months

Review source