Intuitive front end and GUI. Quickly becoming an industry favourite Review collected by and hosted on G2.com.
The interface could be an acquired taste to some but it does take some while to get used to Review collected by and hosted on G2.com.
In terms of security, it has one of the most advanced locking mechanisms available. It has a large amount of storage space and is well-known for the integrity of its data. Server-Side Programming features that are mature. Due to robustness, many dynamic websites and online apps rely on PostgreSQL as their back-end database. Review collected by and hosted on G2.com.
Column re-ordering is not available,
slower than MySQL Review collected by and hosted on G2.com.
It is very complete for any type of project or application. It is stable, easy to use and can handle a lot of structured data. It is free software and is very well documented It is very popular and has a very varied community around the project Review collected by and hosted on G2.com.
Installment and handelling of initial infrastructure is big complex. Review collected by and hosted on G2.com.
PostgreSQL was a cost effective option to choose from RDBMS. It was easy to configure and get setup. As it is similar to other RDBMS in market so learning this by other team members was not complicated. Review collected by and hosted on G2.com.
We want to move some of our workloads from other RDBMS to Postgres, but couldn't find any suitable tool. Also, some dashboard to see the health and statistics of Server, DB and table would be helpful. Review collected by and hosted on G2.com.
I like that its free, open source, and very fast. Review collected by and hosted on G2.com.
Connecting requires a local daemon running and using the web browser (they have a windows app, but it is just the browser wrapped in the app using Electron). Deployment is a bit trickier than MySQL but easier than MSSQL Server, considering the price being free, its not much of a concern) Review collected by and hosted on G2.com.
I have used this as this was free and so to save product cost client wanted to migrate from SQL to PostgreSQL. There are some offcourse syntax changes but overall logic remains same. Review collected by and hosted on G2.com.
Nothing to dislike as such but ya but 1 thing i would like to point out, it doesn't contain every method which is used is sql. So there are some changes which you need to do if you are looking for a migration. Not all collation such as sql latin1_general_ci_as for eg are nt available. Review collected by and hosted on G2.com.
I like how this database could handle extensive data and small data. I have been using it for lots of small projects as well as for large project that handles data processing and event-driven projects. It's good to see such flexibility in heavily read-write processes. Review collected by and hosted on G2.com.
What I dislike about it is the GUI to handle all the operations are not that user-friendly compared to what mongo DB or MySQL has. I wonder if the Postgres team gets to have some good UI UX for postgres as well. Review collected by and hosted on G2.com.
PostgreSQL is one of the best available open-source relational database management systems. Available on all the platforms. GUI is also available which is again the best thing. Review collected by and hosted on G2.com.
PostgreSQL CLI commands are not very commonly used. It is hard to remember on initial stage. Review collected by and hosted on G2.com.
It's very easy to set up, especially when using a managed service from a cloud provider. Review collected by and hosted on G2.com.
Migrating when there are version upgrades can be a bit of a pain. Review collected by and hosted on G2.com.