PostgreSQL is undoubtedly one of the most well-known and used database servers.
OPEN SOURCE
One of the main reasons for using PostgreSQL is that it is developed under open source (Open Source), we can find it available on its official website and download it without any cost. also has a MULTIPLATAFORMA
If we require a database to work on our project, the most common is that we ask what database to use that gives us performance, security and in turn we can use it both in the office and outside of it, and one of the Most common cases is that we do not all have the same operating system. And here is another reason to use PostgreSQL: we will not have to worry about this detail anymore, because it is available in virtually all versions of Unix operating systems and also for Windows, giving us the opportunity to have it installed locally, make a remote connection to through your PgAdmin administrator or also from the application you are developing. Review collected by and hosted on G2.com.
This compared to MySQL is slower in insertions and updates, since it has intersection headers that do not have MySQL.
Online support: There are official forums, but there is no mandatory help.
It consumes more resources than MySQL.
The sintaxtis of some of its commands or statements is not intuitive at all.
These are some of the annoying things about PostgreSQL. Review collected by and hosted on G2.com.
Easy of use - tons of community guidelines and stack overflow users have solved most of the problems Review collected by and hosted on G2.com.
We went for the paid version but is pricey but thats just one part - the postgres DB actually wants you to learn their own syntax which takes time of you are new Review collected by and hosted on G2.com.
is a computer tool that you can obtain free downloading from your website, easy to install both in private operating systems and open source and this allows you to create a database with different parameters and tables that will make your database fast and secure too has the advantage of working with different types of files for the storage of information so that when consulting tables is faster has an option called triggers that allows to automate statements in the database to perform execute command so automatic. Review collected by and hosted on G2.com.
It is usually difficult to install linux operating system since it must be installed manually using the command console and indicate in which sites the installer file is located, it also tends to be flawed when it has multiple databases or when a database It is very small since it is indicated and developed for a large data base. Review collected by and hosted on G2.com.
It is a super fast tool and the best of all for free to manage database of large volume or size; it is compactible for both windows and other operating systems. Its configuration is easy and its functionality is surprising since it allows you to manage a database of data that contains multiple tables in a fast and secure way to access the information asks you to log in and has an endless file format to save the information. Review collected by and hosted on G2.com.
in database that are not large, or it is usually slow search or may even fail, you need some plugins or components to integrate with other software which makes it a bit difficult to configure. Review collected by and hosted on G2.com.
It does stored procedures, indexes, benchmarks are excellent, its FREE. Does multiple languages in Unicode, stores objects. Review collected by and hosted on G2.com.
The only free tool is pgadmin and its good but you have to pay to get a good database admin tool. Review collected by and hosted on G2.com.
This management system offers performance characteristics that have evolved over time. Also its use and constant review of the developer community have made it one of the most stable systems in terms of open source refers to. The graphical environment offered by Pgadmin allows an intuitive and easy to manage administration. If you have used other database administration systems, the adaptation to Postgre SQL will be very fast and little traumatic. The SQL statement editor is very practical, which allows to perform the operations most commonly used in any database. Finally, the backups and recovery of databases are carried out quickly and in a few steps. The reliability of this function is very high. Particularly, during the time I have been using this manager I have not presented any type of error or catastrophic loss Review collected by and hosted on G2.com.
The main hosting providers do not support database of this management system. The big corporations still have resistance for the use of this manager. The support is provided by the developer community, which produces long periods of time to resolve. It does not have an error identification and traceability mechanism. Review collected by and hosted on G2.com.
Licensing model is very flexible. Database can be embedded as part of an application or installed separately. Review collected by and hosted on G2.com.
GUI UI isn't the best. PGAdmin is a local application that is installed as a web based application. It can be flakey to get running. Review collected by and hosted on G2.com.
PostgreSQL is one of the best options to work with relational databases. Having worked a lot with databases and having the experience to work with PostgreSQL made me realize how this is one of the most solid options for working on this area. It's the best open source for SQL and possibly the best among all, either open source or no.
PostgreSQL provides you with high performance and solid robustness. It's easy to import, export, and deploy databases. Review collected by and hosted on G2.com.
The PGAdmin could be improved. While it's a functional inteface, it could be improved and made faster and easier to use. Review collected by and hosted on G2.com.
It is totally free, it is open source, it integrates with many database managers, it has many functionalities, inheritance of tables, several views, transactional integrity Review collected by and hosted on G2.com.
rigorous security and authentication mechanisms must be applied to avoid any vulnerability in the system Review collected by and hosted on G2.com.
PostgreSQL is fast and available with very small latencies on most clouds. I believe it's a SQL taste, particularly compatible with my coding style and a straightforward natural query interface. It operates robustly and can be easily distributed without crashing. Review collected by and hosted on G2.com.
Postgres is perfect to say it has no flaws and we can't ask for Oracle's scope or features because, as a consequence, this instrument is safe. However, for example, the other tools aren't the only ones I saw and don't like. Review collected by and hosted on G2.com.