PostgreSQL

Avantages

It's a relational database manager system which provide full support for oops and other features to handle your data efficiently.

Inconvénients

It is not user friendly. Queries require more care like need to quotes. Beginners can take time to understand this.

Avantages

It can handle many databases and it is easy to use and has upgraded features

Inconvénients

The app takes a lot of time to open and set up

Avantages

It's open source, great performance, it has a tool easy to use to manage standard sql queries and access to database

Inconvénients

Sintax for some complex queries is not easy, configuration is not easy and installation either but it's not designed for an enduser

Avantages

Great full featured relational DB that offers everything and more than oracle

Inconvénients

Can't run java stored procedures within the DB

Avantages

I love that it's free, I used it for my education for a long time. has a user-friendly interface

Inconvénients

Sometimes data does not return when it should. I thought I was filtering wrong. I run it at least 2 times if there is an empty set output.

Avantages

It is easy to use and integrates with many other software systems. Quick to setup and learn and has good performance.

Inconvénients

If you do not pay for a support package then you are on your own and have to use forums and help manuals to figure things out.

Avantages

PostgreSQL's a great free software and it's very reliable for its features. You can easily manage your data, process them, and so on with efficacity. Plus, it has a great documentation about it.

Inconvénients

The interface is very poor because it's so old. And also, the running performance it's not the best if you compare it with the others softwares on the market.

Avantages

is a basic sgbd, provides everything needed to create and manage a database

Inconvénients

Even though it provides everything you need to build a base and manage it, the interface is pretty basic and not intuitive

Avantages

Ability to handle high rate of transactions, enabling
Handling a lot of data being stored and retrieved in small time.
Ease of migration from an existing database

Inconvénients

We've had a good experience using postgresql however would advise to enhance the debugging features of the database.

Avantages

It's incredibly fast for running queries

Inconvénients

The query language may get a bit confusing, it requires some training. It's not really PostGre's fault though...

Avantages

Quality database management tool with expanding functionality and growing community of users. More functionality than MySQL

Inconvénients

Documentation and/or community user support can be a bit spotty for some issues. Fairly steep learning curve as far as setup. Web interface for pgAdmin can be glitchy/slow.

Avantages

1. The syntax is standard and easy to learn.
2. The response speed of the database manager is always the same regardless of the size of the data.
3. it is multiplatform.
4. It works on different platforms such as Linux, Windows, Unix, Solaris and MacOS X.
5. It has enough storage capacity.

Inconvénients

1. Some experience is required to configure it.
2. It consumes more resources than some database managers.
3. It is not really free as some forums say.

Avantages

Easy to use and install. Similar to many sql queries and New user can become well acquantied with it easily, Open source and stable.

Inconvénients

Slower in insertions and deletions.No offline documentation is available. Some commands interpretations is not very implicit and initutuve.

Avantages

I like that it's very user friendly and easy to poke around for beginners. It's also free, so there's no cost barrier.

Inconvénients

It was difficult for me to install (the process took about an hour), and if you can't remember your master password you have to delete the application and start over.

Avantages

PostgreSQL is a good relational database that supports user defined data types.

Really nice/helpgul to have documentation publicly available

Inconvénients

PostgreSQL is not widely used so it can be very difficult to get community support

Replication is harder than with MySQL

Avantages

Relatively small memory use, good performance and easy to learn and use. Good price for the package.

Inconvénients

The chance to become private like Mysql and others. It can have a better customer support, the server runs on Linux which is not easy for some people.

Avantages

PostgreSQL is a good alternative in the open source database it have options to write functions in Python, Java and C. Inclusive its latest releases it has support for JSON.

Inconvénients

We cannot write our own database engine unlike MySQL, if I don't make this result a lot of errors and it's very very exhausting.

Avantages

it is fast for queries and works better than its counterparts, Have good features to describe indexes and is easy to use.

Inconvénients

The command line is limited and no much gui tool is available to work with it which makes this limited to command line.

Avantages

I like the fact that it's free and open source, fairly easy to use, and not too complicated. It's a nice basic SQL software.

Inconvénients

It seems a bit dated and not as user-friendly as other softwares. The interface and design could use some work.

Avantages

One of the best database management systems. You can easily integrate it and is free to use.
Has all the functionality needed.

Inconvénients

It will take a bit to figure out how to use all the features, could be a bit more user friendly.

Avantages

for backend it is the best software. It have many new features like jsonb that allows the working with json objects very comfortable.

Inconvénients

This tool is simple ans easy to use but lacks the gui and is purely command based. user have to write everything agin and again and have no data persistence queruies capability

Avantages

Fast, extremely scalable, in active development, complies with SQL standards, and can handle large GIS data sets with PostGIS.

Inconvénients

Upgrading minor versions is sometimes a pain with the PostGIS extension. We occasionally have to dump and reload the entire database to get things working without losing data.

Avantages

I really like this database manager because it is easy to use, its graphical interface is comfortable, also the commands through the console are very friendly.

Inconvénients

Sometimes the way to search files through the console is annoying, the version of pgadmin 4 is unstable.

Avantages

This tool is very easy to use. Whether a search query, data access, join and similar operations can be performed with ease using this tool. This is must have tool while working on a project that requires database backend connectivity.

Inconvénients

i face connectivity errors and issue most of the time while working with postgresql but online help is available most of the time.

Avantages

easy to connect with our in-house apps that are used for minor tasks.

Inconvénients

Overall a great product, a slight learning curve compared to other SQL programs.

Avantages

In this database every thing is easy to use it and learn it very fast I

Inconvénients

I think every thing in this program is very well working

Avantages

This is good for well standarised implemenetation of sql queries. Even complex datatypes like jsona nd arrays can also be provided

Inconvénients

Installation is not easy process. Cluster is not present. Slow operations like count(),sum() become main concern is reliability inspite of speed.

Avantages

Open source and absolutely loaded with helpful tools. It's also been around forever so you know it's reliable.

Inconvénients

Can be harder to learn when compared to other systems. I wouldn't give this to a beginner.

Avantages

The best and most modern database on the market

Inconvénients

Not the easiest to integrate into frameworks

Avantages

A strong and powerful alternative to many other popular DB's.

Avantages

I can say that it's really hard to go wrong in recommending PostgreSQL to anyone with even a small amount of technical knowledge.

Inconvénients

I think it's not easy to understand how to do database backups and for that reason i don't like do it

Avantages

It experience very few database crashes. Postgresql have a very basic user interface and is very robust. It generally supports all platforms like windows, linux etc. Also it have large storage space.

Inconvénients

Their customer support is of not great help. It use large number of resources and performance is bad as compared to its alternatives. Also it does not scale well.

Avantages

I was a new user of this software. It was easy to understand the functionality.

Inconvénients

Sometimes software used to hang while processing query with large number of data.

Avantages

It has a very large community so online help is available if we are stuck anywhere. It is simple command based and works fine for beginners. It is password protected so security is great.

Inconvénients

It is slow for large dataset and commandline is everything. No great GUI. Only GUI is pgadmin which is complex to configure.

Avantages

1) Relational database works on structured data (uses SQL queries)
2) Support ACID properties.
3) Support traditional Joins.

Inconvénients

1) Does not provide NoSQL functionalities.
2) Query having regular expressions are somewhat partially existing i.e not able to access nested queries having dynamic parent attributes.

Avantages

It has very rich library of commands and also json support. Firing queries is very easy and anyone with basic knowledge can get started to work on it.

Inconvénients

No major disadvantage but sharding is difficult with postgresql.

Avantages

It is easy to use and it has a user friendly interface. It is intuitive and it works well. The language adapts to to SQL perfectly.

Inconvénients

Looking for the tables requires many clicks, you have to open the database and scroll through various values, but it's definitely not a real issue.