PostgreSQL

Avantages

Excellent SGBDR facile d'utilisation et gratuit. Je l'ai utilisé à plusieurs reprises pour des applications web et il m'a donné entière satisfaction. Plus robuste que MySQL, il permet de manipuler des quantités importantes de données assez simplement.

Inconvénients

Aucun inconvénient à déplorer jusque là.

Avantages

It is very complete for any type of project or application.
It is stable, easy to use and can handle a lot of structured data.
It is free software and is very well documented
It is very popular and has a very varied community around the project

Inconvénients

Its installation and configuration can be a bit complex at first.
Being free they are not obliged to provide support
Requires specific tuning for each possible scenario

Alternatives envisagées 

Pourquoi choisir PostgreSQL 

Pourquoi passer à PostgreSQL

Avantages

- Postgres is just soooo reliable, it's hard to corrupt or lose data unless you go in and manually edit or delete the data.
- Battle-tested ACID transactions to make sure you only update the data when it makes sense to have saved me so much time.
- The SQL interface is easy to use once you've mastered SQL (which it isn't; it's the simplest of all the languages I've learned).
- Newer versions even has support for advanced use cases such as arrays and JSON objects.
- The best thing is that 90% of the backend software developers know Postgres (or MySQL which is pretty dang similar) so help is never too far away!

Inconvénients

The only real reason to not use Postgres is that it is pretty hard to scale. If your software requires over 10k transactions per second, you're gonna have to put in some serious work make Postgres scale. This is where Postgres becomes a pain to optimize. Postgres provides poor support for identifying the queries that are running really slowly. e.g. you have to install a buggy plugin and then query a funky poorly documented table. Trying to do master-slave replication is also quite difficult as you often run into consistency issues and will have to modify app logic. In these cases, it's better to go with NoSQL obviously.

Alternatives envisagées 

Pourquoi passer à PostgreSQL

Avantages

In my PostgreSQL most important part it’s being free. The rest seems a regular DBMS

Inconvénients

PostgreSQL it’s hard to navigate and configure. Official tool to configure is messy and not very friendly.
Performance is nothing special too.

Avantages

I like how easy it is to set up and deploy a PostgreSQL database. It has a rich ecosystem of tools and a great open-source community behind it.

Inconvénients

I don't have anything I dislike about PostgreSQL.

Alternatives envisagées 

Pourquoi choisir PostgreSQL 

Logiciel antérieur 

Pourquoi passer à PostgreSQL

Avantages

PostgreSQL is a database that every programmer is familiar with. I value its versatility and universality. It's easy to implement it production-wise with not much scale.

Inconvénients

Great for simple applications, when it comes to scaling/replication problems begin.

Alternatives envisagées 

Pourquoi choisir PostgreSQL 

Pourquoi passer à PostgreSQL

Avantages

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.

Inconvénients

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.

Avantages

PostgreSQL is eaiser to maintenance and to install than other RDBMS like ORACLE. PostgreSQL is open source so is cheaper than other RDBMS. It takes less learrning time than other RDBMS

Inconvénients

We do not have any cons about PostgreSQL

Avantages

What I like most about this database engine is its security, scalability and high performance for the development of platforms and web applications, easy to maintain and manage

Inconvénients

That I did not like the product, its difficult or complex syntax, sometimes the very tedious query error

Avantages

PostgreSQL is the most flexible database management system out there. It has a lot of plugins (data visualization, backup, performance, etc), which make it very expandable too, incredibly powerful configuration options, etc. It has almost any type of column that your system will ever need.

Inconvénients

I really don't found any PostgreSQL problem until now, so I would recommend that you use it without any fear.

Alternatives envisagées 

Pourquoi passer à PostgreSQL

Avantages

The way it shows schema wise objects and it compliant with SQL standard.

Inconvénients

When it compared with other similar products its really difficult to find documents and videos to get help.

Avantages

PostgreSQL has several advantages. It is lightweight and reliable. Search filters are very easy to understand. People who know the basics of the SQL language can do several queries, since PostgreSQL assembles selects. I can change it within the table itself, so I don't need to do the update command. On top of that, it's free and open source!

Inconvénients

Sometimes the connection to the database drops (internal server error 500), and it is necessary to connect again. When the query has many records, the data return is slow. They are the only negative points of this tool.

Avantages

One of the advantages of this manager is that it is simple to install and has a free license for various distributions and operating systems. It also allows you to configure the manager according to the team requirements. Other capabilities include the ability to run read-only queries while in recovery mode. pg-Admin, for example, is a graphical application that allows us to simply administer our database. It is a great resource distribution for complex queries, very adjustable, allowing it to be tailored to the needs of individuals who use it, Allows you to limit the number of incoming connections to avoid timeouts caused by developers.

Inconvénients

Indexing is some times very slow. Also database syncing or importing and exporting database is some time a headache. Apart from that, I don't see any major shortcoming in it.

Avantages

One of my favorite features is that PostgreSQL can be learned quickly and easily because there are many resources, it has high performance, it can easily handle very large data operations and high instantaneous transaction loads.

Inconvénients

There is no feature that I do not like. I've done everything I want so far. I am satisfied.

Avantages

PostgreSQL excels in its strong documentation, large data handling, and exceptional security.

Inconvénients

Challenges with screen navigation, JSON handling, and data comparison can make it less user-friendly

Avantages

Free and solid, good user support, good for enterprise, frequent updates.

Inconvénients

Might be difficult at start but it’s still the best free SQL solution.

Avantages

I like that it is easy to learn, that there are lots of good tutorials, and lots of opportunities to practice. I use PostgreSQL almost daily in my job as a data scientist

Inconvénients

There are some weird minute differences between the different versions of SQL.

Avantages

PostgreSQL is a powerful and flexible open-source relational database management system. It offers high performance, rich SQL support, and advanced data types, such as arrays, hstore, and JSON. It can be used for a wide range of use cases, from small web applications to large enterprise systems. The active community provides a wealth of resources, tutorials, and support, which helps to easily create custom functions and operators. It also allows scalability, which makes it suitable for handling an increasing amount of data and users. Additionally, it supports ACID properties, which ensures data consistency and integrity in the database. Overall, PostgreSQL is an excellent choice for businesses looking for a powerful and flexible relational database management system, it offers great features that make it a great tool for most of use cases.

Inconvénients

PostgreSQL is a powerful and versatile open-source database system that offers many advanced features for data management and analysis. Its robust SQL engine and built-in support for advanced data types make it a great choice for a wide range of applications. While the software can be a bit complex to set up and manage for beginners, the comprehensive documentation and active community make it easy to get started. Overall, I highly recommend PostgreSQL for anyone looking for a reliable and feature-rich database solution.

Avantages

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.

Inconvénients

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.

Alternatives envisagées 

Pourquoi passer à PostgreSQL

Avantages

Steady and reliable.
Open source and doesn't require licensing
Very less performance tuning is required

Inconvénients

Don't find native ETL Tool
Yet to see functionality of data marts and data warehousing

Avantages

It's a solid database tested over the years by half of the world. Whatever features you need it has it.

Inconvénients

You'll often need to Google for the exact command you need to run, the docs are very dry and the syntax is unconventional.

You'll suffer greatly trying to write code to access the database.

If you want to upgrade, scale, or do anything significant with a large production database you're probably best off hiring a specialized consultant - it's risky and not easy.

Avantages

The functionality and availability of postgresql db can be highly appreciated.
The parallel schema instaces allows user to run paralled different operations on same dbs.
The file/data type supported are almost all types.
The ability to join more tables than any other rdbms is something postgresql stands out in market.

Inconvénients

I did nt find any cons in postgre as compared to other rdbms,i find it the best in market.
If i need to tell a con then i want it to become as fast as SAP-HANA-DB.

Avantages

The ease of use sets it apart from other tools

Inconvénients

The DB performance , lack of in depth documentation and lack of dedicated customer support to get quick help on critical production loads.

Avantages

Implementing the database in PostgreSQL is quick and efficient. PostgreSQL is much quicker with use-cases. Setting prototypes for development is relatively easier with PostgreSQL. It is a simply a relational database, and stores the data in tables, and supports complex transactions. Accessing data and attribute is faster in PostgreSQL especially when searching for an attribute that is not indexed. So it is great for sorting data in a relatively short period of time.

Inconvénients

PostgreSQL is not flexible to JSON objects, even the nested documents or arrays are not handled with Postgres. It is slow when it comes to processing queries that use nested references, so we had to deal with more complexities at work.

Avantages

PostgreSQL provides many features in its free version which are provided by the RDBMS in their enterprise version like partitioning.

Inconvénients

Almost everything is ease to use in the PostgreSQL but if there can be ease of installation and the custom configuration it will help a lot.