PostgreSQL - Avis

exellent

Avantages :

c'est un SGBD très polyvalent qui peut sur certains points comme la vitesse battre certains concurrents sur le marché des systèmes de gestion de base de données

Inconvénients :

La configuration est vraiment difficile, il faut vraiment un sport intellectuel pour pouvoir paramétrer cet outil.

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.

Very complete and stable database

Commentaires : I have very good experience installing and configuring databases with PostgreSQL.
Once installed and configured it is very stable, almost without errors and one can rest assured that the data is fine

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

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.

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.

The most advanced open-source relational database management system

Commentaires : For my internship, I worked on the development of a scholarship management system for our university. The system was designed to streamline the scholarship application process and provide students with a more efficient way to apply for financial assistance. The system was implemented using PostgreSQL, which allowed us to store and manage large amounts of data effectively.

Avantages :

PostgreSQL is one of the most advanced open source relational databases, which makes it popular among software developers. It offers advanced features such as ACID transactions, triggers, stored procedures, and custom data types. It is also highly scalable and can be used for small or large projects. PostgreSQL has an active community of developers working on its improvement every day.

Inconvénients :

PostgreSQL's learning curve can be a bit steep for those who are unfamiliar with databases. Also, it may be slower in some operations than other databases, which can affect performance on high-demand projects. PostgreSQL is an open source database, but some advanced features require paid plugins or add-ons.

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.

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.

Agrxis Review on PostgreSQL

Commentaires : I can state with confidence that PostgreSQL has exceeded my expectations as a database management system based on my whole experience with it. I strongly rely on PostgreSQL as a data-driven professional to store, retrieve, and analyze massive volumes of data. PostgreSQL's adaptability and scalability have been crucial in meeting our expanding data demands. The knowledge that our important information is safe thanks to the secure data storage capabilities gives us piece of mind. Additionally, we have avoided possible data loss situations thanks to the backup and recovery tools. One of PostgreSQL's unique advantages is its support for several programming languages, which has enabled us to collaborate easily with other development frameworks. The query performance was identified and optimized with the use of the performance analysis tools, resulting in effective data retrieval. The ability to import and export data has also made it simple to move data between platforms. Overall, PostgreSQL has exceeded my expectations, and I heartily endorse it to anybody looking for a solid and dependable database management system.

Avantages :

In my experience with PostgreSQL, its adaptability and dependability as a database management system were its strongest points. I like PostgreSQL's broad range of features and capabilities as a data specialist. In order to satisfy the various data requirements of our firm, it has been essential to be able to manage enormous datasets, conduct sophisticated queries, and support advanced data types. The versatility it offers with its support for several programming languages, which enables us to smoothly incorporate PostgreSQL into our current tech stack, is something I personally enjoy. The performance analysis tools have been crucial in improving query execution and system performance as a whole.

Inconvénients :

My least favorite aspect about PostgreSQL was the steep learning curve and complexity involved in setting it up and configuring it. I haven't used database management systems for very long, so navigating PostgreSQL's installation and configuration options proved to be a challenge. I had to spend more time and effort learning the many PostgreSQL-specific concepts and settings.

An Overview of PostgreSQL

Commentaires : I can't deny, PostgreSQL really requires a lot of technical knowledge and expertise. I had a hard time familiarizing myself. Up until now, I still have some learning to do. However, it's the best relational database management system I have come across.

Avantages :

The following are some of PostgreSQL's key benefits: Scalability and performance enhancements, Extensibility and Customizability, Advanced SQL capabilities, and Support for Multiple Programming Languages. Particularly for developers who are already familiar with SQL, PostgreSQL is widely regarded as being user-friendly and simple to use. It has a sizable community for assistance and abundant documentation. Its support for many programming languages, open APIs, and available connections for different frameworks and tools make integration with other systems easier.

Inconvénients :

Users who are not familiar with relational databases or SQL may find the learning curve to be extremely steep. Furthermore, clustering and replication setup and management might be difficult. Last but not least, compared to certain commercial database systems, it provides less GUI tools which makes it more complicated to use

Powerful and Reliable

Avantages :

One of the best pros that made me switch to postgres was the performance, it has an excellent performance for complex queries and has support advanced indexing techniques. As well as the extensibility, reliability and being open source of course.

Inconvénients :

Lack of built-in sharding,n PostgreSQL does not have built-in sharding capabilities, which may make it more challenging to scale out horizontally across multiple servers.

Java developer on PostgreSQL. A look back after several years.

Commentaires : I have been using PostgreSQL for 6 years in most of the applications I write. It is my default choice for a relational database.

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.

Postgre SQL.. Best 2D spatial database tool for geologists.

Commentaires : It's a pretty reliable database manager that provides for excellent data management and a very comprehensive security implementation, as well as the installation of procedures that make data integrity easy to maintain.

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.

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.

Perfect open source relational DB

Commentaires : Overall experience with PostgreSQL is great and it had very little learning curve in moving away from other proprietary DBs.

Avantages :

This is perfect replacement for any proprietary relational data bases as it provides most of the features from traditional relational DBs. It helps us in data storage and retrieval with good level of flexibility and performance.

Inconvénients :

Not much as this is used as free or opensource alternative the performance matches very closely to it's paid competitors. Adding in more GUI support tools could be helpful.

PostgreSQL is powerful and robust, it fits perfectly in large projects

Commentaires : With PostgreSQL I have been able to perform my work satisfactorily on multiple occasions, my bosses and I are happy with the results we have obtained, saving hardware investment costs because we have focused on the database, I hope to have future benefits to the use it in projects for own clients.

Avantages :

I really like PostgreSQL I have used it several times for large projects in my previous works and in the current one it is used as a database for the web page of the institution, the power of PL / pgSQL is excellent, it allows me to program commercial layers in the database without any problem this improves the response times of the final applications and allows investments in hardware in the database servers instead of in the application, the management of schemes is perfect. It is important to mention that it is free software that implies having a large database without licensing costs. A feature of PostgreSQL is the multiversion concurrency control that allows transactions consistent with time, which provides great performance advantages. PgAdmin is a graphical tool with which I can manage different databases easily and intuitively, execute SQL statements, as well as create backup copies or perform maintenance tasks. Another thing that I like about PostgreSQL is that it is available for many platforms, it is possible to install it from the repositories of the Linux version that I use. It should be noted that the PostgreSQL user community is one of the most active in the market

Inconvénients :

There are some things that I do not like about PostgreSQL, permissions allowance per user can be annoying, I have had to work many times on this and it is difficult, it is also relatively slow when I insert and update small databases. The official support does not have telephone or online support, although there are official forums available where users can express their doubts to which other users of the community respond. The syntax of some of your commands or statements may not be intuitive if you do not have a medium level of knowledge in the SQL language. I have had problems migrating from a PostgreSQL version to a higher one. Compatibility is sometimes relative.

Good tools for Databases Management

Avantages :

I like the fact that PostgreSQL is an open source relational database management system. This means that it is free to use and the source code is available for anyone to modify and customize. It also has a large community of developers and users who are willing to help out with any problems or questions that may arise. Additionally, PostgreSQL is extremely reliable and secure. It offers a wide array of features, including support for many languages, robust transaction processing capabilities, and scalability. It also offers a wide range of tools for managing, tuning, and monitoring databases.

Inconvénients :

It can be difficult to use and maintain. One of the biggest issues with PostgreSQL is that it is not as user friendly as other relational databases such as MySQL. It can be difficult for inexperienced users to learn and use the more complex features of PostgreSQL.

Great, yet not perfect Rdbms

Commentaires : I will use it as long it is the best in the marke

Avantages :

It supports a wide range of data types, which makes it a great candidate.

Inconvénients :

complex to set up and configure, especially for those new to RDBMS

Review Of PostgreSQL

Commentaires : Overall PostgreSQL best in Market. They have better support and help their customers.

Avantages :

The PostgreSQL is best and most powerful RDBMS software in opensource platform. This PostgreSQL better in Data Storage, Data Dedupilication and Data Replication.

Inconvénients :

The PostgreSQL need some of security loop holes .

Best Open Source RDBMS by far

Commentaires : I am a web developer and geospatial analyst. I am using PostgreSQL daily to store spatial datasets using PostGIS, its powerful spatial extension

Avantages :

PostgreSQL has been on my tech stack since 2006. It is an impressive open source software, really reliable. I love its PostGIS spatial module, which enables powerful geospatial functions.

Inconvénients :

I like everything and I can't think of something which I don't like. This is by far the best open source RDBMS

Object-relational open source database

Commentaires : We use PostgreSQL mainly for heavy load projects because to high write performance due to its MVCC approach, it largely eliminates the need for locking, and that the database effectively meets ACID principles.

Avantages :

Supports functions where the results are suitable for use as with tables. We can define own aggregate and window functions on that. Includes built-in support for B + tree, hash, GiST, GiN and custom index types. Support access using a system known as Multi-Version Concurrency Control (MVCC). Native support for many data types including XML support for Xpath queries or UUID. User defined objects, posibility to create new types of almost all objects in the database.

Inconvénients :

Possible worse performance in read operation.

Managing DB with PostgreSQL works fine.

Commentaires : PostgreSQL can process complex queries in relatively less time, and data can be accessed seemingly faster with non-key attributes. Since we deployed PostgreSQL at work we are delighted to see its flexibility and the better performance for our most common use cases.

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.

Best Database Management System with wide range of Features

Avantages :

PostgreSQL is one of the best from the range of DBMS i used in my career. Features like Stored Procedures is one of the reason i prefer this tool. It helps me take off a huge amount of workload from the API server as same data need to format differently for different APIs. Along with it the availability of builtin functions like JSON functions, Regex Functions etc helps a lot in the data processing field. Connectors support for various languages is one of the main reason for using this tool. Connection Pooling helps me execute multiple queries without slowing the system and losing any data.

Inconvénients :

It is not suitable for beginners. Designing a efficient and effective Database workflow need a skilled DB Admin so a beginner need some time to get to familiar with the system. Another drawback is its management tool pgAdmin 4. Its a disaster compare to pgAdmin 3. It is a web App and lags a lot. I face problems in multitasking in version 4 that is not the case with version 3. I Hope someday somebody provide backward compatibility of PostgreSQL 10+ with pgAdmin 3.

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.

Best open source database for enterprises

Commentaires : We use PostgreSQL as RDMS for our custom made solution for customers\projects without dedicated enterprise RDMS.

Avantages :

It supports advanced database features like partiotions, scalability, optimized concurrency management, security. It is offered under MIT-style license.

Inconvénients :

It is difficult to troubleshoot PostgreSQL. Not as widely used as My SQL for example, not as active community