Hacker News new | ask | show | jobs
by thejerz 4212 days ago
SequelPro is the gold standard. I've used it for years, and I love it. Unfortunately, like many developers, I'm slowly moving away from MySQL to PostgreSQL, and none GUI tools measure up. Instead of making YAPC (Yet Another Postgres Client), I wish a developer would just write a PostgreSQL adapter for SequelPro[1]. I'd happily contribute $50 or $100 towards a Bountysource.

https://github.com/sequelpro/sequelpro/issues/362

6 comments

Writing a PostgreSQL adapter for Sequel Pro is a good idea. I don't know how an adapter can fit into Sequel Pro's architecture though. I'll take a look at Sequel Pro's codebase and consider this approach. Any help would be appreciated!
Try Navicat (http://navicat.com – looks like they even have a Cyber Monday sale right now). Been using it for a couple of years now, and it's great (also "feels native", which is a must for me). There are many editions (I have "Premium Essentials", which was affordable and does all that I need).

As a bonus, it connects to all the major RDBMSes.

I used navicat for postgres briefly but was disappointed coming from sequel pro. I've moved to Valenta studio, which has a nice bonus of being free.
For anyone else fervently googling "valenta studio", it's actually Valentina Studio:

http://www.valentina-db.com/valentina-studio-overview

Can't emphasise this enough. SequelPro is absolutely the best part of using MySQL. I'd to would love to pitch in for a SequelPro-esque GUI tool for PostgreSQL
Another person here willing to contribute. SequelPro is really the best database client I've used, even though it might be considered 'spartan'/simple.

Panic (http://panic.com) gave the app a new icon, as they are using the source-code in their Coda application (http://panic.com/coda) MySQL client.

I had a look at doing this a while ago and ran away screaming, it's quite eye watering in terms of being agnostic. I started one myself but haven't had enough time to make the UI perfect at the moment. But I did make progress on a way to use many different types of DB's..for example

https://github.com/arbarlow/crate/blob/master/Crate/Classes/... https://github.com/arbarlow/crate/blob/master/Crate/Classes/...

Sadly it looks that SequelPro was never built as a platform for cross-database support. After glancing through the source the integration with MySQL seems really tight. Also SequelPro is OSX only which is a shame because I think that Sequel is better than most of the alternatives.

Hopefully Datazenit[0] will solve this and provide great cross-database, cross-platform support. Currently it is beta stage and supports MySQL/PostgreSQL, but other database systems are on the way.

[0] https://datazenit.com/

>Also SequelPro is OSX only which is a shame ...

I don't think so. Actually, IMO it is better than the alternatives exactly because it does not try to be everything for everyone but keeps focus.

That said, I really would like it to support other DB-engines like Postgres and SQLite too.