5 ms·

The OP mentions gui, but what is the best gui/code editor/ide for postgres for linux? I found this list. I'll go through them. https://wiki.postgresql.org/wik

The OP mentions gui, but what is the best gui/code editor/ide for postgres for linux? I found this list. I'll go through them. https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...

conradfr 12y ago
As a developer the database tool in Jetbrains' IDE covers the vast majority of my needs, in addition to the golden autocompletion in the code.
rch 12y ago
I've found pgAdmin to be sufficient for clicking through things here and there, but my sense is that DBA types are expecting more from the GUI than I am. Any insight into what those things might be would probably be helpful.
smilliken 12y ago
I've gone through that list before, but never find anything compelling enough to pull me away from psql (the built-in CLI client). I highly recommend learning psql first. It doesn't have every feature you might want, but it gets the basics right and is easy to integrate with your editor and other tools. As far as I can tell, it's what most professionals use.
- yangyang 12y ago
  I fully agree with this. I used pgAdmin for a while but have recently switched to psql and it's much more useful. In particular, learn the \ commands. It's extremely useful to be able to quickly look at the structure of a table, dump the source to a function and so on, from a command prompt rather than navigating trees with the mouse in pgAdmin. It uses readline where available so you get history, completion etc.
booty 12y ago
All I really want from a database IDE is awesome autocomplete for identifiers and keywords. (I consider SQL Server Management Studio's autocomplete to be great - if I could get that for Postgres, I'd be thrilled) You can get part of the way there by Sublime Text to run queries and browse results. In Sublime, it's easy - you can create a custom "build tool" with (essentially) just one line of config... you're basically just piping the current file's contents to command-line PSQL: https://www.youtube.com/watch?v=tPd4m3PLVqU https://www.youtube.com/watch?v=tPd4m3PLVqU Then I use the SublimeAllAutocomplete package. It works just like "regular" Sublime autocomplete except it gives you autocomplete suggestions from all open files, not just the current one - so if you have your DB schema dump in another window it will use that: https://github.com/alienhard/SublimeAllAutocomplete https://github.com/alienhard/SublimeAllAutocomplete Obviously, that doesn't really give you the smartest autocomplete ever but it's pretty productive for me. Tons of room for improvement though.
- asnyder 12y ago
  Has auto-complete and everything: http://www.sqlmanager.net/products/postgresql/manager http://www.sqlmanager.net/products/postgresql/manager
megaman821 12y ago
It is not free (or even that cheap) but Navicat is really good. It was worth it for me as much as I interact with databases.
- untog 12y ago
  Seconded. And the 'Essentials' version is only $9.99.
dataminded 12y ago
Aqua Data Studio is the best database IDE I have ever used.
deleted 12y ago
[deleted]
A_COMPUTER 12y ago
I use ToRA http://torasql.com/ http://torasql.com/ and/or Oracle SQLDeveloper. Both of them are Oracle DB tools that work fine with Postgres with the right drivers. pgadmin is intolerable.

conradfr 12y ago

As a developer the database tool in Jetbrains' IDE covers the vast majority of my needs, in addition to the golden autocompletion in the code.

rch 12y ago

I've found pgAdmin to be sufficient for clicking through things here and there, but my sense is that DBA types are expecting more from the GUI than I am. Any insight into what those things might be would probably be helpful.

smilliken 12y ago

I've gone through that list before, but never find anything compelling enough to pull me away from psql (the built-in CLI client). I highly recommend learning psql first. It doesn't have every feature you might want, but it gets the basics right and is easy to integrate with your editor and other tools. As far as I can tell, it's what most professionals use.

yangyang 12y ago
I fully agree with this. I used pgAdmin for a while but have recently switched to psql and it's much more useful. In particular, learn the \ commands. It's extremely useful to be able to quickly look at the structure of a table, dump the source to a function and so on, from a command prompt rather than navigating trees with the mouse in pgAdmin. It uses readline where available so you get history, completion etc.

booty 12y ago

All I really want from a database IDE is awesome autocomplete for identifiers and keywords. (I consider SQL Server Management Studio's autocomplete to be great - if I could get that for Postgres, I'd be thrilled) You can get part of the way there by Sublime Text to run queries and browse results. In Sublime, it's easy - you can create a custom "build tool" with (essentially) just one line of config... you're basically just piping the current file's contents to command-line PSQL: https://www.youtube.com/watch?v=tPd4m3PLVqU https://www.youtube.com/watch?v=tPd4m3PLVqU Then I use the SublimeAllAutocomplete package. It works just like "regular" Sublime autocomplete except it gives you autocomplete suggestions from all open files, not just the current one - so if you have your DB schema dump in another window it will use that: https://github.com/alienhard/SublimeAllAutocomplete https://github.com/alienhard/SublimeAllAutocomplete Obviously, that doesn't really give you the smartest autocomplete ever but it's pretty productive for me. Tons of room for improvement though.

asnyder 12y ago
Has auto-complete and everything: http://www.sqlmanager.net/products/postgresql/manager http://www.sqlmanager.net/products/postgresql/manager

megaman821 12y ago

It is not free (or even that cheap) but Navicat is really good. It was worth it for me as much as I interact with databases.

untog 12y ago
Seconded. And the 'Essentials' version is only $9.99.

dataminded 12y ago

Aqua Data Studio is the best database IDE I have ever used.

deleted 12y ago

[deleted]

A_COMPUTER 12y ago

I use ToRA http://torasql.com/ http://torasql.com/ and/or Oracle SQLDeveloper. Both of them are Oracle DB tools that work fine with Postgres with the right drivers. pgadmin is intolerable.