Обсуждение: [GENERAL] Developer GUI tools for PostgreSQL

You can try SQL Manager for PostgreSql. The Lite edition is enough ans
it's free.
It's fast, secure and very friendly.

On 26/07/17 19:41, Tiffany Thang wrote:
> Hi,
> I'm new to PostgreSQL. I'm looking for a developer tool that works
> similarly to TOAD or SQL Developer for Oracle/MySQL which would allow
> me to view and make DDL changes to database objects and create data
> models. It would be a plus if I can use the same tool to perform some
> database administration tasks.
>
> So far, I've found TOra and pgAdmin 4. Are there any other popular GUI
> tools?
>
> Thanks in advance.
>
>

On 07/26/2017 05:58 PM, Tim Uckun wrote:
> I am waiting till pgadmin4 gets a bit faster. It seems kind of slow on
> my mac.

PostgreSQL Studio
Navicat
EMS PostgreSQL Manager
PgAdmin3 LTS (BigSQL)

JD


--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
*****     Unless otherwise stated, opinions are my own.   *****

See  dbeaver. http://dbeaver.jkiss.org

community and Enterprise editions are free and it's very good

On Wed, 2017-07-26 at 18:31 -0700, Joshua D. Drake wrote:
> On 07/26/2017 05:58 PM, Tim Uckun wrote:
> > I am waiting till pgadmin4 gets a bit faster. It seems kind of slow
> > on 
> > my mac.
>
> PostgreSQL Studio
> Navicat
> EMS PostgreSQL Manager
> PgAdmin3 LTS (BigSQL)
>
> JD
>
>


If you are a Java person, go to executequery.org and download the jar
file or the Deb package and install it.
It has the advantage of being able to work on multiple RDBMSs' at the
same time. All you need are the appropriate JDBC's. For example, you
could be connected to a Postgres database and also an Oracle one.

HTH.
Rob

On 26.07.17 - 18:41, Tiffany Thang wrote:
> Hi,
> I'm new to PostgreSQL. I'm looking for a developer tool that works
> similarly to TOAD or SQL Developer for Oracle/MySQL which would allow me to
> view and make DDL changes to database objects and create data models. It
> would be a plus if I can use the same tool to perform some database
> administration tasks.

I've grown quite fond of pgModeler:
https://www.pgmodeler.com.br/

It's working really nice, has some layout validation checks, good
visualization features, easy to use and if you really need you can
also put in some SQL statements by hand.

It lacks however some administration capabilities so it's best used
with pgAdmin (or use the pgsql cli).

Cheers,
Thore

--

On 2017-07-27 00:41, Tiffany Thang wrote:
> Hi,
> I'm new to PostgreSQL. I'm looking for a developer tool that works
> similarly to TOAD or SQL Developer for Oracle/MySQL which would allow
> me to view and make DDL changes to database objects and create data
> models. It would be a plus if I can use the same tool to perform some
> database administration tasks.
>
> So far, I've found TOra and pgAdmin 4. Are there any other popular GUI
> tools?
>
> Thanks in advance.

There is also DbSchema, for getting a good overview of your tables.
I use Jetbrains dataGrip for maintenance etc. I find that using a GUI
for things like creating functions is nice
but you never really learn what's going on so you are in trouble when
you have to do something and your GUI is not available.

On 2017-07-28 06:31, Tim Uckun wrote:
> I think it's funny that after all these years pgadmin3 is still the
> most comprehensive GUI for postgres.

Have you looked at EMS SQL-Manager, I don't remember PgAdmin having any
where near hte features that it has :-P

> Even though it's prone to
> crashing on my machine and I have paid for datagrip I still reach for
> it first.
>
>

It depends entirely on your personal preference, not so much on the
features of the tool,
there are whole subcultures in the IT world who swear by VIM. I tend to
swear *at* VIM.

But in the end it's personal preference and requirements that decide
which is the best tool.
I use DbSchema because of how quickly and visually I can create tables,
but I use DataGrip to execute
queries to actually manage a database, create functions, views etc.

Most tools have free preview licences so download them try them out, see
what feels good to you.
Just remember that a tool is not a substitute for knowledge, knowing
where to click in a GUI
is not the same as knowing how to maintain a database.

You can try DBeaver.  It is a generic GUI tool which works with practically
all RDBMS.  It is java based, and I find it bit slow. However judging by the
frequent updates I get, it seems to be very active.



--
View this message in context:
http://www.postgresql-archive.org/Developer-GUI-tools-for-PostgreSQL-tp5972993p5973305.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.