PostgreSQL Reviews & Product Details - Page 44

admin

PostgreSQL Overview

edit

What is PostgreSQL?

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

PostgreSQL Details

Discussions

PostgreSQL Community

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:

Avi Ashkenazi

CTO at Coronys LTD.

PostgreSQL Integrations

(3)

Integration information sourced from real user reviews.

PostgreSQL Media

PostgreSQL

G2 reviews are authentic and verified.

Here's how.

Marco P.

Co-founder / CTO

Small-Business (50 or fewer emp.)

12/19/2017

"Performant, reliable and scalable"

5/5

What do you like best about PostgreSQL?

We use PostgreSQL in production since 8 years now, in a multi-nodes HA setup based on the built-in streaming replication. PostgreSQL is a great database, offering high performances and allowing to easily scale read-replicas with the built-in streaming replication. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The major issue with PostgreSQL is the complexity of doing a major version upgrade with nearly zero downtime. Starting from PostgreSQL 10 this issue has been largely reduce thanks to the logical replication. Review collected by and hosted on G2.com.

Arturo J.

Director de Tecnología

Computer Software

Small-Business (50 or fewer emp.)

7/10/2018

"Great database for cloud software"

5/5

What do you like best about PostgreSQL?

PostgreSQL is a great database for cloud development Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Documentation is a nit tricky to understand at first Review collected by and hosted on G2.com.

Manjushri S.

Java Software Developer

Information Technology and Services

Enterprise (> 1000 emp.)

11/29/2017

"PostgreSQL database review"

4/5

What do you like best about PostgreSQL?

PostgreSQL is an open source database and in that way has a great advantage over other licensed databases like Oracle. Currently, we have been trying to migrate all legacy applications from Oracle to postGRESQL.PostgreSQL database works very well with hibernate JPA and we have been using it extensive along with the Spring framework. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no good client to use the database been using pg admin and I am not really a big fan of the interface provided by pgadmin, we cannot "pin" any query results unlike the SQL developer. Review collected by and hosted on G2.com.

Justin H.

Carrier Sales / Switch Technician

Telecommunications

Small-Business (50 or fewer emp.)

3/4/2018

"PostgreSQL usually gets the job done"

4/5

What do you like best about PostgreSQL?

Data integrity, wide variety of column types, great documentation Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Data import can be difficult, usually needs a 3rd party tool even with the simplest CSV files. Review collected by and hosted on G2.com.

Sorabh S.

Head Of Development

Enterprise (> 1000 emp.)

1/5/2018

"Best for Any medium scale sized project"

5/5

What do you like best about PostgreSQL?

ANSI Compliant SQL, Verbose logging, Replication ease, Indexing performance Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing as such , would recommend for further projects also. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Give it a try, it wont disappoint you. Review collected by and hosted on G2.com.

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

Its used for financial Applications for a insurance company. We are creating web and mobile based apps for this company, although previously it was also good with another db product, but with pogres ease of use, and orm compatibility is better. Review collected by and hosted on G2.com.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

8/1/2018

"Postgres is the best"

5/5

What do you like best about PostgreSQL?

Fast secure frequently updated and plenty of drivers available. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Not as popular as some other solutions so which can make it hard to debug strange errrs Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

7/10/2018

"Great Versatile DBMS software"

4/5

What do you like best about PostgreSQL?

The ability to create databases without any price requirement and allowing to run SWL commands on those databases dynamically is great Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There is no GUI to check the created databases and their values for a quick glance. Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

7/13/2018

"Great database system"

5/5

What do you like best about PostgreSQL?

I enjoyed the capability to use other programming languages within it to allow for easy data modifications and more. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The thing that was the hardest to get comfortable with was all the short hand notation. Most are single character, which can get confusing. Review collected by and hosted on G2.com.

Verified User in Insurance

Enterprise (> 1000 emp.)

7/30/2018

"Fantastic Database for all use cases"

5/5

What do you like best about PostgreSQL?

It's free, and I can install it on any of my VMs and make it work for me. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing in particular. There isn't enough on Stackoverflow for this product as compare to Oracle. Review collected by and hosted on G2.com.

Verified User in Telecommunications

Mid-Market (51-1000 emp.)

7/20/2018

"PostgreSQL, the best fusion between SQL and programming"

5/5

What do you like best about PostgreSQL?

The immense possibility of programming allowed by the code, allowing the generation of interfaces from SQL code. Review collected by and hosted on G2.com.