Dotan Cohen wrote:
I keep a lot of personal information in a MySQL database. I have a few querys premade for the wife to use, but we have gotten to the point where we need a solution for her to be able to run her own queries. She is NOT about to learn SQL, and myPHPadmin is a little too compicated. I looked at an Access installation the other day and it seemed to be just what we need- a GUI for non-programmers to use a database. Is there any such beast for MySQL? Anthing that will run on Fedora Core 4 would be great. Or even a web-based solution would be fine- I do have apache on localhost.
I have a number of open-source Perl projects that may help you out, at: http://entropy.homelinux.org/axis_not_evil
They're more targetted at developers than end-users at the moment ... I have plans ...
Anyway, with minimal effort you can get a very nice looking Gtk2-based GUI going with the help of Glade to make your interface, and a couple of lines of Perl code to connect your database to your GUI. The current release of Gtk2::Ex::DBI ( you just motivated me to make the next release, which I'd been procrastinating over for ages ) has a built-in search dialog, that you can trigger in 2 ways - by right-clicking in a field in the GUI and selecting 'find' from the context-sensitive menu, or by putting a button on your form and connecting it to the find_dialog() method of Gtk2::Ex::DBI. This will give you a dialog that lets you add criteria that gets appended to the 'where' clause of the query ... ie it doesn't do a slow search on every record ( like Access ), but lets you send your criteria to the database for rapid results.
Admittedly, the documentation is a little sparse, but I'm working on a nice demo application that shows off all the features of the 3 modules. Hopefully over Christmas I'll get time to finish it off.
Oh yeah ... did I mention that it's all cross-platform goodness? :) I've tested on Linux, Windows 2000 and OS-X. You will of course need to install Gtk2 for the last 2, but it's not that hard - at least on Windows.
-- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
