15 ans à aider les entreprises françaises
à choisir le meilleur logiciel
En savoir plus sur PostgreSQL
Système de base de données post-relationnelle open source gratuit. Le choix de prédilection des développeurs et administrateurs de bases de données dans le monde entier. Robuste, sécurisé et hautement performant.
The price vs others other there ie, MSSQL is a lot better. It is able to capture and process data very quickly.
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.
Filtrer les avis (400)
Classer par
Filtrer les avis (400)

Alternatives envisagées précédemment :
One of the best overall databases in the market
Commentaires : For overall backend database purposes I would currently not choose anything other than PostgreSQL. Widely known, easy to hire talent for, secure and reliable.
Avantages :
PostgreSQL is well supported by backend frameworks like Django. Getting into the command line of PostgreSQL database isn't necessary that often, but when a must, it works very robustly.
Inconvénients :
Not suitable for some data types as well as some of the competition, like time series data, that is becoming more and more important via IoT use cases.
Alternatives envisagées précédemment :
The Reliable Workhorse with Infinite Flexibility
Commentaires : Nothing short of exceptional. It covers all the bases with its reliability and performance, and its flexibility is unmatched. I've found it difficult to recommend any other database unless you have specific requirements, such as a document store or a graph database. Postgres fills in all the gaps and has become my go-to choice for any project that requires a rock-solid, flexible relational database.
Avantages :
does the basics like a pro while offering infinite flexibility. From JSON columns to full-text search, there's a plugin for every need. Plus, it plays nicely with every ORM known to man. Postgres has mastered the art of doing the basics exceptionally well. It's reliable, performant, and stands strong as a relational database. But what sets it apart is the remarkable flexibility it offers. Need to store and query JSON data? No problem. Looking for full-text search capabilities? Postgres has your back with plugins that can handle it all. This database truly adapts to your evolving needs, making it a versatile choice for any project.
Inconvénients :
No Issues at All, Just Vendor Restrictions. Now, I have to dig deep to find something negative about Postgres. The truth is, I haven't encountered any issues with Postgres itself. Its robustness and stability have been flawless in my experience. If I had to point a finger, it would be at the vendors (like Heroku) who occasionally restrict certain plugins. But hey, that's not Postgres's fault—it's still a champ in its own right.
PostgreSQL is an Open Source tool of the highest caliber for Database Management.
Commentaires : Nowadays, I nearly always utilise PostgreSQL for my projects. It is incredibly durable when utilised in my engineering sector both at business and with home projects, yet versatile enough to support my speedy deployment of web apps.
Avantages :
I love using PostgreSQL for the following main reasons, firstly databases with a lot of data can be stored, it is possible to have different settings for various databases on a same server and on top that it costs nothing to use PostgreSQL since it is an open source software.
Inconvénients :
One of the drawback of the PostgreSQL is CPU usage is rather high.

Relational database with less capability
Commentaires : It is used when a commercial partner vendor introduces a commercial system and creates a small-scale system. If you connect multiple units, it is easy to use with a response that can support the operation without installing a dedicated server machine. When using packaged software in a large-scale system, there may be restrictions on the number of data elements and the number of servers connected, but we were able to reduce installation and operation costs. I was able to keep the cost of the database low and spend money on packaged software options.
Avantages :
Since it was developed to comply with SQL standards, there are no problems migrating from other RDBMS. I think the popularity of MySQL as an RDBMS is split in two, but PostgreSQL does not have the following MySQL keylogging problem, so it can be said that it is an RDBMS with little custom. We recommend PostgreSQL as the first choice for RDBMS unless otherwise specified because it works stably and can support real operations. When a small business is a customer's system project, the RDBMS license fee is often too high to pay. In such cases, customers will be happy to propose PostgreSQL, which is stable, reliable, and free to use. Unless it is a situation that requires a paid database, I think PostgreSQL is sufficient. It is not inferior to the function.
Inconvénients :
When you are looking for something you want to look up in a manual, it is often difficult to find it and, in the end, you often consult blog articles written by experts instead of the manual. I want the structure of the manual to be easy to understand.

High Performance
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.

Alternatives envisagées précédemment :
PostgreSQL - A World Class DBMS that you can have for free
Commentaires : I have used PostgreSQL for Windows since 2008 and it has been a pleasure. Some DBs have tables with more than 1 million records and performance seems not to be affected.
Avantages :
It is free although there are some paid options that include support and special configurations. It is very stable, I have not had any critical situations like data loss. As a ASP.NET developer, it integrates easy using ADO.NET Data Providers for which there are many choices. Concurrency control is included which is very useful for data integrity. Versions for Linux, Mac, Solaris and BSD are available which increases the integration power. A huge number of third party add-ons (paid and free) can be found. PostgreSQL is being continuously improving, there is a well defined plan of maintenance and new versions are coming out regularly.
Inconvénients :
I have not found anything against this DMBS product. I have accomplished all of my goals successfully.

Alternatives envisagées précédemment :
PSQL databse.
Commentaires : Overall this is good software to use when you in a large applications.
Avantages :
This is one of the best database software I’ve used. It has a lot of features/functions that are usable for Big projects. One of them I've use is the PSQL vector search that is not widely used but very important feature that built in PSQL, beside that it has a tons of usable functions to do operations inside database and then get the result for example timezone adjusting, manipulation with data, string function and etc.
Inconvénients :
Trully telling there should be few cons in this software. I've used this for over 4 years sometimes find to difficult to configure it it linux environments compared with mysql.

The database everyone should be using
Commentaires :
PostgreSQL is an incredibly powerful piece of software that should be the RDBMS in every software project instead of less powerful but more famous alternatives.
Personally it will be my choice for every future project.
Avantages :
PostgreSQL is so powerful, complete and stable. This should come with no surprise given the long history behind it. At the same time it's incredibly modern and supports new paradigms (like NoSQL, JSON data types) and it's also very simple to familiarize with.
Inconvénients :
It's unbelievable how PostgreSQL is not as well-known as one of his competitors (MySQL) notwithstanding the fact that is so much more powerful.
IY_Postgre
Commentaires : It's a very good database application. I use it as a hobby
Avantages :
one of the most successful database applications I have used, its interface is easy and it is nice to open different pages in tab form. I also loved that it included a dark theme.
Inconvénients :
Although the code is correct, it says there is an error when the code is run, sometimes I waste time searching for this non-existent error.
A good DB for any kind of company
Avantages :
It's a very powerful DB for the price, it has all the features and customization that any db admin needs.
Inconvénients :
Without a db admin, the features may be restricted to the basic ones, unless someone researches how to do things
One of the best to manage DB connections
Avantages :
We have been using this software for a couple of years after we faced a lot of issues and freezes in MySQL. This is comparatively much much more smooth and handles multiple DB connections and inter-switching with no lags or hangs.
Inconvénients :
We were more accustomed to the MySQL interface so found a few minor UX improvements that can be done here but overall it's still good.
Alternatives envisagées précédemment :
More powerful than MySQL - but you probably don't need it
Commentaires : I find Postgres to be useful in cases where you want to keep the vast majority of your application logic inside the database itself. Great for data analysis and machine learning applications - not so great for running a web service.
Avantages :
It is more feature rich than MySQL and supports very sophisticated requests. With enough experience, you can write a procedure that can merge and shape any data you could possibly derive from the tables, in any possible format, with little overhead.
Inconvénients :
No powerful GUI tools are available for administration. MySQL is a lot more convenient in day-to-day use thanks to PHPMyAdmin. Setting up and running the database is a bit convoluted as well - doesn't work reliably out of the box.
Alternatives envisagées précédemment :
PostgresSQL Review
Avantages :
PostgreSQL is highly regarded for its robustness, scalability, and reliability, making it the perfect choice for businesses looking for a dependable and secure database. It has a wide array of features such as advanced indexing, support for stored procedures and triggers, as well as a wide array of data types, making it ideal for creating complex applications. It also supports an extensive range of languages and tools, making it easy to use for developers and administrators. Additionally, PostgreSQL has high availability and fault tolerance, making it suitable for mission-critical environments. Furthermore, PostgreSQL can be used in the cloud, making it an ideal solution for businesses looking for a reliable and secure database solution.
Inconvénients :
PostgreSQL can be a challenging platform to learn, especially for beginners. Its steep learning curve, complex structure, and lack of user-friendly documentation make it difficult to get started. Furthermore, troubleshooting and debugging can be difficult, causing even more frustration for those just starting out.
"PostgreSQL: A Robust and Reliable Database Solution"
Commentaires : Overall, my experience with PostgreSQL has been positive. It is a robust and reliable database system with advanced features for data management and analysis. The active community and comprehensive documentation make it easy to get started and the software is well-suited for a wide range of applications.
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.

Alternatives envisagées précédemment :
Solid database that won't break the bank and won't let you down
Commentaires : 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!
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.
PostgreSQL as application database
Commentaires : We use PostgreSQL as our system database for the software we develop, we find it reliable, robust and with great performance, we use both PHP and C++ to access the dataabse.
Avantages :
PostgreSQL is a full featured SQL server solution. it is free and open-source, PostgreSQL can be installed on many different platform like Linux, Windows, macOS and other. being open-source if has lots of contribute tools from the open-source community providing wide range solutions, PostgreSQL is also available in the cloud from all the major providers.
Inconvénients :
Management is less comfortable and some settings needs to be done in PostgreSQL configuration files, also database schema management tool is not so comfortable, but you can use 3rd party tools for that also

PostgreSQL
Commentaires : One of the best open source relational database in the market. Large support of data types make it powerful and lots of storage of less schema data. ACID compliant and lock management support.
Avantages :
PostgreSQL has a wide support of server operating system e.g. windows, UNIX, Solaris, Linux, FreeBSD, Open BSD and OS X. Large support of APIs like ADO.NET, JDBC, ODBC and native C library which makes it easy to connect with any module. Good support of programming languages as well i.e. C, C++, JAVA, .NET, PHP and Python.
Inconvénients :
Wide support from community but some times its difficult to track any issue and get support. Reading speed is bit low as compared to other DBMS. Documentation is only available in English.
Alternatives envisagées précédemment :
Experience with PostgreSQL
Commentaires : We have used the database for the implementation of reporters in most cases, seeking to remove the load from the main database.
Avantages :
It allows me to implement a robust database in a very short time, using a structure very similar to Oracle, in addition to having many tools that allow us to manage the data in the best way.
Inconvénients :
There are functionalities that with third-party products can obtain better results.
The best database offering available
Commentaires : Excellent. The documentation is complete and well-written.
Avantages :
PostgreSQL is standards compliant, performant, high-quality, easy to use, well documented, innovative and feature-complete.
Inconvénients :
Replication still has a way to go compared to some competing offerings, but additional software can be used to fill in the missing features.
Best Relational Database and it's Open Source
Commentaires : I've found PostgreSQL to be a powerfully efficient and secure tool for managing relational databases
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

PostgreSQL is a free and robust relational database management system
Commentaires : With PostgreSQL we can manipulate our databases that contain large volumes of data. The main benefit is that it is completely free. Also, there is no limit amount for users that can be added in the administration of the database. Another benefit is that it is compatible with different programming languages.
Avantages :
I like PostgreSQL for different reasons: - It has flexible implementation options. - Large volume databases can be stored. - It is possible to have multiple databases on a single server and have different configurations for them. - PostgreSQL is completely free. - Its base language is SQL, making it very easy to manipulate. - It has excellent administration toolkits.
Inconvénients :
I dislike PostgreSQL for different reasons: - I don't like that the more detailed documentation is only available in English. - It has a high CPU consumption.
Amaing SQL Dialect and Database
Commentaires : 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.
Avantages :
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.
Inconvénients :
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.

The most advanced open-source database management system
Commentaires : We use PostgreSQL in most of our projects as a primary backend and our experience has been positive.
Avantages :
PostgreSQL is one of the most feature-rich, powerful and advanced open-source database management systems. Though this power comes at a cost. Using PostgreSQL in the best possible way takes some time. PostgreSQL is a real beast and it takes time before one becomes fully familiar with it.
Inconvénients :
Even with all the power that PostgreSQL gives, there are certain things that are missing. For example, until the latest versions there was no support for partitioning. Lack of a great graphic admin tool is a con in my opinion. Yes, it's possible to use (and we do) third party tools like DBeaver but a great database system must simply have its own admin GUI.
Postgress as a relational DBMS.
Avantages :
I have used this several times while I was studying and in my company also. t supports ACID properties and it can handle high traffic. I can use database indexing, different data types. functions, aggregates and complex queries. There's a huge community support and I asked for assistance twice from them.
Inconvénients :
I doubt the performance of this when I handle complex queries.

Best RDBMS
Commentaires : PostgreSQL is my favorite database management system by a long shot. I've professionally used MySQL, Maria DB, MS SQL Server, SQLite, MS Access, and several NoSQL options and Postgres is the best by far. It has a great community around a great product. The official docs are very approachable and I learn new things every time I use it. They built a strong core around consistency and reliability and ever since 9.0 they've made the system really really fast. I can't recommend this software enough!
Avantages :
Very strong consistency and reliability Feature set is growing rapidly Very fast and efficient Very developer friendly Very extensible
Inconvénients :
There are lots and lots of configuration options and the defaults aren't right for modern hardware