PostgreSQL

Benefits:

- Free code database manager, which is not used for licensing. - Easy to install and configure in any operating system. - Ideal for relational databases. - It has a large community in which you can share doubts. - It is stable and reliable, scalable and secure with the correct user management. - Can work with small and large databases. - Handles the SQL language. - Being free software, it is compatible with several graphic tools that help administration and database design. I particularly recommend working with PgAdmin in its latest version for postgres 9.6.6 onwards. - Easily works as a cluster, can be configured as active-passive or active-active which improves performance - It allows to perform maintenance, recovery of databases. - I have tested the installation and use in Windows 7 operating system and Debian version 6 to 8 and works without problems. - Likewise I have worked in postgres since its version 8.1 to 9.6.6 and a positive change has been noticed and performance improvements, but I insist on the point at which the databases should be fine designed.

Drawbacks:

- Many people declare it as slow in insertions and updates compared to others Managers, however, that will depend on how well designed the database is. - For some, not having support online or with an official help center can be a big disadvantage. - It is advisable to have command knowledge to work on consoles and terminals to perform a good configuration

In sum:

In my very particular opinion I feel comfortable working with Postgres for more than 10 years, it is reliable and safe, the best thing is that it is free, which allows you to save on licenses, it is ideal for any type of development. I totally recommend it

Benefits:

- Completely and absolutely free - Open-source, so you can look at the code - Every feature you might want in a database is there - Convenient PostgreSQL admin for the management of DB servers

Drawbacks:

- Making replication across several distributed regions can be quite challenging if you haven't done it before.

In sum:

Postgres provides everything I need in a Relational Database System, I have been using it for a while and I swear by it.

Benefits:

PostgreSQL is by far the most user friendly and most advanced database system out of the top 5 popular choices. It's inherently relational making it easily compatible with ORMs, has many smaller quirks like jsonb storage, the WITH keyword, and a vast amount of data types. It's also one of the most dynamic DBMS as it releases major changes more than once a year, with an ecosystem that consistently adapts to these versions.

Drawbacks:

Extensions in pgsql could use a bit of streamlining (extensions like pg_cron or similar), which was a bit complicated to do in with CI. Another concern would be some stability issues with the latest pgAdmin database interface, but in all fairness that isn't directly an issue with pgsql.

In sum:

I use PostgreSQL with almost every endeavor nowadays. Both at work and with personal projects, it is very robust when used in my research field which is optimization and operations research, but also flexible enough to help me quickly deploy web apps.

Benefits:

Love this dialect. I find many of the built in function improve experience but simplifying the needs for cryptic code. For example, changing from data type to another data type, one can use the :: operator. This operator is quick and easy to understand.

Drawbacks:

Unfortunately, sometimes code needs to be translated to more standard SQL that would work across multiple dialect. While the built in functions of PostgresSQL has improved my easy of use and because some of these functions are not standard SQL, I find myself having to continue using more cryptic, yet standard, SQL.

In sum:

Having PostgresSQL has enabled me to streamline development of many data pipelines. Not having to fumble over function parameters because of PostgresSQL's intuitive operations has improved my ease of work.

Benefits:

Free and open source database Ease of scaling the database Easy to work with date, time and timezone jsonb type is really great so we don't need to use non relational database like mongodb fast queries

Drawbacks:

I have yet not found a great admin tool for postgres. pgadmin is ok but It is not as good as phpmyadmin or others.

Benefits:

It's been reliable beyond all expectations. Put your data in Postgres, you know you'll find them when you need them.

Drawbacks:

VACUUMs are a big performance penalty, and the default auto-vacuum settings aren't always optimal for all use cases.

In sum:

We are running tens of Postgres databases and we have no reason to switch.

Benefits:

PostgreSQL is and always has been one of the most feature rich and solid databases available. Its price / performance / feature set is simply unmatched in the industry today.

Drawbacks:

There is a lot of old information on the internet that is no longer relevant to current versions and you must sift through this in some cases to find the modern and elegant solutions. It was touted as "slow" compared to MySQL in the early 2000's and much of that information is wrong due to lack of user experience with the product or no longer the case today.

In sum:

We have never lost data, never paid too much and never looked back. PostgreSQL is at the hear of our organization and our trust has paid off in the long run. Running it on top of a managed stack such as AWS RDS is they way to go as this is the hardest part of using PostgreSQL and you don't want to waste time re-learning what has already been learned. It's worth the cost to use these services in the long run. Rapid prototyping can be done locally and is free so your price to start is always zero!

Benefits:

Stable, resilient, fast. It has everything you could need from a relational database plus more. We have worked on really big databases with no issues when using postgresql.

Drawbacks:

There are some differences in syntax to other SQL databases, but overall they are not hard to understand and learn.

In sum:

We use postgreSQL whenever we can. In our projects in python or elixir we use it as our relational database of choice, and it has not disappointed. It has some domain specific features that can help you keep everything centralized, like document support (json) or full text search (search engine). If you have not tried it, go ahead and do it!

Benefits:

+ Install is very easy + Support almost all platform + Data aggregation is fast + Good documentation from vendor and community + Highly stable + Secured

Drawbacks:

+ Working with JSON etc. is not easy comparable to other products + Poor data compression mechanisms + Bit resource hungry

In sum:

We have deployed 100 of PostgreSQL instances as the back-end for state owned LMS. Databases are well performing and never receive any complaints regarding performance after the GO-LIVE. We have deploy PostgreSQL for simple web application to the enterprise grade internet banking app.

Benefits:

1164/5000 -Easy installation and configuration in other environments. - Pgadmin management interface of the databases, very intuitive and complete with the necessary to a few clicks, I recommend keeping the graphical tool for the stability it offers. -It has a connection balancer, known as pgpool that allows to manage the cluster structure well. -Principles of replication between active-active or active-passive servers Variety of console-level command options for restore or backup tasks and maintenance tasks -principal manager for developers for the scalability and stability it offers. -Management of free access, which allows the use of it without any problem, without any cost -Ideal manager for the management of relational databases -Allows the management of different versions on the same server with multiple database intentions with different listening ports.

Drawbacks:

- Poor documentation - Functional technicians commonly report a slowness at the BD level, but that depends on how the DB is structured and especially if good database practices are applied

In sum:

From my point of view postgreSQL I consider it one of the most powerful database managers, since I use it daily, from my role as a database administrator, as well as a web developer, since it allows to manage environments put into production easily, with an acceptable and intuitive configuration.