MySQL Cocoa App - Have a go :-)

[mooty]

Hi All,

I'm currently working on a new content management app. The first step is to get some functionality with MySQL, which I've just completed. I'd love it if you would try it out, and give me any feedback on problems and requests.

http://web.mac.com/mootymoots

The app currently only accesses MySQL databases and allows table lookups with simple searching. Editing will be next...

Thanks to Chucker for all the guidance and testing. Either leave feedback here or on my dodgy 30 minute iWeb above :)

Thanks all.

[chucker]

You're very welcome. I often receive and benefit from the same kind of help from others, so it's only fair. :)

[mooty]

i've been working on the speed issue with large tables and now added a pref pane to the app so you can set a maximum amount of rows to return. Works much better, but I need to build in some way so you can see the next say 200 rows...

[rollercoaster375]

I'm curious what you mean by Content Management App... Care to explain?

[mooty]

I'm curious what you mean by Content Management App... Care to explain?

Well, about 18 months ago i created a CMS using MySQL and PHP for Recruitment agencies. It allowed them to manage their office-based data, as-well as sharing certain elements of that data with their websites, for example - vacancy information.

I want to do something simular, but more generic. A way to manage content on a database driven website, but managed locally by a desktop app, rather than web-forms. Main reason being I can control alot more, and more user friendly... For example, adding/uploading images to a site could be a drag and drop, instead of browsing... stuff like that.

I am not trying to re-invent iWeb, the app wont be able to design templates.... yet :-) hehe

[chucker]

I think the main issue with what you're working on is that you connect and interact directly with the MySQL server. That's not a situation you'll frequently find.

[mooty]

definately!! The app is not there to do that. In its current form its mearly a preview of MySQL direct interaction, but in the future you wouldn't interact with it so blatantly.

However, the current functionality could be a handy tool for administrators if necessary, and it helps me learn :-)

[Mr Beardsley]

First, let me say that I'm at work so I can't try out your app yet. :o

Second, from what you have been talking about, it would seem a good Cocoa/Objective-C ODBC implementation is needed. This used to be covered by Apple's EO Framework, but unfortunately they ported it all to Java and dropped support for Objective-C. Bummer.

One of the things I'm really hoping Leopard includes is an update to CoreData that adds support for third party relational databases in addition to SQLite, XML, and Binary. It would seem that they are heading this direction, but we'll just have to wait and see.

[chucker]

Yes, being able to plug additional databases into Core Data would be sweet.

[rollercoaster375]

From the testing I've done, I really like it. It's very helpful with my PHP development, so, thank you.

[mooty]

great Thanks!! :)

I have added another version yesterday, and hope to release another today with Table Optimization built in, row deletion, and possibly editing if i get that far...

[mooty]

New version up!

Version 0.1a 220706
-------------------
- Added Optimize Table button and functionality
- Added Empty Table button and functionality
- Added Delete Row functionality by clicking icon in row
- Added Dynamic window resize for better table viewing (via button)

Seems stable this end... would love any feedback. Thx.

http://web.mac.com/mootymoots/iWeb/MootyMoots/Blog/99178B2F-BFCB-41D6-B405-B829F20CFA74_files/Picture%202.png

[mooty]

Hi Guys,

New version up today. Also moved my blog to http://mootymoots.me.uk

http://mootymoots.me.uk/images/280706.png

[Kraetos]

*big one month bump* Are you still working on this? My other choices for a MySQL app are crappy or expensive.

[chucker]

CocoaMySQL has picked up development again (http://cocoamysql.sourceforge.net/beta.php).

I'm sure Mooty will be delighted to see interest in his app, though. :)

[Kraetos]

CocoaMySQL has picked up development again (http://cocoamysql.sourceforge.net/beta.php).

I'm sure Mooty will be delighted to see interest in his app, though. :)

Sweet! Thanks. YourSQL wasn't really doin' it for me.

[mooty]

Yea CocoaMySQL is good, I would use that if I were you.

My app development has stalled a bit, whilst I try to learn a bit more - plus, at the end of it all, it won't be a MySQL manager like the aformentioned CocoaMySQL - I hope to have an app which uses MySQL in a different way ;)

The latest version is here http://mootymoots.me.uk/downloads, version 0.1a 300706

More importantly with CocoaMySQL, they are going to implement SSH tunnelling, which is great news as this was a problem I found when trying to connect up to MySQL databases on some external hosts, that being, you can't connect :-)

[chucker]

I've been using it with SSH tunnelling all along.

[mooty]

I've been using it with SSH tunnelling all along.

Using the app? How exactly, i'd like to use my app with SSH tunnelling...

[chucker]

ssh -NL 3306:localhost:3306 server-to-connect-to

;)

[mooty]

ok, so once I connect using SSH to the server, the app will connect to the database fine ?

[chucker]

You set up the tunnel like that in the command-line, and then in your MySQL app, you connect to 127.0.0.1, port 3306.

[mooty]

amazing! :-) I am so gonna code that into my app tonight