By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,332 Members | 1,130 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,332 IT Pros & Developers. It's quick & easy.

Pyton/Linux/Database/Gui programming

bgeddy
P: 16
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.
Aug 21 '07 #1
Share this Question
Share on Google+
4 Replies

bartonc
Expert 5K+
P: 6,596
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 $)
Aug 22 '07 #2

bgeddy
P: 16
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 .....
Aug 22 '07 #3

bartonc
Expert 5K+
P: 6,596
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).
Aug 22 '07 #4

bartonc
Expert 5K+
P: 6,596
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!
Oct 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.