Senior Member
Join Date: Jan 2005
Location: London, UK
|
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. Last edited by mooty : 2006-07-20 at 09:42. |
quote |
‽
|
You're very welcome. I often receive and benefit from the same kind of help from others, so it's only fair.
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
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...
|
quote |
Senior Member
|
I'm curious what you mean by Content Management App... Care to explain?
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
Quote:
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 |
|
quote |
‽
|
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.
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
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 :-) |
quote |
Member
|
First, let me say that I'm at work so I can't try out your app yet.
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. "Slow vehicle speeds with frequent stops would signal traffic congestion, for instance." uh... it could also signal that my Mom is at the wheel... |
quote |
‽
|
Yes, being able to plug additional databases into Core Data would be sweet.
|
quote |
Senior Member
|
From the testing I've done, I really like it. It's very helpful with my PHP development, so, thank you.
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
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... |
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
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. |
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
|
quote |
Lovable Bastard
Join Date: Dec 2005
Location: Boston-ish
|
*big one month bump* Are you still working on this? My other choices for a MySQL app are crappy or expensive.
|
quote |
‽
|
CocoaMySQL has picked up development again.
I'm sure Mooty will be delighted to see interest in his app, though. |
quote |
Lovable Bastard
Join Date: Dec 2005
Location: Boston-ish
|
Quote:
Last edited by Kraetos : 2006-08-28 at 19:21. |
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
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 :-) Last edited by mooty : 2006-08-29 at 03:50. |
quote |
‽
|
I've been using it with SSH tunnelling all along.
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
|
quote |
‽
|
ssh -NL 3306:localhost:3306 server-to-connect-to
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
ok, so once I connect using SSH to the server, the app will connect to the database fine ?
|
quote |
‽
|
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.
|
quote |
Senior Member
Join Date: Jan 2005
Location: London, UK
|
amazing! :-) I am so gonna code that into my app tonight
|
quote |
Posting Rules | Navigation |
|
Thread Tools | |
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cocoa vs. Carbon | azcoder | Programmer's Nook | 4 | 2006-01-14 08:16 |
MySQL database disabled, how to "restart" it? | drewprops | Programmer's Nook | 3 | 2005-12-31 19:17 |
File association to app was screwed.. what do you think? | Koodari | Genius Bar | 0 | 2005-09-17 05:10 |
Stone's new CoreImage App | BuonRotto | Third-Party Products | 25 | 2005-04-21 12:57 |
iPod app, and new iStore app needed | yoda_four | Speculation and Rumors | 6 | 2004-12-30 14:49 |