[wxpython-users] wxGrid + SQLite?

[Jerry LeVan]

On May 1, 2008, at 3:15 PM, Mark Erbaugh wrote:

> On Sun, 2008-04-27 at 01:39 +0200, Gilles wrote:
>>        For those of you using databases (SQLite, but it's more
>> general
>> question), how do use the wxGrid widget to display data from the DB,
>> let the user make changes, and then rewrite them to the DB?
>>
>> Can wxGrid behave like a DB-aware widget in VB or Delphi, or do we
>> need to manually SELECT data out of the DB, and UPDATE/INSERT data
>> back?
>
> I'm using PostgreSQL for a database.
>
> I much SELECT the data from the database and then UPDATE or INSERT to
> put it back. However, I've written a series of Python classes that do
> most of the work.  Since, I'm fluent in SQL ,I write the SELECT SQL
> statement, but the class knows how to write the data back.  It's  
> still a
> work in progress, though.

I wrote a wxPython program that can talk to Postgresql databases and  
uses
a grid to display selections from the database and also uses a grid
as a (very) simple editor for deleting/updating/adding records to the
database.

It comes with source code and some docs...You will need to add
a recent version of psycopg2 to your python library in order
to get the rascal to talk to postgresql.

http://homepage.mac.com/levanj/WxPython

Jerry