|
Home > Archive > MySQL ODBC Connector > January 2006 > GUI (linux X based or web based) for mysql
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
GUI (linux X based or web based) for mysql
|
|
| Dotan Cohen 2005-12-16, 7:23 am |
| SSBrZWVwIGEgbG90IG9m
IHBlcnNvbmFsIGluZm9y
bWF0aW9uIGluIGEgTXlT
UUwgZGF0YWJhc2Uu
IEkgaGF2ZSBhIGZldwpx
dWVyeXMgcHJlbWFkZSBm
b3IgdGhlIHdpZmUgdG8g
dXNlLCBidXQgd2Ug
aGF2ZSBnb3R0ZW4gdG8g
dGhlIHBvaW50CndoZXJl
IHdlIG5lZWQgYSBzb2x1
dGlvbiBmb3IgaGVy
IHRvIGJlIGFibGUgdG8g
cnVuIGhlciBvd24gcXVl
cmllcy4KU2hlIGlzIE5P
VCBhYm91dCB0byBs
ZWFybiBTUUwsIGFuZCBt
eVBIUGFkbWluIGlzIGEg
bGl0dGxlIHRvbwpjb21w
aWNhdGVkLiBJIGxv
b2tlZCBhdCBhbiBBY2Nl
c3MgaW5zdGFsbGF0aW9u
IHRoZSBvdGhlciBkYXkg
YW5kIGl0CnNlZW1l
ZCB0byBiZSBqdXN0IHdo
YXQgd2UgbmVlZC0gYSBH
VUkgZm9yIG5vbi1wcm9n
cmFtbWVycyB0byB1
c2UgYQpkYXRhYmFzZS4g
SXMgdGhlcmUgYW55IHN1
Y2ggYmVhc3QgZm9yIE15
U1FMPyBBbnRoaW5n
IHRoYXQgd2lsbCBydW4g
b24KRmVkb3JhIENvcmUg
NCB3b3VsZCBiZSBncmVh
dC4gT3IgZXZlbiBh
IHdlYi1iYXNlZCBzb2x1
dGlvbiB3b3VsZCBiZQpm
aW5lLSBJIGRvIGhhdmUg
YXBhY2hlIG9uIGxv
Y2FsaG9zdC4KClRoYW5r
IHlvdS4KCkRvdGFuIENv
aGVuCmh0dHA6Ly90ZWNo
bm9sb2d5LXNsZXV0
aC5jb20vcXVlc3Rpb24v
d2h5X2FyZV9pbnRlcm5l
dF9ncmVldGluZ19jYXJk
c19kYW5nZXJvdXMu
aHRtbAo=
| |
| Greg Maruszeczka 2005-12-16, 9:23 am |
| 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.
>
Check out Open Office 2.0 and its Base app, available in windows and
*nix versions. I think it can use MySQL through either ODBC or JDBC
connectors, though I haven't played with it much (yet) to evaluate it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Daniel Kasak 2005-12-18, 8:23 pm |
| 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: dkasak@nusconsulting
.com.au
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
| |
| Mechtilde Stehmann 2006-01-01, 7:23 am |
| Hello,
Dotan Cohen schrieb:
> 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.
You can use OpenOffice.org 2.0 via ODBC or JDBC and you can use a GUI
nearly like Access under Linux.
Mechtilde
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw
|
|
|
|
|