Hacker News Reader

Comment by goes_to_11 | Hacker News Reader

Are there any PostgreSQL administration tools like HeidiSQL (which is for MySQL)[1]? Seriously, this piece of software is so feature-rich and polished and fun to work with, it makes me choose MySQL over PostgreSQL if the MySQL features fit my needs. Indeed, I know pgAdmin, but some features are rather clunky to use and it doesn't really look that actively developed.

[1]: http://www.heidisql.com/

View on HN

I am building a (free) web interface for Postgres that aims to be fun and easy to use: http://www.teampostgresql.com

It has a lot of user friendly features particularly for data viewing and navigation, such as clicking through foreign key references to referenced rows, and the other way, looking up rows that reference this one, plus a lot of other stuff that I missed from other admin packages.

There's a demo here: http://teampostgresql.herokuapp.com/

Happy to answer any questions.

Is it open-source?

Not currently, but that may change.

It looks promising. I wanted to try it out but I got this error when it was reading the metadata on my database:

"Encountered more 0 entries in index columns list than there were expressions in 'indexprs' expressions list for index 'activity_emd5_00_expr_activity_type_expr1_idx'. Current count = '1', parsed expressions = 1, 'indexprs' value='({OPEXPR :opno 3963 :opfuncid 3948 :opresulttype 25 :opretset false :opcollid 100 :inputcollid 100 :args ({VAR :varno 1 :varattno 6 :vartype 114 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 6 :location 43} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 60 :constvalue 12 [ 48 0 0 0 118 101 114 116 105 99 97 108 ]}) :location 57} {OPEXPR :opno 3963 :opfuncid 3948 :opresulttype 25 :opretset false :opcollid 100 :inputcollid 100 :args ({VAR :varno 1 :varattno 5 :vartype 114 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 5 :location 89} {CONST :consttype 25 :consttypmod -1 :constcollid 100 :constlen -1 :constbyval false :constisnull false :location 108 :constvalue 6 [ 24 0 0 0 105 100 ]}) :location 105})'"

For your reference, here's that index:

"activity_emd5_00_expr_activity_type_expr1_idx" UNIQUE, btree ((source_details ->> 'vertical'::text), activity_type, (activity_details ->> 'id'::text))

Thank you, I will look into this. What is your PG version if I may ask?

9.3beta2

Hey, you might not get this but the issue you reported is now fixed (failure to resolve segmented index expressions after some changes to PG system functions). Thanks for reporting this and let me know if I can help with anything.

It costs monies, but Navicat is an absolute treat.

http://www.navicat.com/products/navicat-for-postgresql

DBVisualizer is an incredible cross-platform and cross-database tool that may fit your requirements. http://www.dbvis.com

+1,000,00

Am I just missing something obvious or does that product not offer any way to actually interact with and/or design a database other than raw SQL? Like, how do I add a new table, or change a column in an existing table?

Some advanced functionality is reserved for the Pro version. http://www.dbvis.com/features/feature-list/

I think that qualifies as me missing something obvious. Thanks.

http://www.heidisql.com/forum.php?t=7025

It looks like the author is entertaining the idea of postgres support (if you read further down the thread). A timely donation might make it happen.

Everyone has their own preferences for administration tools, so it's hard to find a one-to-one replacement. You might find something at one of these places though:

http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ... http://www.postgresonline.com/journal/index.php?/archives/13...

pgAdmin III, it does damn near everything you could need. http://www.pgadmin.org

Have you used pgAdmin? It certainly does everything but it's user interface is too horrific for any simple tasks (like viewing rows or filtering by column etc.)

This sort of thing is really easy to do from a psql console; I don't think that should be a major point against pgadmin.

PGadmin also crashes often, and blocks on many database operations (eg modifying schema, adding indexes etc). How you can write a database GUI and make such a basic mistake as doing DB operations on the UI thread is beyond me.

It's a common mistake. Oracle's SQLDeveloper app does the same thing.

I wouldn't recommend it if I haven't used it.

Sure, the UI is ugly and it blocks on DB ops, but it works. Crashes I haven't had much of tbh

Two open source front ends I use are SQuirreL SQL and SQL Workbench/J. I agree HeidiSQL is one neat piece of software! Lets donate and have the developer add PostgreSQL support. http://squirrel-sql.sourceforge.net/ http://www.sql-workbench.net/

Not sure what HeidiSQL supports but Database.net [1] has what in my mind are the most important features: a tabbed SQL editor and field name completion.

[1]: http://fishcodelib.com/Database.htm

Tora looks similar to this, it's more of a workalike to TOAD for Oracle. I like it a lot because it's less clunky than pgadmin. But it still has a few bugs.

Reply on news.ycombinator.com