PostgreSQL Reviews & Product Details - Page 42

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.

Verified User in Computer Software

Small-Business (50 or fewer emp.)

12/26/2017

"Excellent open source object-relational database management system "

4/5

What do you like best about PostgreSQL?

Once you've used it for awhile, it's natural. It's easy to see all the data you need, doesn't overcomplicate things either. Wildcard Search queries are simple and I love the number of extensions there are available for developers to take advantage of.

I enjoy using the PostgreSQL app on Mac OSX. I always know when I have it running because I can see the icon on the top of my Desktop. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Installation can be tricky your first time around. I just helped a new developer set it up and it only took a few minutes of looking at the docs to give myself a reminder. The new developer was overwhelmed by the PostgreSQL documentation that he had kinda given up. After that, you'll quickly get the hang of it. PostgreSQL query syntax for more complex queries can be difficult and take a moment to learn but once you've gotten the hang of them, you'll be fine.

Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Although the documentation is a bit overwhelming at first glance, take some time and read through it. It'll help you in the long run and it's really not the scary. Review collected by and hosted on G2.com.

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

We use as our main database for 5 different projects. We've never had any issues and we like the flexibility it offers us. Review collected by and hosted on G2.com.

Verified User in Accounting

Mid-Market (51-1000 emp.)

7/31/2018

" good pretty and cheap"

4/5

What do you like best about PostgreSQL?

It is easy to use and configure this produc Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

the Latino user community is not very big Review collected by and hosted on G2.com.

Antonio R.

Analista de Gestion TIC

Enterprise (> 1000 emp.)

12/20/2017

"A performant open source alternative to Oracle and SQL Server"

4/5

What do you like best about PostgreSQL?

It is open source, it means we can look at the code and help to improve the product and troubleshoot bugs Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

it is very strict on its SQL language, Mysql lets you slack a bit, postgresql does not. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Read a lot about SQL, it uses strict language so you cant get away with things like In MYSQL. I recommend Heidisql to use with Postgresql, it is a great front end. Review collected by and hosted on G2.com.

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

Data storage, We migrated an entire database from aging Oracle and SQL server to postgresql and we are very happy with it. We currently have many databases with it and we love it. Everything we think of a new product we choose Postgresql without a doubt. Review collected by and hosted on G2.com.

Verified User in Financial Services

Enterprise (> 1000 emp.)

10/7/2018

"Easy access to database"

5/5

What do you like best about PostgreSQL?

I like the command line interface and the ease of use of SQL to query the database. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

There really wasn't anything I disliked about PostgreSQL. Review collected by and hosted on G2.com.

Verified User in Internet

Enterprise (> 1000 emp.)

11/1/2018

"easy to use for biz people"

4/5

What do you like best about PostgreSQL?

easy to use. fun to learn . and it's very powerful Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

UX can be improved . but it serves the purpose and better than others. Review collected by and hosted on G2.com.

Mithul G.

Software Engineer

Enterprise (> 1000 emp.)

8/16/2018

"Great DB!"

5/5

What do you like best about PostgreSQL?

Ease of queries and intuitive ways to search. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Harder to get community support, replication is not that well implemented Review collected by and hosted on G2.com.

Hari A.

ECM Developer

Information Technology and Services

Small-Business (50 or fewer emp.)

12/26/2017

"Postgres is the most effective Open source Database"

5/5

What do you like best about PostgreSQL?

It's open source. So, its great for startup companies. It is fully SQL compliant. The admin tool PGAdmin is powerful. I am impressed with the custom data types supported by Postgres mainly JSONB. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

We faced problem while using custom data types like JSONB. Inserting data to these type of columns via Hibernate is not straightforward. We referred a couple of articles on that to resolve the issue. https://github.com/thjanssen/HibernateJSONBSupport/tree/master/PostgresJSONB Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgres is the most effective Open source Database Review collected by and hosted on G2.com.

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

We are using Postgres as a database choice for a custom product development. This database will contain a large amount of data. As an open source, it provides enterprise level RDBMS functionalities. Review collected by and hosted on G2.com.

Verified User in Computer Software

Mid-Market (51-1000 emp.)

11/13/2018

"postgre sql is an object oriented database"

4/5

What do you like best about PostgreSQL?

that it is object oriented and lets us define user defined datatypes Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

that it is more complicated than mysql and nosql Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Small-Business (50 or fewer emp.)

4/20/2018

"Best in class"

5/5

What do you like best about PostgreSQL?

Everything about postgres is quite lovely. We use it for our startup and its quite cool. We switched from MySQL to postgres. One thing that I most love in postgres is that it is schema based, which makes it cool for our needs. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing much I dislike about postgres, Its quite cool. Maybe one thing i would suggest (Not I dislike). Maybe we can have some GUI based tool for querying for non-tech guys to query too. Other than the pgAdmin tool. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

If you really want some Database that is less complex and easy to use, then I would suggest to go with Postgres. And the community is also quite growing super fast. Review collected by and hosted on G2.com.

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

We use it as the primary database for our web-app. Review collected by and hosted on G2.com.

Arik B.

CEO & Co-Founder

Computer Software

Small-Business (50 or fewer emp.)

12/13/2017

"Excelent and flexible open source SQL database"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is a mature database server with large user's community and continue development. Installation is very simple and also integration with multiple development environment is supported we user C++ library, PHP and Java integration Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

would like better admin package, managing changes as versions is bit complex Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

This is an open source SQL database that include many of the much more expensive solutions and it is open source with wide community of contributers Review collected by and hosted on G2.com.

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

We use PostgreSQL as our system DB and benefit from wide range of features and extensions. We need to access the database from several environment and this is very simple and supported with large number of libraries and connections. Review collected by and hosted on G2.com.