PostgreSQL Reviews & Product Details - Page 58

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.

Ralph S.

Position Seeker

Information Technology and Services

Small-Business (50 or fewer emp.)

5/9/2017

"Postgresql for the enterprise and to learn with"

4/5

What do you like best about PostgreSQL?

Elegance, intuitive feel. Great manual. Endless improvements. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

hard to keep up with all the enhancements! Review collected by and hosted on G2.com.

Dan J.

GIS Officer

Non-Profit Organization Management

Enterprise (> 1000 emp.)

11/28/2016

"powerful open-source database option"

4.5/5

What do you like best about PostgreSQL?

PostgreSQL is well-documented, powerful, mature, and has a huge user base. Easy to find examples and forum postings when troubleshooting just about any scenario: the odd error message, problems using pgAdmin, figuring out how to integrate PostgreSQL into your node.js application. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

For some use-cases, PostgreSQL isn't the best option. It's worth considering your needs and looking at SQLite, MongoDB, and others. Review collected by and hosted on G2.com.

Ian H.

Programmer

Computer Software

Enterprise (> 1000 emp.)

7/14/2016

"PostgreSQL is the best database system I've used"

5/5

What do you like best about PostgreSQL?

Coming from a MySQL background, I love the variety of data types in Postgres: JSON, arrays, etc, all fill a need that MySQL didn't. I especially like how easy it is to manipulate dates, something that has sped up development a ton in terms of automated testing. The ability to enforce checks on insertion is very helpful, too. I've used NoSQL before, and I much prefer the rigidity of an RDBMS. All too often I've had to deal with corrupt data because of the temptation to fool around directly in the database rather than using the application layer. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Probably the most difficult thing about Postgres is its permissions model. It's not very intuitive, in my opinion, and I think those issues need to be resolved before it can gain the sort of traction MySQL has. Right now it's just not easy for a beginner to get set up and secure. Review collected by and hosted on G2.com.

Verified User in Legal Services

Small-Business (50 or fewer emp.)

10/25/2016

"Great experience with PostGres"

4.5/5

What do you like best about PostgreSQL?

love the aggregate functions, also JSONB support, as well as views and materizlized views maintenance. very stable and secure. It is easy for me to maintain as an analyst Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

certain data types are not good. i find the admin tools to not be amazing either Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

i would recommend as a data analytics database. It can be difficult to scale and if you have a lot of data that doesnt easily translate into columns (json) unless you are using a vendor to complete ETL process. I love postgres tho :) Very stable and secure and documentation is great Review collected by and hosted on G2.com.

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

I use postgres as a analytics data warehouse only. I allow acces for all other analysts, and sit analysis tools on top. this works quite well. I am often looking for ways to optimize queries tho Review collected by and hosted on G2.com.

Hakim B.

PhD Student

Higher Education

Enterprise (> 1000 emp.)

2/14/2017

"A review of PostgreSQL"

3.5/5

What do you like best about PostgreSQL?

PostgreSQL seems to scale well compared to MySQL, which means that it's more capable than the latter to withstand a larger database and an increasing number of transactions and connections. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

The learning curve seems a bit steep compared to MySQL. And therefore, a beginner might struggle to get started with it. Pgadmin is also not as intuitive as PhpMyAdmin for example and takes a bit of time to get used to. Review collected by and hosted on G2.com.

Verified User in Aviation & Aerospace

Enterprise (> 1000 emp.)

4/18/2017

"Works just fine"

3/5

What do you like best about PostgreSQL?

For the basic level of DB functionality that I need, I honestly see no difference between this or other similar software. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing, it works just fine for my needs. Review collected by and hosted on G2.com.

McCourt C.

Systems Development Manager

Small-Business (50 or fewer emp.)

4/27/2016

"A great Alternative to MS Sql"

5/5

What do you like best about PostgreSQL?

Postgresql is a very lightweight cross platform solution.

This makes it a perfect alternative to some of the larger commercial solutions out there right now.

The community behind it is also first class, loads of support is available via the forums when needed.

My favorite feature however is replication.

Although you will be editing text based config files to get set up, you can literally have one database replicating to another in half an hour(for basic configs).

I know this is possible with other commercial tools, but Postgres is free to use.

I use it for all of my personal projects when possible.

Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Its a little tricky to configure for those who are used to graphical interfaces like in MS SQL server. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Join the communities and read as much as you can about the config.

Dip your toe in and you will be surprised what Postgresql can do and how fast it can be. Review collected by and hosted on G2.com.

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

Really again the replication has allowed us as an ISV to offer enterprise level service to clients whom may not otherwise have been able to afford to do it with commercial offerings. Review collected by and hosted on G2.com.

Anson A.

Data Czar

Mid-Market (51-1000 emp.)

12/21/2016

"Postgres"

3.5/5

What do you like best about PostgreSQL?

open source, large community, some nice functions that get updated. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

parallel queries not available yet.

not as frequent w/ patches or new function releases Review collected by and hosted on G2.com.

Rob M.

Director of Software Development

Health, Wellness and Fitness

Small-Business (50 or fewer emp.)

5/20/2016

"Postgresql - the default database for new RoR projects"

5/5

What do you like best about PostgreSQL?

Solid SQL database, all standard SQL syntax supported with many nice extensions.

Stable

Excellent documentation and good develop support community

Full internationalization support

Good performance

Support for advanced SQL features, like "WITH" clauses and POSIX regular expressions

Built-in full text search (tsearch)

Support for distributed databases - master/slave replication

Lots of native "C" extensions

Right price - open source

Runs on Windows, OSX, and Unix

Installs on OSX using HomeBrew. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

PgAdmin tends to crash, losing your query, when you resize the query window. That's been true for over 5 years now. I wish they'd fix that. It might have flaws as larger scales that I use it at, but I haven't seen any yet. Review collected by and hosted on G2.com.

chedi t.

Consultant

Computer Software

Small-Business (50 or fewer emp.)

4/22/2016

"postgresql review"

5/5

What do you like best about PostgreSQL?

I've worked with many relationnal databases over the years and mysql was my goto solution for web development for a while. Until I was forced to use postgis extension of postgresql for a geospatial data storage project. Since then, postgresql became my defacto databse.

Very reliable, great performance and advanced features make postgresql a solution for midium to large deployment. Advanced data types, especially spatial in my case, rich feature sets and the possibility to write stored procedures in python are a deal sealer.

It's also opensource, with a good support and a welcoming community. Review collected by and hosted on G2.com.

What do you dislike about PostgreSQL?

Nothing really, but there is some known gotcha and behaviors that can be confusing for new users. Reading the documentation is a must even if you have a background with other RDBMS.

Tunning the performance of the system is up to the database administrator and the number of options can be overwhelming sometime. Review collected by and hosted on G2.com.

Recommendations to others considering PostgreSQL:

Postgresql is a very advanced database system with an emphasis on extensibility and customization. The documentation is quiet large and the options multiple and you will likely take you a long time to figure it all out but it's all worth it in the end. Review collected by and hosted on G2.com.

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

Postgresql is really the most advanced and reliable database that we have used yet. We are using it in conjunction with Django web framework and a geospatial systems using the postgis extension.

The cost/quality ration is just unparalleled with any other solution. Review collected by and hosted on G2.com.