Postgres data base is light weighted and flexible data base.Recently we have migrated to Postgres and its really easy to develop and maintain.Since it is open source we got advantage to spend money on cloud services to maintain independently.This data base has lot features and we can use for large scale applications. Review collected by and hosted on G2.com.
Some of the common SQL language syntax can be maintained without customizations.Some time we feel difficulty to find syntax in online.Otherwise, this DB is better than other open source DB tools.Some times we found some bugs which is related to tags and queries, especially libraries can be improved and documentation can be provided in detail level. Review collected by and hosted on G2.com.
Well, over time MySQL and PostgreSQL have grown closer and closer together, but for the longest time I've enjoyed using postgres over other free open source RDMBS because it had more analytical functions. Postgres has been supporting tricky things like window functions which was always super useful for tricky aggregations for reports.
However, what I like best about postgres is probably the actual documentation that is easily available that includes tons of explanations and examples. This means I can quickly make changes and figure out how to make my application needs work just by myself, even if I've never had to use Postgres or another RDMBS to do that task before. Review collected by and hosted on G2.com.
I can't say I dislike anything about postgres. The things that are 'bad' about postgres are what you get for having a relational database that uses hard disk as storage. But those are normal things that honestly don't usually slow you down or hurt your application.
Sometimes I'll use redis for a fast, non-relational in-memory database, but otherwise I always use postgres since it's free, documented well, and a great tool. Review collected by and hosted on G2.com.
Well documented installation procedures for most common Linux OS, query language and security rules Review collected by and hosted on G2.com.
Absence of GUI editor and absense of compatibility with old version of phpmyadmin Review collected by and hosted on G2.com.
1. Postgres is open source and free to use.
2. Postgres is Acid compliant and thus no data is lost.
3. Since PostgreSQL supports JSON field which was not supported by Mysql which we were using before, it has become very easy for us to work with JSON data sets. We can easily query JSON fields using Postgres query language.
4. Postgres also has a very strong community, thus it is very easy for new developers to adapt as they can easily find support online Review collected by and hosted on G2.com.
I couldn't find anything to dislike in PostgreSQL till now as it gives me all the features that were required in our web application. Review collected by and hosted on G2.com.
It includes most SQL data types, including integer, boolean, char, date, and timestamp.
It has native programming interfaces for C/C++, Java, Python, Ruby,
Within a single column you can have a range from one value to another–this is especially helpful for time ranges.
And one of the best thing is Foreign Data Wrappers which are really helpful. Review collected by and hosted on G2.com.
It is bit harder to get support or to google for results
Replication is not yet as well implemented
Doesn’t support CTE.
Doesn’t support working with arrays which is the major drawback for Software Developers or data scientists. Review collected by and hosted on G2.com.
PostgreSQL is user-friendly and GUI based database which is convenient for students to use. That's the best thing I like about it. Review collected by and hosted on G2.com.
I don't have any dislikes about PostgreSQL, because it's in the best stage of performance. Review collected by and hosted on G2.com.
This DB is open source and its really useful for any small or large scale projects.We are using this from last couple of years and it seems to be very useful product till now.Migration is really easy and SQL can be maintained in well manner.This DB helped us to overcome some performance issues and its really useful to reduce cost. Review collected by and hosted on G2.com.
Some of the query tags is not supported in postgres and query language is difficult to understand for initial beginners. This can improved and documentation is hard to follow. Review collected by and hosted on G2.com.