<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2627" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>Hello,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>Like you, I use Python to build a client GUI accessing a database
server.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>I build the GUI with wxPython (<A
href="http://www.wxpython.org">www.wxpython.org</A>). I use the ODBC driver
built-in in Active State's Python distribution (<A
href="http://www.activestate.com/Products/ActivePython">www.activestate.com/Products/ActivePython</A>).
But this driver has some serious limitations and it can be hard to find
workarounds if you don't know very well SQL databases and ODBC drivers. It's why
you can also use mxODBC (<A
href="http://www.egenix.com/files/python/mxODBC.html">www.egenix.com/files/python/mxODBC.html</A>).
But you need to pay (a little) if you are a business.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>wxPython is packaged with an excellent documentation, an excellent
web site full of useful information, and a very simple but excellent tool to
build GUI (XRCed).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>I recommend you break your code in three tiers/modules : a module
to handle data, a module to handle views (data aware widgets and dialogs - think
to use Validators) and a module for your application itself.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>You can also build a true .exe for Windows if you need that (idem
for Mac).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>Sincerely,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff>Nicolas</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=470545116-29042005><FONT face=Garamond
color=#0000ff></FONT></SPAN> </DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Garamond size=2>--</FONT></DIV>
<DIV align=left><FONT face=Garamond size=2>Nicolas Grilly</FONT></DIV>
<DIV align=left><FONT face=Garamond size=2>Garden - Conseil et Etudes
CRM</FONT></DIV>
<DIV align=left><FONT face=Garamond size=2><FONT size=2><FONT
face=Garamond><SPAN class=342390000-09042004><SPAN
class=630083917-01052004>Conquête, fidélisation, data mining, tableaux de bord,
bases de données</SPAN></SPAN></FONT></FONT><FONT size=2><FONT
face=Garamond><SPAN><SPAN class=630083917-01052004>
marketing</SPAN></SPAN></FONT></FONT></FONT></DIV>
<DIV align=left><FONT face=Garamond size=2><FONT size=2><FONT
face=Garamond><SPAN><SPAN
class=630083917-01052004></SPAN></SPAN></FONT></FONT>Tel +33 1 45 72 48 78 - Fax
+33 1 56 72 21 32 - Mob +33 6 03 00 25 34 - </FONT><A
href="http://www.garden-paris.com/"><FONT face=Garamond
size=2>www.garden-paris.com</FONT></A><SPAN
class=342390000-09042004></DIV></SPAN>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=fr dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>De :</B> db-sig-bounces@python.org
[mailto:db-sig-bounces@python.org] <B>De la part de</B> rijish valoorthodi
rajan<BR><B>Envoyé :</B> vendredi 29 avril 2005 17:31<BR><B>À :</B>
db-sig@python.org<BR><B>Objet :</B> [DB-SIG] bigin with
python<BR></FONT><BR></DIV>
<DIV></DIV>
<P> <BR>i have been working on Visual studio, and now i want to try make my
application using PYTHON. I have to make a client-server application where a
data base application is to be run in the server and a VB like application
interface is to be run in the client. how should i approch the project if i am
to make the application using PYTHON ? </P><BR><BR><A
href="http://clients.rediff.com/signature/track_sig.asp" target=_blank><IMG
hspace=0
src="http://ads.rediff.com/RealMedia/ads/adstream_nx.cgi/www.rediffmail.com/inbox.htm@Bottom"
border=0 NOSEND="1"></A> </BODY></HTML>