2017-03-03T21:45:00Z

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

I'm interested to hear what people feel is the best tool for a developer and administrator who has a background with Oracle / MS SQL Server.

it_user581010 - PeerSpot reviewer
Technical Lead at 3Pillar Global
  • 12
  • 69
11
PeerSpot user
11 Answers
it_user136014 - PeerSpot reviewer
Marketing at Ricoh India Ltd
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
Senior System Architect & Consultant at a tech services company with 51-200 employees
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
Senior Backend Game Developer & Database Architect & DBA at a computer software company with 51-200 employees
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
Senior Developer at a tech services company
Consultant
2017-03-08T04:47:06Z
Mar 8, 2017

pgadmin is enough for most of the activities

it_user448206 - PeerSpot reviewer
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees
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
Sr. Database Architect at Medallia
Vendor
2017-03-07T21:42:38Z
Mar 7, 2017

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

Learn what your peers think about PostgreSQL. Get advice and tips from experienced pros sharing their opinions. Updated: May 2023.
708,243 professionals have used our research since 2012.
it_user376926 - PeerSpot reviewer
Data Developer at a tech services company with 10,001+ employees
Consultant
2017-03-07T18:55:23Z
Mar 7, 2017

pgAdmin is pretty good.

it_user482406 - PeerSpot reviewer
Associate Director, eCommerce Analytics at POSSIBLE
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
Consultor en Gestión de Información at a tech services company with 51-200 employees
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
Director at Clover Infotech
Reseller
Top 5
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
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5
2017-03-07T15:51:47Z
Mar 7, 2017

Will you be on windows or mac computer?

Related Questions
NC
Content Manager at PeerSpot (formerly IT Central Station)
Dec 12, 2021
Which is better and why?
See 1 answer
DG
Tech blogger
Dec 12, 2021
PostgreSQL was designed in a way that provides you with not only a high degree of flexibility but also offers you a cheap and easy-to-use solution. It gives you the ability to redesign and audit your database with great ease. This allows you to have the kind of database that you need on a case-by-case basis. Instead of being locked into an inflexible database format, you are in control and dictate exactly what format the database will take at any given time. You can easily manipulate it, which means that you will be able to use PostgreSQL in the way that will help your organization the most. PostgreSQL is also pretty easy to use. Its designers made it so that you don’t have to have an extensive technical education to use it. It is pretty intuitive and has excellent documentation to answer any employee questions. Furthermore, PostgreSQL also offers you a cheap solution whose hosting and maintenance can be handled totally in-house. PostgreSQL’s open-source nature makes it extremely cheap to implement. Resources that might have been spent on setting it up can now be saved and redirected to areas of greater need. Furthermore, the program has two different download options. It can either be downloaded and used on-site or it can be downloaded to the cloud. Both of these allow you to be totally independent. You can host it from your headquarters or access it from anywhere you choose. Firebird SQL offers you the ability to scan your database code and search it for many types of issues. It can also compile reports based on any of the problems that it may find. However, it lacks the flexibility that PostgreSQL offers. It cannot be customized in the same way, which leaves you with fewer options. Conclusion While Firebird SQL is a fairly competent product, we found PostgreSQL to be superior. PostgreSQL’s greater flexibility and dual download options make it the more robust solution.
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot
Mar 2, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 18 answers
MR
Senior Database Administrator Engineer at a comms service provider with 10,001+ employees
Nov 25, 2020
It is free. There is no license on it.
RM
Director at a tech services company with 1-10 employees
Nov 26, 2020
I'm not sure what the licensing costs for the solution are.
Download Free Report
Download our free PostgreSQL Report and get advice and tips from experienced pros sharing their opinions. Updated: May 2023.
DOWNLOAD NOW
708,243 professionals have used our research since 2012.