--- In sqlite@yahoogroups.com, "Dan Presley" <dpresley@...> wrote:
>
> I'm currently in the planning phase of a dedicated DBMS project to br written
in Python with both the pySQLite and wxPython libraries. Because I'm an old
RPGer (AD&D 1st and 2nd ed's) and a Linux user, I find there are no truly cross
platform character generation programs. All of the ones I've found are for
'Windoze'. I'm looking for pythonic examples of code using wxPython to write and
retrieve records from a SQLite database. I doing this project in Python, and
using an SQLite database for maximum portability between OSes. Any help would be
much appreciated. Thanks.
>
As far as I can remember, the Python API for SQLite is a pure Python library;
wxPython provides you just with the ability to construct user interfaces.

I've used both Python and the wxPython library to create a home-grown photo
database and search facility. I didn't need SQLite in the end, as my database is
currently small enough to fit in memory as Python data structures (instantiated
by reading XML files containing my photo data). It may be worth checking out
this option if your database is relatively small.

However, in retrospect I would throw the whole lot away and be tempted to use
Mozilla technology (i.e. XULRunner, XUL and Javascript) to write the front end.
There's a simple Mozilla-provided Javascript API to read and write to a SQLite
database. I'm now converting a Micro$oft Access database I wrote some time ago
into this technology, and apart from the lack of modules in Javascript (I'm
having to define everything as an object in order to organise the program
variable namespaces), it's been a fairly painless affair. Mozilla technology is
cross-platform; if Firefox runs on an OS, then so does the Mozilla technology.

Of course, if you need to stay with Python, then this post is of no help at all
:-) A good reason to stay with Python is that it's such a wonderful language
(IMHO).

Cheers,
Trev