2017-03-03T21:45:00Z

What is the best GUI tool for development and management of a PostgreSQL database?

it_user581010 - PeerSpot reviewer
  • 12
  • 68
PeerSpot user
11

11 Answers

it_user136014 - PeerSpot reviewer
Vendor
2017-05-30T05:03:51Z
May 30, 2017

My recommendation also pgAdmin to access the PostgreSQL.

Search for a product comparison in Database Development and Management
it_user420135 - PeerSpot reviewer
Consultant
2017-03-08T14:58:54Z
Mar 8, 2017

Hi,

I have used pgAdmin and definitely it is a complete tool to do management and development tasks as well, it could be run on a desktop or on a server to provide web access.
I'm an open source fan so, I recommend it :)

there my two cents

Jairo

it_user418215 - PeerSpot reviewer
Vendor
2017-03-08T08:07:21Z
Mar 8, 2017

PgAdmin (https://www.pgadmin.org/) is a good tool and free.
Another one is EMS Sql Manager, it's free but you must pay for use some parts of this tool.

it_user133485 - PeerSpot reviewer
Consultant
2017-03-08T04:47:06Z
Mar 8, 2017

pgadmin is enough for most of the activities

it_user448206 - PeerSpot reviewer
Real User
2017-03-08T00:08:09Z
Mar 8, 2017

I'd recommend using DataGrip. It's a commercial tool from Jetbrains, but it actually supports many databases and is java based. It will run on windows, mac and linux systems. It also supports syntax highlighting and auto completion.

They offer a free trial. If you need something free, pgAdmin III is a good option as well.

it_user434985 - PeerSpot reviewer
Vendor
2017-03-07T21:42:38Z
Mar 7, 2017

pgadmin : https://www.pgadmin.org/download/
postgresapp on Mac: https://postgresapp.com/

Find out what your peers are saying about PostgreSQL and others in Database Development and Management. Updated: March 2024.
765,234 professionals have used our research since 2012.
it_user376926 - PeerSpot reviewer
Consultant
2017-03-07T18:55:23Z
Mar 7, 2017

pgAdmin is pretty good.

it_user482406 - PeerSpot reviewer
Vendor
2017-03-07T17:54:06Z
Mar 7, 2017

I'm personally a big fan of DbVisualizer. It works with any SQL DB.

it_user281919 - PeerSpot reviewer
Consultant
2017-03-07T17:16:17Z
Mar 7, 2017

Hi Tejpal,

I have worked with PostgreSQL since version 8.3, and pgadmin has been more than enough for my tasks; however, once I tested Navicat (which is propietary) and I think it has a lot of features closer to clients as Toad (for example).

You can test both and decide by yourself which option is better for you..

Regards..

--
Álvaro

Shrikant Navelkar - PeerSpot reviewer
Reseller
Top 10
2017-03-07T16:05:27Z
Mar 7, 2017

Managing PostgreSQL and Developing applications on PostgreSQL are two very different activities. If you are looking for a low cost open source option for managing PostgreSQL then I would suggest Nagios.
For development of applications on PostgreSQL, you have many options and the selection would depend on type of an application. If your application needs data mining or complex data handling functions then Python (with Idle IDE) is a better option. If you are looking for a scalable web based application then Java should suffice.

Hope this helps.

Shrikant

BD
Consultant
Top 5
2017-03-07T15:51:47Z
Mar 7, 2017

Will you be on windows or mac computer?

Database Development and Management
According to the PeerSpot community, the key factors that make up a good Database Development and Management solution include speed and performance, ease of development, availability, and reliability, but security is the most influential decision-maker of all. More complex features that are also highly rated include query optimization and data handling, while monitoring and cost for value weighed in as well.
Download Database Development and Management ReportRead more

Database Development and Management experts

AANKITGUPTAA - PeerSpot reviewer
Derrick Brockel - PeerSpot reviewer
PatrickKuria - PeerSpot reviewer
NenadMijatovic - PeerSpot reviewer
Ravi Khanchandani - PeerSpot reviewer
Balamurugan Ramalingam - PeerSpot reviewer
Jason-Nash - PeerSpot reviewer
SR