I'd not worry about GUIs at first. For interfacing MySQL, the natural choice is
to use MySQLdb for this. If you use a binary distribution of MySQLdb, and it
doesn't include examples or docs, just download the source distribution of
MySQLdb from Sourceforge, as it includes example code and documentation.
As you're already familiar with database programming, you should be able to
learn using the Python DB-API pretty fast.
I'd tackle the GUI programming part later on.
Gerhard
--
mail: gerhard <at> bigfoot <dot> de registered Linux user #64239
web: http://www.cs.fhm.edu/~ifw00065/ OpenPGP public key id 86AB43C0
public key fingerprint: DEC1 1D02 5743 1159 CD20 A4B6 7B22 6575 86AB 43C0
reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b')))
You might find it interesting to look at Rekall, from theKompany, at
http://thekompany.com/products/rekall/
It is (will be) a cross-platform GUI database front-end.
Think of MS Access, then forget the horrible parts.
Rekall uses any of several DBMSs at the backend (currently MyQSL,
PostgreSQL and XBase). It does not yet have all the easy development
gizmos of Access, but the end-result for the user looks about as good.
Much of Rekall is written in Python, and the "code-behind-forms" is
Python scripts.
It's not free (about US$90 IIRC), is available now for Linux and Sharp
Zaurus (free demos), the Windows version is in Beta test (I'm on that
- currently suffering the usual Beta frustrations, but have seen
enough to get excited).
It's not very obvious from the website or downloaded demos that there
is a manual or Helpfiles, however if you D'L the Zaurus Demo and unzip
it, there is a manual in PDF.
--
John W Hall <wweexxss...@telusplanet.net>
Calgary, Alberta, Canada.
"Helping People Prosper in the Information Age"
> i do a lot of database programming especially with MySQL. I just starting
> learning python because many people told me that python is wonderful. I
> have read Guido's tutorial, but still being unable to write some codes for
> building MySQL GUI written in python.
You could download Kura and try to figure out the code in that -- but I
started working on it three or four years ago, and there's lots of cruft
in it. It's a combination of MySQLdb, an in-between-layer and PyQt.
Another option, quite an interesting one, would be to forego MySQLdb
completely, and to use the database classes that PyQt offer: you get
instant portability between OS's and databases, and a nice GUI query
designer in Qt Designer.
--
Boudewijn Rempt | http://www.valdyas.org
I think you should take a look at www.gnuenterprise.org - forms, reports
and designer. No point in doing work twice!
Regards
William MacLeod