PostgreSQL
Description de PostgreSQL
Système de base de données post-relationnelle open source gratuit qui s'exécute sur l'ensemble des principaux systèmes d'exploitation. Fort de 25 années de développement, PostgreSQL fournit une vaste gamme de fonctionnalités pour les développeurs et les administrateurs de bases de données réunies dans un serveur logiciel robuste utilisé dans le monde entier. PostgreSQL est considérée comme l'une des cinq meilleures bases de données par DBEngine, surclassant ainsi la plupart des systèmes dans le commerce. Avec des millions de déploiements dans des systèmes intégrés et des installations chez les plus grands fournisseurs de cloud et sur des sites majeurs, PostgreSQL constitue le choix le plus populaire pour le développement de nouvelles applications.
Qui utilise PostgreSQL ?
Tous les secteurs d'activité, tous les domaines et tous les pays.
PostgreSQL ne vous convainc pas tout à fait ?
Comparer avec une alternative populaire
PostgreSQL
Alternatives à PostgreSQL
Avis sur PostgreSQL
Janne
Alternatives envisagées :
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.
Utilisateur vérifié
Alternatives envisagées :
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.
Joseph
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.
Ana
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.
Eutimio
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.
