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 21

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

PostgreSQL Media

PostgreSQL Demo - PostgreSQL
PostgreSQL
Product Avatar Image

Have you used PostgreSQL before?

Answer a few questions to help the PostgreSQL community

638 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.
638 PostgreSQL Reviews
4.4 out of 5
638 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.
NK
I am a Sr. Software Engineer, 5 years of experience in development, use "whereby app" formely known as "Appear" very frequently for solving some of the issues by sharing with peers screen online.
Small-Business (50 or fewer emp.)
"Free and Open Source Database PostgreSQL with multi version concurrency control"
What do you like best about PostgreSQL?

It is a open source, it supports different language within postgres like pgplsql and python and other many more languages it is compatible with.Supports JSON allows linking with other data sources .

Supports multi version concurrency. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

It does not have sorting on click of column while resulting a query through PgAdmin interface.

Can't switch through different tabs of query tool using (alt+ tab), which result in force user to use mouse for switching. Review collected by and hosted on G2.com.

SP
Sachin Patel
Small-Business (50 or fewer emp.)
"object-relational database"
What do you like best about PostgreSQL?

Large volume data securely store using PostgreSQL. In PostgreSQL base language is SQL. SQL is very simple and we can manipulate and generate information. PostgreSQL install in window as well as Linux. I use PostgreSQL in my rails project. Documentation of PostgreSQL easily available on internet so we can easily learn about PostgreSQL. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

I don't find any dislike in PostgreSQL. PostgreSQL is easy to use and query easily understand. Review collected by and hosted on G2.com.

MG
Engineer
Mid-Market (51-1000 emp.)
"PostgreSQL"
What do you like best about PostgreSQL?

Postgres has an excellent community that contributes constantly in this development, postgre is updated constantly. PostgreSQL is an excellent tool to carry out developments and volumes of data. This is a database that serves applications perfectly, behaves very quickly, safely and reliably, has modules for the recovery of information and points of recovery from the disaster, is currently in version 11 Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Postgres is perfect to tell the truth, it has no flaws and we can not demand that it has the scope or functions of Oracle, although it has nothing to envy, postgres without a doubt is the best option Review collected by and hosted on G2.com.

joseangel a.
JA
Ingeniería informática
Enterprise (> 1000 emp.)
"database manager more updated with open source and characterized by being robust in the market."
What do you like best about PostgreSQL?

This database manager called PostgreSQL is the database engine of today. with great features that will allow you to handle large volumes of information, which makes it the most powerful and robust Free Code Database Management System on the market. this manager infinitely type of fields, works with the technology of triggers sentences. allows you to perform backup and restoration of the database by tables or complete. and it is compactible with a variety of operating systems including windows and linux. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

a great disadvantage for us users of this platform is that postgresql is slow when inserting data or updating information in very small databases, since this has been designed with the ability to handle large and inferior volumes is often complex use for small systems. This tool despite being one of the most robust in the market has a deficit in terms of technical support we refer, because at the time of presenting errors this tool we only have support group forums with people who use and have solved said problem. Review collected by and hosted on G2.com.

Yoceliz A.
YA
Analista de datos en T-Systems Iberia
Enterprise (> 1000 emp.)
"Relational database manager system, is object oriented."
What do you like best about PostgreSQL?

is a database manager that offers us more than creating database is oriented to objects, that is, all the elements of our database will be able to be treated as objects, something similar to a programming language. in the same way it can be said that it is multisystem, therefore PostgreSQL can be installed in Microsoft Windows, GNU / Linux, MacOS, BSD and many other operating systems.

PostgreSQL is scalable and can handle huge databases, of more than 100 Terabytes and it works under a free license, we can use it for any purpose without any problem. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL is slower when it comes to insertions and updates, similarly the response it offers when the databases are small may seem a little deficient, compared with MySQL consumes more resources, also some commands and syntax are not intuitive. Review collected by and hosted on G2.com.

Vasu G.
VG
R&D Engineer
Information Technology and Services
Enterprise (> 1000 emp.)
"Best opensource database "
What do you like best about PostgreSQL?

PostgreSQL supports json data and transaction control that helps in development of modern complex web apps. Also, pgadmin built in support for dump backup is an important feature for critical applications. PgAdmin is good tool for managing and viewing database data along with support for complex SQL queries. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The PostgreSQL has some rigid migration rules while updating the database that can cause data loss Review collected by and hosted on G2.com.

GC
postgres database engine
Mid-Market (51-1000 emp.)
"postgres database engine"
What do you like best about PostgreSQL?

for me the best of PostgresSQL and what I like most is that it is multiplatform, this helps me a lot with the work that I have to use both free software and Windows in some cases as applications with postgres use. and since it is multiplatform I can install it in one environment and the other without problem and without saying that it is free and it is one of the best database engines today.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

What I like about PostgreSQL is that when I use it for small applications the queries are a bit slow compared to MySql, so I use simple applications with PhpMyAdmin and the more robust ones with postgresql, because in this sense it is better. Review collected by and hosted on G2.com.

Toghrul A.
TA
Product & Service Operations Unit Head
Mid-Market (51-1000 emp.)
"Easy to use & Reliable Database"
What do you like best about PostgreSQL?

PostgreSQL is the best free database. Everyone can install it & use for it free. It has many functionalities which you need Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Many open source applications are not support PostgreSQL. It is a main disadvantage Review collected by and hosted on G2.com.

Verified User in Computer Software
IC
Enterprise (> 1000 emp.)
"Database to sort out your daily development work"
What do you like best about PostgreSQL?

Helps us to manage our database needs while working on chatbots or other applications. The PGadmin console is really helpful as it provides a graphical interface to access or modify your db data. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

At times it won't start. You'll have to try twice or thrice to make it start. Also sometimes it might not allow to change values in a table from the PGadmin console. Review collected by and hosted on G2.com.

HECTOR FRANCO G.
HG
desarrollador de software en butterflies design web
Small-Business (50 or fewer emp.)
"PostgreSQL database server"
What do you like best about PostgreSQL?

One of the main reasons why I use PostgreSQL is that it is developed under open source (Open Source), besides that if we require a database to work on our project, the most common is that we ask ourselves which database to use provide performance, security and in turn we can use it both in the office and outside it, and one of the most common cases is that we do not all have the same operating system. It also has a management facility PgAdmin is the main base administrator Postgres data is very simple to use, this tool practically does everything with a few simple clicks, being optimal for people who do not have much experience, either because they are starting in the world of databases or because they simply need a database for your project. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PostgreSQL It is relatively slow there are things like these that I also dislike in insertions and updates in small databases, also PostgreSQL is designed for high volume environments. This makes the response speed seem slow compared to small databases. Review collected by and hosted on G2.com.

Pricing Insights

Averages based on real user reviews.

Time to Implement

2 months

Return on Investment

9 months

Average Discount

11%

Perceived Cost

$$$$$
PostgreSQL