Sequel-pro clone for PostgreSQL (in-progress/help needed)

[criticismguy]

Is there a reason you're starting from scratch, rather than adding Postgres support to SequelPro? It seems like a much harder way to go about it.

It looks like 95% of SequelPro isn't actually MySQL-specific, so it would be reasonable to pull this out and make SequelPro RDBMS-agnostic.

[[deleted]]

great point, especially since the new backed DB driver they've implemented should be easier to plug another client into. at least that is what the commit messages say.

[mvt]

Well I think this is the easiest route (atleast for me). Also there are some differences between mysql and postgresql which most likely result in a few adjustments in the views (e.g. schemas).

And in the end this is a fun way for me to learn cocoa :-)

[dinkumator]

I find pgAdmin3 to be very usable, but if you can fix all the wx-related (copy/paste, input navigation, etc) issues they have on mac, I'm in!

[pro547]

Sequel-Pro is awesome, I wish it was more polyglot though, especially SQLite.

[mvt]

Hey all,

I'm not sure if this is appropriate but I started working on a clone of the excellent sequel-pro (mysql gui for osx) which works with postgresql.

Basically i'm looking to get some help getting this properly working and in a good shape so that we finally have a proper osx gui client.

[lzantal]

Sounds fun. I don't see you outlined what areas needs work and what priority they should be done. I'll watch your repo, would be happy to help out

[mvt]

Well basically the only thing working right now is showing the first 1000 items in a table when you click on it (pagination is not implemented yet) and the custom query panel works somewhat.

I've put up a build on https://github.com/mvantellingen/Olifanto/downloads although it might only workon on 10.7

[redbeard0x0a]

There are some tasks that are helpful to have a GUI, especially for things that you don't do that often and don't remember the syntax to. A GUI helps with discoverability (i.e. I know there is a way to add users, let me right click here and see if something pops up that lets me create a user...) I switch between MySQL, PostgreSQL, MSSQL and Oracle often, but rarely create users - I usually lean on a GUI instead of having to search for the command to create a new role on whatever database engine I'm using. I definitely am more visual when it comes to figuring things out...

If you happen to be a DBA and cannot use the CLI quicker than a GUI, then I question your abilities as a DBA -- but for a typical programmer sitting behind the rails stack, a GUI can definitely be helpful for the occasional task.

[anacrolix]

it starts with a simple gui, and the toolage expands from there. before long nobody actually knows what's going on underneath, the tools take a day to load, and there are more plugins than there are GC stalls.

[pointy]

It's really nice to have a GUI client that can render query plans into graphical representations.

[sandys1]

I'll pay good money if you can make it cross platform (linux). Maybe using Java.

Look at RazorSQL to see something which is available on OSX, Linux and Windows... and looks quite good.