[wxpython-users] wxGrid + SQLite?

[Mark Erbaugh]

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.