Active6 years, 4 months ago
- Postgresql Client For Mac
- Torrent Client For Mac
- Best Postgresql Gui Mac Os
- Postgresql Gui Client
- Best Postgresql Client
votes
stackoverflow points me 'belongs-on-serverfault' on this, so crossposting.
Check out JackDB, it's a database client entirely in your web browser. There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.
I am frustrated of not having a good Linux GUI administration and development tool for PostgreSQL.
pgAdmin III is buggy and unusable piece of... hmm, software, compared to Windows-only PostgreSQL Maestro and EMS PostgreSQL manager.
phpPgaAmin does not looks promising.
EMS PostgreSQL manager can work under Wine, but such setup have a number of issues.
Requirements are:
- Table data editing and browsing for large tables (1M+), able to jump by FK or some master-slave editing, GUI filtering and so on.
- ER diagrams with in-place schema editing
- Schema editing and browsing with all useful GUI support
- Schema changes log to put into DB versioning (migrations script).
- Tabbed interface to be able to work with a number of tables and SQL queries at once.
And so on.
Any ideas?
user3370
closed as not constructive by Bryan, voretaq7Apr 11 '13 at 19:52
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
locked by HopelessN00bDec 5 '14 at 11:12
This question exists because it has historical significance, but it is not considered a good, on-topic question for this site so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. See the help center for guidance on writing a good question.
Read more about locked posts here.
8 Answers
votes
Try DBvisualizer from Minq Software ... http://www.minq.se/products/dbvis/
It's universal. It is Java based, and uses JDBC drivers to access just about any DB platform. It's a very mature product, and has commercial and freebie. I liked it so much, I splurged for the licensed copy!
netlinxmannetlinxman39211 gold badge44 silver badges1010 bronze badges
votes
I use Navicat. They have a lite version that you can download for free that supports not only postgres, but MySQL as well. You can do things like copy tables from one database to another which is not supported under pgadmin3. Plus, it's more visually appealing, which is nice.
JasonJason
votes
TOra might be worth looking at. It's technically 'Toolkit for Oracle', however it can also handle MySQL and PostgreSQL.
gharpergharper4,69144 gold badges2323 silver badges3333 bronze badges
votes
Squirrel-SQL is a Java based SQL client. Anything with JDBC is supported. The 3.x branch introduced a Tabbed UI.
jlduggerjldugger9,4491818 gold badges6767 silver badges120120 bronze badges
vote
Mergeant is a project to build an open source database app based on GNOME technology.
jlduggerjldugger9,4491818 gold badges6767 silver badges120120 bronze badges
vote
In the past I've used pgAccess, which wasn't flashy but it did the job. It looks like the last release was five years ago, so it might not be the right answer.
Bruce AldermanBruce Alderman
vote
Recommendations
(1) VMware Workstation, Windows, and EMS' toolkitsI really like EMS tools for Postgresql, and would virtualize in order to get access.
(2) Look at this list of Postgres GUI tools here
(3) A cross platform tool I used previously and liked was Aqua Data Studio
Postgresql Client For Mac
BrennanBrennan
vote
I use for linux free tool Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview It works on three OS: MAC, WIN, LIN. It works as with mySQL/mariaDB, so with PostgreSQL, SQLite and Valentina DB.
Anthoni DanielAnthoni Daniel
Active5 years, 3 months ago
I have recently started using PostgreSQL with my rails app.
Torrent Client For Mac
I was looking for a SQL GUI to the PostgreSQL database (for Mac).
Anything better than pgadmin3?
Max Vernon55.7k1313 gold badges121121 silver badges247247 bronze badges
Aram BhusalAram Bhusal
closed as off-topic by Paul White♦, Philᵀᴹ, Mark Storey-Smith, Aaron Bertrand♦Jun 2 '14 at 13:52
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope.' – Paul White, Philᵀᴹ, Mark Storey-Smith, Aaron Bertrand
4 Answers
Check the wiki page, many different tools available.
Best Postgresql Gui Mac Os
Frank HeikensFrank HeikensPostgresql Gui Client
18.1k11 gold badge2121 silver badges1919 bronze badges
Best Postgresql Client
I'm currently developing a Mac client for PostgreSQL named PG Commander. My goal is to make the best designed PostgreSQL client for the Mac -- it's not as full featured as pgAdmin, but it's a lot easier to use.
Jakob EggerJakob Egger
Check out JackDB, it's a database client entirely in your web browser.
There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.
Full disclosure: I'm the founder of JackDB.
sehropesehrope
I've been experimenting DbSchema (www.dbschema.com). I've been using the trial version and I'm pretty close to purchasing a license. While there are lots of tools for editing and submitting SQL requests (I like DbVisualizer) I like features in DbSchema. First, it has an interesting graphical database schema design tool for creating schemas and then applying them to a database. Second, it has a graphical way of querying tables. The 'graphical' part is selecting the join criteria, to use multiple tables. While I'm comfortable with SQL I'm also interested in a tool that will let others search tables without resorting to SQL.
I'm using it to manage a Postgres DB. Although I'm designing my schema from scratch DbSchema does 'import' schemas from existing databases.
I should add that I'm using DbSchema in Mavericks with Postgres running on the same laptop. DbSchema doesn't act like a native app. It's probably a Java client app--which is not a problem for me.
user39309user39309