PostgreSQL

Avantages

1)Open source.
2)Scalable.
3)GUI database design and administration tools.
4)Cross platform.
5)Extensive json support.

Inconvénients

1)Support can be improved.
2)Long learning curve.

Avantages

It's open source and extensible. So you can find great extensions to help you with whatever you need. It uses MVCC (Multi-Version Concurrency Control) to ensure that the data you provide is consistent. It has support for JSON and regex. It can handle parallel queries. There's a great online community to help you solve your problems.

Inconvénients

The interface is a little hard to navigate and could be better, but given the advantages of Postgres, I don't really mind.

Avantages

High performance, ease of use, transparency. PostgreSQL is my favorite RDBMS of the four (MS SQL, SQLite, MySQL) I've used in various projects.

Inconvénients

Occasionally has a feature missing or delayed for want of development resources. Third party GUI interfaces can be buggy or quirky.

Avantages

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.

Inconvénients

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.

Avantages

We set up psql with Greenplum and it was amazing wrt to performance
Even redshift uses psql
Perfect to migrate to psql to set up for cloud
Much advanced from regular sql

Inconvénients

Not great for oltp systems but wonderful for analysis and reporting cases

Avantages

I found it the best among the available open-source solutions for relational databases on the amazon web services. It meets the demands of my clients and also affords technical support at a high level.

Inconvénients

Since this is a relational database so you might found it slow as compared to non-relational databases in the market.

Avantages

It supports a wide range of query syntax and is the most user-friendly software.

Inconvénients

There are way too many reserved keywords. Because of reserved keyword restrictions, we are unable to choose meaningful column names with this many keywords.

Avantages

It is robust, fully featured and free. It has great front ends from different vendors, it is reliable and easy to use.
It does not have its own SQL syntax like others, if you know SQL, it works and supports all the advanced features for later.

Inconvénients

It's hard to say, I picked it up knowing little about database administration and it worked within minutes for me.

Avantages

This manager has it all, with each update they have been implementing more functionalities, it is ideal for any project and maintains a strong integrity.

Inconvénients

The implementation is different in each environment, it can be complicated when going to production.

Avantages

One of the better open source databases out there. Postgres is reliable, versatile and dependable. Highly customizable. Installation is quick. Provides advances options like replication as well. Licensing is simplified

Inconvénients

Management and accessibility tools can be improved

Avantages

I really PostgreSQL becuase how its an open source project , and you can structure PostgreSQL to be both object-oriented and/or relational database functionality. I also like the fact, that a developer (me) can create complex queries.

Inconvénients

PostgreSQL is alittle more complex database handler out on the market, but its really worth it once you know how it operates. It makes database manipulation fun for large scale projects that involve a lot, fast, and complex queries.

Avantages

PostgreSQL will ensure you have a database that is consistent, reliable and free from major errors

Inconvénients

Despite it's robustness, the steep learning curve will probably keep beginners away from it

Avantages

Performant, Secure, Feature-rich and highly ANSI compliant RDBMS with a gold standard testing process (see buildfarm.postgresql.org) and a sane release process.

Inconvénients

Its hard to think of any. You can have it any way you want it; the open source community version which is supported brilliantly on mailing lists, or paid enterprise support if you have ola's/sla's to meet.

Avantages

This is what I would go with in most ideal situations where I'm not coding in .NET languages. It supports the most operating systems, is open source, it handles massive amounts of data compared to all others, and while it may not support as many languages as MySQL it supports the important ones, like Python. It is excellent for data mining and machine learning applications as well as anything else AI related. It is the perfect DB for everything modern.

Inconvénients

It's not user friendly at all. There are some open source GUI tools available but by and large it is command line driven and administered.

Avantages

Postgres is a free lightweight database that is very convenient for all different size programs.

Inconvénients

It can be slower than other paid Database servers.

Avantages

If you are a techie, linux user and very concerned about high end data security then Postgresql is your best bet. It has a light and pretty much textual interface that gives you the "let's get straight to business" feel. PostgreSQL syntax is quite different from mysql syntax so there is this peace of mind that comes with knowing that any developer handling your postgresql must be good. it has an overall Great performance and is a right fit for systems with low hardware specifications.

Inconvénients

It has a boring interface and is less colourful or intriguing. It's complex to make postgresql database dump compatible with mysql.

Avantages

- Reliability: we experienced some problems during production, absolutely none of them caused by Postgres
- Future-proof: horizontal scalability provided by third-party tools (Postgres-BDR)

Inconvénients

- Hard to roll back on initial design
- The new web-based client PgAdmin 4 is a regression from the old desktop client

Avantages

It is easy to set up a PostgreSQL database. It can handle multiple requests at the same time thus reducing the latency.

Inconvénients

It is a little on the expensive side and lacks a few features present in noSQL databases.

Avantages

He is the most powerful base manager I have ever met, and the best thing about this manager is the storage capacity he has.

Inconvénients

When I have problems or errors with this manager, there is not much documentation to be able to solve the problems and this gives me delays when it comes to working.

Avantages

The database is very good, has many important features, but a very important point is that this database is open source with a very permissive license (based on BSD and MIT), this type of license allows a good legal security and an excellent production cost.

Inconvénients

practically without any negative point, the only one that could be a problem is the difficulty in setting up the bank, but using docker is very easy

Avantages

PostgreSQL implements advanced SQL standards.
It's a great transaction database, which fully implements triggers and functions.
Always my first choice for 'from-scratch' development

Inconvénients

Requires some maintenance otherwise performance significantly deteriorates.
Not the first choice for a casual developer (petty).

Avantages

I really like PostgreSQL, I'm a developer and sometimes we had to emulate some data types but with PostgreSQL, it have a lot of flexibility with the data types, we have real boolean and real JSON data types, that help me a lot with new developments

Inconvénients

I really never had a con at all...Maybe what could be a con, could be the database manager that is kind of different to the rest of managers, but if you use a generic one you won't have any problem.

Avantages

Transactional features haves distinguished PostgreSQL from MySQL in the past and was our choice every ti e we need it. It is still very strong, with support for clustering.

Inconvénients

unfortunately it has been surpassed by MariaDB in all areas in my opinion, and it rests only as a second choice if, by any reason, you can’t use MariaDB.

Alternatives envisagées 

Avantages

It's highly efficient and the query options and functions are almost endless. It works well with Hibernate which is essential to our business.

Inconvénients

You do need some specialised skills to use Postgres to its full potential. But as a dev it hasn't been difficult for me to learn what is required to build more specialised queries.

Avantages

Pretty much everything, although there are a few features from commercial databases that I'm hoping will make it in. After having used it for several years, and a certain "M" competitor for several years prior, I can confidently say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

Inconvénients

- Setting up replication can be a bit tricky
- There isn't really a good repository for an up-to-date (or per-version) list of common tips, tricks and queries. Often can be some googling to track down what you're looking for

Avantages

You can have a database with high performance, besides it is an open source technology that is common use with Ruby on Rails, Python or .NET Core

Inconvénients

You need to have some experience to implement it in a production environment or linux server, generally the most common mistake is handle the users.

Avantages

One of the best open source RDBMS database.
Easy to integrate with services and works in high read/writes env.
Advanced features like master slave replication are easy to implement and doesn't take too long for training or implementation.
Used across the software industry, so it has good forums and blogs to support any issues.

Inconvénients

It is very difficult to install postgres on production servers that doesnt have access to internet.
Earlier versions of postgres doesn't support upsert functionality.
Doesn't have a good database client.
Doesn't have a good monitoring mechanism

Avantages

- Straightforward to set up and use
- Plethora of tutorials online as well as good documentation
- Connectivity via a number of different programming languages (personally, I've used both Go and C#)
- It's really fast since it's written in C

Inconvénients

- This is such a minor thing, but I hate that there isn't technically a "SQL command" for showing your tables. With other flavors like MySQL, you can do "show tables" but you can't do that with Postgres. With Postgres the command is "\dt". While this isn't a problem all the time, it's not technically a SQL command so some programming languages don't support it. Keep that in mind if you need to list your tables in your program for some reason.

Avantages

how easy it is to use, install, and deploy on any OS. Enterprise grade open source software!

Inconvénients

There are no major cons that I can think of.

Avantages

+ Free and open-source+ High availability and consistent performance.+ High scalability

Inconvénients

- Commercial support- Backup and recovery process can be more complex than other RDBMS

Avantages

it is a great tool for beginners and experts alike to run databases with SQL or learn SQL language with local databases. It is robust, and works fast.

Inconvénients

It has an obvious learning curve for beginners to know about all its quirks and hidden functions. But no other cons that I could find.

Avantages

Superior performance, high availability options and many advanced SQL techniques built in (compared to MariaDB for example). Version upgrades without any problems so far and little downtime.

Inconvénients

Many configuration and tuning options which are hard to set up properly, although the baseline performance is ok for most use cases.

Avantages

it is free, easy to use, its interface is user friendly and the DBA, it consumes few system resources,

Inconvénients

it is complicated to generate distributed databases, generate a data model graphically, unless you use the enterprise version, if they have a plugin

Avantages

One of the advantages of this database is the ease of its administration.

Inconvénients

One of the disadvantages I have observed is that I can not manage the objects of systems in different tablespace for the order of the objects.

Avantages

This DB can be use for mid term company size. It's having features and functionality to meet your application and DB requirement and can run in a minimum hardware requirements.

Inconvénients

For large size or huge data it's response is not up to the mark.

Avantages

locale and geocode support useful for many specialized applications. Support of standard SQL syntax, and good documentation / updates.

Inconvénients

steep learning curve as with any RDBMS, some replication issues depending on network latency between sites and type of disk storage used.

Avantages

It allows managing structured and unstructured data. It is full compatible with JSON and is scalable capable of handling terabytes of data

Inconvénients

The documentation is not very extensive. The configuration is a bit confusing and the learning curve is a bit slower than other databases.

Avantages

Good full text search capabilities
Good UI tool from PG Admin
Good Security features
Good User and group management

Inconvénients

Requires good stability
Good scalability in the enterprise environment
If we put large text, some times response is very slow
Some times auto vaccume takes time

Avantages

PostgreSQL easy to install and manage in any cloud providers and on premises servers. Database structures also user friendly.

Inconvénients

We are not getting any problems and negative about PostgreSQL based on our usage.

Avantages

The most important thing about PostgreSQL is that it is the best free open source database management system.

Inconvénients

I want you to consider making free books and video tutorials about PostgreSQL and spread it to every language.

Avantages

Open source nature, performance improvements from one version to another, can easily be setup

Inconvénients

Database syncing across two systems is not good.

Avantages

Reliable, Data security and integrity is guaranteed, supports multiple platforms, quick results with queries.

Inconvénients

Regex is not easy, JSON supports needs improvement

Avantages

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

Inconvénients

master/slave configuration a little complex

Avantages

Low costs, full featured, very scalable, redundant

Inconvénients

Support is primarily online communities and is sometimes difficult to find answers for tough questions

Avantages

PostgreSQL has an amazing documentation, you can find anything there. It grows and seems to reply to users needs.

Inconvénients

pgAdmin, a visual tool for managing the database, after upgrading to version 4 it became pretty much unusable for most of our team.

Avantages

This is a really nice DB. It makes everything you need and more. If you hire the correct person, you can sat good bye to your NoSQL DB. Postgres is better than that..

Inconvénients

Not much people master postgresql, it is easy to use, but a lot of experience is required.

Avantages

PostgreSQL is a lightweight database. Data retrieval is fast. The indexing system is great. There are many data types are available.

Inconvénients

It is hard to find documentation. There is a learning curve. I am using this software for more than two years now. No, any other complains.

Avantages

I like it because its installation is unlimited, it is very economical, it is designed for high volume environments, it has very good graphic design and database management tools, it operates on different platforms such as linux, windows, unix, macOS X and has great storage capacity and good stability.

Inconvénients

at first it is difficult to adapt especially if they are windows users, I recommend using it in linux and the sintaxtis of some of its commands or statements is not intuitive at all.

Avantages

It's great that you can store databases that contain a huge amount of information, to feel confident because the software is very secure, great scalability

Also it is FREE

Inconvénients

It sometimes exhibits some slowness, but nothing I can think of other than that

Avantages

PostgreSQL is a very special kind of database, it lets you store data in tables in rows and columns form, while giving you flexibility to JSON data types to make your application flexible. It provides support for a large number of complex data types say JSON, JSONb, Text Array, Integer Array, thus giving you a very powerful database tool.

Inconvénients

It gives very good performance for the first few million record in database, but after that you will need to write your SQL queries very carefully as performance is not that good.