Pyton/Linux/Database/Gui programming

[bgeddy]

Hi to all. I have been spending a lot of time trying out various combinations of tools/libraries etc with a view to developing applications for Linux (KDE so preferably QT based) with a Mysql backend. So far I have looked at QTDesigner with pyuic, dabo, wxwidgets, eclipse with pydev and even OpenBase/Kexi as a way of creating a development environment of database applications on the Linux desktop addressing a 'client server' (presently MySQL) backend. This was very, (well relatively), easy to do under Windows as I am from a Foxpro/Access/C background. However I am having trouble finding the combination of tools that will address this model with Linux. I am new to Python but not new to coding having over 20 years experience producing code stemming from the days of Dos/CPM through windows through Unix and for the past 18 months I have been concentrating on Linux. I was just wondering what you guys would recommend as a developmeny environment for developing database apps with python, a gui front end, a "client/server" database backend under Linux ? Any ideas are much appreciated.

[bartonc]

Hi to all. I have been spending a lot of time trying out various combinations of tools/libraries etc with a view to developing applications for Linux (KDE so preferably QT based) with a Mysql backend. So far I have looked at QTDesigner with pyuic, dabo, wxwidgets, eclipse with pydev and even OpenBase/Kexi as a way of creating a development environment of database applications on the Linux desktop addressing a 'client server' (presently MySQL) backend. This was very, (well relatively), easy to do under Windows as I am from a Foxpro/Access/C background. However I am having trouble finding the combination of tools that will address this model with Linux. I am new to Python but not new to coding having over 20 years experience producing code stemming from the days of Dos/CPM through windows through Unix and for the past 18 months I have been concentrating on Linux. I was just wondering what you guys would recommend as a developmeny environment for developing database apps with python, a gui front end, a "client/server" database backend under Linux ? Any ideas are much appreciated.

My favorite combination:
wxPython framework
Boa Constructor IDE (built from wxPython and has a nice designer window)
MySQL backend with ODBC connector. (unfortunately, the ODBC that I'm using -eGenix mxODBC- went commercial and now costs some $)

[bgeddy]

Hey thanks for the quick reply. I have heard of Boa but not looked into it. I shall now.

I have not had much success with my trials of Unix ODBC and ended up using JDBC instead - however its early days yet!

Shame your preferred solution has gone commercial but I suppose the company now offer support if needed for their product.

Anyway - thanks again for the information. Bye for now .....

[bartonc]

Hey thanks for the quick reply. I have heard of Boa but not looked into it. I shall now.

I have not had much success with my trials of Unix ODBC and ended up using JDBC instead - however its early days yet!

Shame your preferred solution has gone commercial but I suppose the company now offer support if needed for their product.

Anyway - thanks again for the information. Bye for now .....

As an alternative to ODBC, there's MySQL for Python. I was using it (and may switch back) but updates for 2.5 were slow to be released and support for Windows is very limited. It should be working well now, though (especially on your platform).

[bartonc]

My favorite combination:
wxPython framework
Boa Constructor IDE (built from wxPython and has a nice designer window)
MySQL backend with ODBC connector. (unfortunately, the ODBC that I'm using -eGenix mxODBC- went commercial and now costs some $)

Great news on this front!!!
PyODBC looks to be the Python ODBC interface of the future. 2.4 and 2.5 are both currently supported!