Introducing G2.ai, the future of software buying.Try now
PostgreSQL
Save to My Lists
Claimed
Claimed

Top Rated PostgreSQL Alternatives

MySQL
(1,636)
4.4 out of 5

PostgreSQL Reviews & Product Details - Page 22

PostgreSQL Overview

What is PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL Details
Show LessShow More
Product Description

PostgreSQL is a powerful, open source object-relational database system.


Seller

PostgreSQL

Description

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:
008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

Overview Provided by:
CTO at Coronys LTD.

PostgreSQL Integrations

(3)
Integration information sourced from real user reviews.

Recent PostgreSQL Reviews

Biruk T.
BT
Biruk T.Mid-Market (51-1000 emp.)
5.0 out of 5
"Robust PostgreSQL support with enterprise grade features"
EDB provides a reliable PostgreSQL experience with extended enterprise tools like EDB Postgres Advanced Server. I specially appreciated the integra...
Verified User
U
Verified UserSmall-Business (50 or fewer emp.)
5.0 out of 5
"PostgreSQL:"
Strong support for advanced indexing techniques like BRIN, GIN, and GiST, which optimize query performance for large datasets. Plus, its built-in J...
saif eddine m.
SM
saif eddine m.Enterprise (> 1000 emp.)
5.0 out of 5
"My Experience With PostgreSQL"
What i like most about PostgreSQL is the ergonomic interface , easy to understand .

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
View More Pricing Information

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Answer a few questions to help the PostgreSQL community
Have you used PostgreSQL before?
Yes

637 PostgreSQL Reviews

The next elements are filters and will change the displayed results once they are selected.
Search reviews
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
637 PostgreSQL Reviews
4.4 out of 5
637 PostgreSQL Reviews
4.4 out of 5

PostgreSQL Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons
G2 reviews are authentic and verified.
Verified User in Automotive
CA
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Seller invite
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

Highly recommend but you need to learn the language Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We replaced it from IBM db2 and it seems like It connects with many applications easily. We are using it to integrate with in house python applications and works perfect. However we haven’t actually signed off with this application officially but it is under due consideration Review collected by and hosted on G2.com.

Lopata C.
LC
Project Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

is a very useful tool and its advantage is that totally free that will work to manage database of great information for systems in both web development environment and desktop environment as they are developed in java is light when installing and you do not need more resources for its execution, however, the system usually becomes a bit heavy depending on the number of information it manages and the way in which it is managed correctly. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I worked to use this database with the system and extensive information that our client needs and are developed in turn is implemented and integrated with several tools for developing programs such as netbeans and eclipse. Review collected by and hosted on G2.com.

David C J.
DJ
Computer Engineering
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

I recommend this database administrator for its quick way of installation and configuration in turn for the way to administer the tables and database because it allows to interlace tables and have a better response quickly and without any error. It works both for proprietary operating systems or open source, and you do not need to have a large computer to use this tool because it does not consume much requirements. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

We have served to make and safeguard our information in a safe manner and with multiple forms of protection. This tool also allows us to encrypt our information in case any person wishes to access it, it can not be achieved. its installation is totally free and compactible for java and php application development. Review collected by and hosted on G2.com.

Nigel H.
NH
Technical Architect/Manager
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

Its fast and very well done. We have 1500 clients with thousands of patients and it works fine. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

sometimes you have to write a query in a special way so that Postgresql is efficient at processing the sql correctly. Review collected by and hosted on G2.com.

Michell R.
MR
Gerente de Proyectos
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
Rating Updated ()
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

Free technologies are not necessarily unstable. If you require a database management system with good security features, information integrity for a medium volume of transactions, try PostgreSQL Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

In countries where the use of free technologies is encouraged, great benefits can be obtained because there are no additional payments for user licenses and the client owns the generated code, which allows its administration and modification without inconvenience. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
AI
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

Recommendations to others considering PostgreSQL:

Understand use of database to allow power to assist your implementation Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Storage of both discrete and nondiscrete data in a single database. The flexibility allows for implementation of many use cases including dynamic types. Review collected by and hosted on G2.com.

Román Josué d.
RD
Data Scientist
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What problems is PostgreSQL solving and how is that benefiting you?

PostgreSQL not only improves your experience with working on SQL, but boost your database development and management. Review collected by and hosted on G2.com.

MB
Developer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

rigorous security and authentication mechanisms must be applied to avoid any vulnerability in the system Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Take courses, read, there is a lot of information on the web very useful, to be good professionals and in the case of companies have highly trained staff Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

Database management, integration with information systems, handling high transaction volumes Review collected by and hosted on G2.com.

Abdul Basit Z.
AZ
Geographic Information System Officer
Information Technology and Services
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about PostgreSQL?

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.

What do you dislike about PostgreSQL?

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.

What problems is PostgreSQL solving and how is that benefiting you?

From our experience, we had to question the introduction of several tables and use one of the Database Supervisor's characteristics to present important company information. Review collected by and hosted on G2.com.

SW
Software Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about PostgreSQL?

PostgreSQL is one of the best choice when it comes to managing relational databases and it is available to use for free! It provides an ease of use to its users. It allows developers the freedom of using many languages eg. Python for scripting. It works well with large amount of data too. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Processing big data is need of the day and very much required in all businesses. Even though postgreSQL can support large databases, It is not suitable for big data due to large computation time. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

A very useful application to manage databases. Available for free along with good support. Review collected by and hosted on G2.com.

What problems is PostgreSQL solving and how is that benefiting you?

I use postgreSQL to manage out employee and project databases. Its ease of use the fact that it is available for free make it possible for us to use it for small scale businesses and needs. Review collected by and hosted on G2.com.