Re: [GENERAL] Developer GUI tools for PostgreSQL

[rakeshkumar464]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Tim Uckun]

I don't run windows so I haven't looked at the EMS product.

On Fri, Jul 28, 2017 at 6:53 PM, vinny  wrote:

> 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.
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[vinny]

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.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Tim Uckun]

I think it's funny that after all these years pgadmin3 is still the most
comprehensive GUI for postgres. Even though it's prone to crashing on my
machine and I have paid for datagrip I still reach for it first.

On Fri, Jul 28, 2017 at 2:46 AM, vinny  wrote:

> 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.
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[vinny]

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.



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Tiffany Thang]

Thanks everyone for your input!

On Thu, Jul 27, 2017 at 3:48 AM, Thore Boedecker  wrote:

> 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
>
> --
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Thore Boedecker]

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

-- 


signature.asc
Description: PGP signature

Re: [GENERAL] Developer GUI tools for PostgreSQL

[JingYuan Chen]

I recommend that you can try Squirrel SQL.
(http://squirrel-sql.sourceforge.net/index.php?page=screenshots)

It is a SQL tool based on JVM. You can execute it whether on Linux or
WIndow, even MAC.
It use JDBC to connect Database. So that you can install differet JDBC
Driver to connect to different databases, such as Oracle (Thin Driver) ,
PostgreSQL (Pg JDBC), MS-SQL ( JTDS ) and so on.

Beside DDL oprations, I also use it to copy data in order to build sandbox
environment. Select the table, Right click and Copy it, then Paste it. Only
three steps to create a new table with data for test or development
purpose. Some nice facilities I often used are rotated table, view metadata
and monitor server performance. Yes, it can also export the data you
fetched as Excel or CVS file.

Try it and you will love it !


Regards,
Chingyuan

On Thu, Jul 27, 2017 at 9:31 AM, 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
>
>
> --
> 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.   *
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[rob stone]

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


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Reid Thompson]

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

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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Joshua D. Drake]

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.   *


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Tim Uckun]

I am waiting till pgadmin4 gets a bit faster. It seems kind of slow on my
mac.

On Thu, Jul 27, 2017 at 12:05 PM, Brent Wood <pcr...@yahoo.com> wrote:

>
> +1
> I think PgAdmin4 has yet to catch up with v3 for functionality, but it is
> more actively developed and supported.
>
> You might check this page out as well:
> https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools
>
> <https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools>
> Cheers,
>
> Brent Wood
> --
> *From:* Tim Uckun <timuc...@gmail.com>
> *To:* Tiffany Thang <tiffanyth...@gmail.com>
> *Cc:* pgsql-general <pgsql-general@postgresql.org>
> *Sent:* Thursday, July 27, 2017 11:34 AM
> *Subject:* Re: [GENERAL] Developer GUI tools for PostgreSQL
>
> I still use pgadmin3. I also have a subscription to the jetbrains tools so
> I also give datagrip a try once in a while. Datagrip has a lot going for it
> but it's lagging behind pgadmin3 is a lot of ways so it hasn't replaced it
> for me.
>
> On Thu, Jul 27, 2017 at 10:41 AM, Tiffany Thang <tiffanyth...@gmail.com>
> 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.
>
>
>
>
>
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[Tim Uckun]

I still use pgadmin3. I also have a subscription to the jetbrains tools so
I also give datagrip a try once in a while. Datagrip has a lot going for it
but it's lagging behind pgadmin3 is a lot of ways so it hasn't replaced it
for me.

On Thu, Jul 27, 2017 at 10:41 AM, 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.
>
>
>

Re: [GENERAL] Developer GUI tools for PostgreSQL

[marcelo]

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.






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general