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.
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.
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.
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.
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.
certain data types are not good. i find the admin tools to not be amazing either Review collected by and hosted on G2.com.
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.
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.
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.
Nothing, it works just fine for my needs. Review collected by and hosted on G2.com.
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.
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.
open source, large community, some nice functions that get updated. Review collected by and hosted on G2.com.
parallel queries not available yet.
not as frequent w/ patches or new function releases Review collected by and hosted on G2.com.
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.
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.
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.
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.