On Nov 25, 3:48 pm, Wolfgang Keller <[email protected]> wrote: > > I am the lone developer of db apps at a company of 350+ employees. > > Everything is done in MS Access 2010 and VBA. I'm frustrated with the > > limitations of this platform and have been considering switching to > > Python. > > > I've been experimenting with the language for a year or so, > > and feel comfortable with the basics. > > > I am concerned that I'll have a hard time replacing the access form > > and report designers. I've worked a little with TKinter, but it's a > > far cry from the GUI designer in Access. > > The list of Python frameworks for rapid development of desktop > (i.e. non-Web) database applications currently contains: > > using PyQt (& Sqlalchemy): > Pypapi:www.pypapi.org > Camelot:www.python-camelot.com > Qtalchemy:www.qtalchemy.org > > using PyGTK: > Sqlkit: sqlkit.argolinux.org (also uses Sqlalchemy) > Kiwi:www.async.com.br/projects/kiwi > > using wxPython: > Dabo:www.dabodev.com > Defis: sourceforge.net/projects/defis (Russian only) > GNUe:www.gnuenterprise.org > > Pypapi, Camelot, Sqlkit and Dabo seem to be the most active and best > documented/supported ones. > > > Finding a professional grade report designer looks like an even > > bigger challenge. > > LibreOffice is imho quite useful for database reporting. It comes with a > native (SDBC) driver for PostgreSQL and allows Python scripting. > LibreOffice Base can even be useful for CRUD GUIs. > > > I don't need to port any applications, but I will need to use the > > data (mdb/accede format), > > Don't. Put your data into an *actually* transaction-safe RDBMS (which > "Jet" is *not*), such as e.g. PostgreSQL. > > > design a variety of reports with multi-level groupings, and deliver > > them to many individual recipients via email. > > Sincerely, > > Wolfgang > >
Thanks to everyone who replied. The reporting question is the one that gives me the greatest concern when I think about switching to Python. I haven't seen a simple, powerful report writer like Access has, or Crystal Reports, in Python. Is generating XML / HTML a workable alternative? (In most cases, end users don't need to design reports.) Thanks again, Keith -- http://mail.python.org/mailman/listinfo/python-list
