9 ms·
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 t
by goes_to_11 13y ago
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/ http://www.heidisql.com/
- skyebook 13y agopgAdmin III, it does damn near everything you could need. http://www.pgadmin.org http://www.pgadmin.org
- obsession 13y agoHave 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.)
- NathanRice 13y agoThis sort of thing is really easy to do from a psql console; I don't think that should be a major point against pgadmin.
- jordanthoms 13y agoPGadmin 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.
- jacques_chester 13y agoIt's a common mistake. Oracle's SQLDeveloper app does the same thing.
- skyebook 13y agoI 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
- jeffdavis 13y agohttp://www.heidisql.com/forum.php?t=7025 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_PostgreSQL_GUI_Tools http://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQ... http://www.postgresonline.com/journal/index.php?/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html http://www.postgresonline.com/journal/index.php?/archives/13...
- JonnieCache 13y agoIt costs monies, but Navicat is an absolute treat. http://www.navicat.com/products/navicat-for-postgresql http://www.navicat.com/products/navicat-for-postgresql
- _JamesA_ 13y agoDBVisualizer is an incredible cross-platform and cross-database tool that may fit your requirements. http://www.dbvis.com http://www.dbvis.com
- johnyzee 13y agoI am building a (free) web interface for Postgres that aims to be fun and easy to use: http://www.teampostgresql.com 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/ http://teampostgresql.herokuapp.com/ Happy to answer any questions.
- afiler 13y agoIs it open-source?
- johnyzee 13y agoNot currently, but that may change.
- gdulli 13y agoIt 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))
- mmsimanga 13y agoTwo 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://squirrel-sql.sourceforge.net/ http://www.sql-workbench.net/ http://www.sql-workbench.net/
- Torgo 13y agoTora 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.
- redstripe 13y agoNot 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 http://fishcodelib.com/Database.htm