PostgreSQL

Excellent SGBDR gratuit

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à.

Sql managment for everyone

Commentaires : I have used postgresql to create difficult subqueries, the implementation is easy and scalability is a game changer.

Avantages :

subqueries and json native compatibility is a game changer

Inconvénients :

It uses more resources than other Sql Managers and it´s difficult to undertant the unique features when I started using it.

My Go-To RDBMS

Avantages :

It is fast, reliable and scalable; the perfect RDBMS in my humble opinion.

Inconvénients :

The learning curve, but even that wasn't actually so bad.

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.

Reliable and Helpful

Commentaires : Really helpful, easy to jump into and start practicing with.

Avantages :

Multiple different ways to view and find data.

Inconvénients :

The diagram feature isn't as customizable as I would prefer.

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 Review

Commentaires : I highly recommend PostgreSQL, i have been using it at work and at the university

Avantages :

First, it is open source and wildly used database, it is customizable and scalable

Inconvénients :

It does not contain a customer service because it is open source but of course you can find ur answers on the internet and platforms

PostgreSQL for Database

Avantages :

PostgreSQL is one of the most popular choice for Database now and it becomes more popular as many people and companies starting to use it. PostgreSQL has great features and performances, so I'd like to recommend PostgreSQL to those who needs a reliable RDBMS.

Inconvénients :

One thing that i dislike from PostgreSQL is it's hard to setup and install PostgreSQL at the beginning. Especially the syntax and command that PostgreSQL use.

Reliable and performant RDBMS

Avantages :

Much better performance and consistency vs other RDBMS, eg MySQL. It doesn't hide the complexity beyond being a DBA, which is kind of a double edged sword.

Inconvénients :

Manual intervention needed for version upgrades, but nothing terrible.

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.

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.

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.

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.

Very good for solid DB

Avantages :

I like it and use it together with CMD commands.

Inconvénients :

I don't really like the fact that the UI/UX is not super great.

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

PostgreSQL Review

Avantages :

PostgreSQL is an excellent choice for working with relational databases. After extensive experience with databases, I found that PostgreSQL is one of the most reliable options. It is the preeminent open source SQL system and potentially the best of all, open source or not. PostgreSQL offers both remarkable performance and dependability.

Inconvénients :

The SQL syntax for Postgresql was slightly different than what I was used to.

PostgreSQL Review

Avantages :

+ Free and open-source+ High availability and consistent performance.+ High scalability

Inconvénients :

- Commercial support- Backup and recovery process can be more complex than other RDBMS

Use PostgreSQL when SQL is the choice of Database query language

Avantages :

PostgreSQL a very large community support as it is opensource. Also support to multiple languages like JAVA, Python means it has lesser start up time for all kinds of developers like Backend, Frontend, Machine Learning etc.

Inconvénients :

Sometime when we use bulk mutation queries when updating database, search query latencies will increase. It needs to have separate thread pools.

World class DB management and Open Source tool

Commentaires : Flexible, robust with advanced features. Complex DB dashboard.

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.

It's free!

Commentaires : 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

Avantages :

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

Inconvénients :

- 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

Database Manager PostgreSQL

Commentaires : In my experience using the software I really liked that it allows adding custom functions developed using different programming languages.
The integrity of the data and the referential integrity of the foreign key are maintained. It has allowed me, in an easy and secure way, the asynchronous replication of the databases for an alternative center in case of disasters. I did not like it is that when I have any doubt about an error presented in the system where the database is working, I can not clarify it because there is no specific place to which, because and com solve the error.

Avantages :

PostgreSQL allows to control high concurrency, offering security by domain definitions, who can access the database server, the backup copies of the database can be made completely or only a table, according to the request, restorations and tasks maintenance, in addition to replicate in case of disasters. It also allows to activate triggers to execute in tables or views in special cases or eventualities. It has a friendly graphical interface for the administrator, through which they can be done from the creation of the database, to execute query querys and updates of the data, if necessary, you can have details with the status tool of the server referring to the queries that are executed in the DB (if there are locks, duration, etc.). It allows the development of robust and efficient Databases

Inconvénients :

There is no online or telephone support. Only official forums are available where users expose their doubts that other users of the community respond to, ademas it consumes many resources

One of the best database managers for the world.

Commentaires : 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.

Avantages :

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.

Inconvénients :

- 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

Excellent alternative to MySQL when you need more flexibility

Commentaires : I needed a very efficient database that could handle a huge amount of records, views and access for a data-scraping and analysis project. I was able to very easily do this with a combination of python for data processing, tableau for visualization and postgre-sql for the database. It has been running for a few years without any hiccups and with great efficiency.

Avantages :

User management is very flexible and the query language support many things that MySQL does not out-of-the-box, more inline with oracle database.

Inconvénients :

Not as ubiquitous as MySQL so initial setup and admin is slightly more complicated.

The best RDBMS of 21st century

Commentaires : postgresql is something i use 80% of the day.
The features i have used on same are helped me a lot in terms to develop existing db activities.
The parallel query execution and operations facility is the best thing i love in postgre.

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.