Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PgModeler – PostgreSQL Database Modeler

pgmodeler.io

Post reply on HN
Print view View original

21–30 of 33 posts

Re: PgModeler – PostgreSQL Database Modeler

#23

Post by nablaone »

kumarvvr wrote: post #10

Can anyone suggest any better alternatives, even paid ones? I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.

If you're looking for db modeling tool try vertabelo.com (work here)

I use psql console for other tasks (db management/data access).

Re: PgModeler – PostgreSQL Database Modeler

#25

Post by estsauver »

newscracker wrote: post #16
asah wrote: post #11

suggestion: display the price prior to clicking, not just "low price"

It requires multiple clicks and seems to depend on JavaScript for showing the price. A simple price list, with platform wise variations, would've been "customer friendly".

It's also GPLv3

Re: PgModeler – PostgreSQL Database Modeler

#26

Post by Cthulhu_ »

oneweekwonder wrote: post #15
kumarvvr wrote: post #10

Can anyone suggest any better alternatives, even paid ones? I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.

> it severely lacks in good tools. I'm happy with pgadmin4 3.1. Liked and used pgModeler for a while now. The pgwiki on tooling[0] contains thousands of tools. Effort is needed in cleaning it up. Also found a cleaner version on postgresql.org[1] > even paid ones? Heard good things about navicat. [0]: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS... [1]: https://www.postgresql.org/download/products/1-ad…

pgadmin's UX is pretty bad though, definitely on macos - lots of default OS specific keybinds that don't work, basic editing features that are missing, etc.

Re: PgModeler – PostgreSQL Database Modeler

#27

Post by sdnguyen90 »

kumarvvr wrote: post #10

Can anyone suggest any better alternatives, even paid ones? I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.

Postico is nice and simple if you're on OSX. Its very similar to Sequel Pro.

I like Datagrip as well but it has too many features for me since most of my queries are just SELECT's with maybe a JOIN.

Re: PgModeler – PostgreSQL Database Modeler

#29

Post by lkschubert8 »

sigi45 wrote: post #28

I still don't get it why the actual database tables are so far down the tree. I'm guessing its based on some pg internals but a tool doesn't has to follow it. Saw this in multiply tools for pgsql

I have wondered the same thing while using pgAdmin. Every other DB GUI tool has your tables in the top 2-3 levels of of the tree.

Re: PgModeler – PostgreSQL Database Modeler

#30

Post by gregn610 »

kumarvvr wrote: post #10

Can anyone suggest any better alternatives, even paid ones? I absolutely love PGSQL and it's a great software, but it severely lacks in good tools.

Toad Modeler for modelling. Handles defered constraints, inheritance, keys etc. Very scriptable tho the scripting IDE isn't great.
Post reply on HN