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

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 

Pourquoi choisir PostgreSQL 

Pourquoi passer à PostgreSQL

Avantages

its compatibility with previous versions makes development very friendly.
It is also Open source and free, which allows saving costs in the development of systems.
there is a lot of documentation online to find solutions to problems In addition to having a large community

Inconvénients

It's official handler is not friendly.
Installation for begginners is not easy.
configure advanced functions such as replication It is complicated

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

Excellent database manager, it has its own program (phAdmin) that gives you a very friendly graphical interface to carry out all kinds of tasks. Postgress is highly scalable and stable, which is why I prefer it over other options

Inconvénients

As against, when the database that is handled is relatively small, when comparing response speeds with other engines, it has a small disadvantage, but its great advantage is noted by having a large database.

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.

Alternatives envisagées 

Pourquoi choisir PostgreSQL 

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.

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

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

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

Easy to setup development wise (Postgres.app), Very well supported by primsa DB. (orm client).

Inconvénients

Cloud pricing tend to be more expensive vs mysql option.

Alternatives envisagées 

Pourquoi passer à PostgreSQL

Avantages

Security is very important in IoT. PostgreSQL offers robust security features such as SSL encryption and row-level access controls, ensuring that data is kept safe and secure. PostgreSQL is highly scalable and can handle large volumes of data, making it ideal for IoT applications that generate huge amounts of data.

Inconvénients

PostgreSQL has a steep learning curve compared to other databases. Its advanced features and complex commands can be overwhelming for new users. While there is a large community of PostgreSQL users, finding professional support can be challenging, especially for companies with specific needs.

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

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

ACID compliantRobust and secureAllows different transaction types to co-existAsynchronous and synchronous replicationScalable

Inconvénients

Use this for your mid to large-tier projects.

Avantages

Transactional features haves distinguished PostgreSQL from MySQL in the past and was our choice every ti e we need it. It is still very strong, with support for clustering.

Inconvénients

unfortunately it has been surpassed by MariaDB in all areas in my opinion, and it rests only as a second choice if, by any reason, you can’t use MariaDB.

Alternatives envisagées 

Avantages

The community is one of the main aspects that make postgreSQL so attractive, with its open source DBMS and the ability to participate.

Inconvénients

While it's a great alternative and easy to use, it may not offer the fastest speed. If you need efficiency you may need to look somewhere else.

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.

Avantages

The biggest benefits PostgreSQL databases offer are in my opinion that they are super reliable, performant, open-source and are working with common SQL standards.

Inconvénients

If you are really honest, compared to some other alternatives, PostgreSQL databases have a low reading speed.

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

+ Install is very easy
+ Support almost all platform
+ Data aggregation is fast
+ Good documentation from vendor and community
+ Highly stable
+ Secured

Inconvénients

+ Working with JSON etc. is not easy comparable to other products
+ Poor data compression mechanisms
+ Bit resource hungry

Alternatives envisagées 

Pourquoi passer à PostgreSQL

Avantages

+ scalability
+ SQL compilant
+ security
+ open source (free but not without costs)
+ offers more field types than mysql
+ API compatibility
+ low TCO - cheaper than Oracle (but with similar performance)
+ great programming language support (Python, PHP, C++ etc)

Inconvénients

- free (open source) does not mean witout costs. Sometimes it is very hard to find a specialist that can properly handle PG issues
- not present at most of hosting services (but you can always run a virtual machine on AWS EC2)
- less tools for data manipulation/analysis compared to MySQL