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 :)
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.
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.
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..
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.
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.
My recommendation also pgAdmin to access the PostgreSQL.
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
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.
pgadmin is enough for most of the activities
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.
pgadmin : https://www.pgadmin.org/download/
postgresapp on Mac: https://postgresapp.com/
pgAdmin is pretty good.
I'm personally a big fan of DbVisualizer. It works with any SQL DB.
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
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
Will you be on windows or mac computer?