Example of Database Interaction

wxPython Users
1

if you use MySQL, try this address:

Writing MySQL Scripts with Python DB-API

Paul
DuBois

at paul@kitebird.com

···

2007/8/22, Peter Decker pydecker@gmail.com:

On 8/22/07, Geoff Skerrett Geoff@teammsa.com wrote:

Can anyone point me to an example of an application the has interaction with
a dbase. I checked the wiki and didn’t really find anything that I am

looking for.

  • specifically looking for apps where dealing with records and how changes
    to the records in an edit window are updated in the database and then
    reflected back in the UI. Picture a wx.ListCtrl in a pane at the top of a
    window, with pane below that allows field editing of a hightlighted record.

I have a developed a “homegrown” version of a the above using a wx.ListCtrl
,
but I was wondering how other people have solved the problem of updates from
the field editing getting back to the DB and then reflected in the record
display.

FWIW I typically using SQLite and PostgreSQL

Rather than re-invent the wheel, you should look at Dabo
(http://dabodev.com). They have a complete 3-tier framework for
creating database applications, and I know that they support

Postgresql and sqlite, among other backends.

–

p.d.

To unsubscribe, e-mail:
wxPython-users-unsubscribe@lists.wxwidgets.org
For additional commands, e-mail: wxPython-users-help@lists.wxwidgets.org

2

Raffaello Barella wrote:

if you use MySQL, try this address:

I think this is the address you were looking for:

-Chris

···

--
Christopher Barker, Ph.D.
Oceanographer

Emergency Response Division
NOAA/NOS/OR&R (206) 526-6959 voice
7600 Sand Point Way NE (206) 526-6329 fax
Seattle, WA 98115 (206) 526-6317 main reception

Chris.Barker@noaa.gov

3

Sorry, but in my former message something seems to have fallen out of my keyboard. What I wanted to write is:
If the databases you are using are MySQL, you might find useful the article “Writing MySQL scripts wit Python DB-API” by Paul DuBois. Short, clear and to the point.

Give the title to Google and it will find it.

···

2007/8/22, Christopher Barker Chris.Barker@noaa.gov:

Raffaello Barella wrote:

if you use MySQL, try this address:

I think this is the address you were looking for:

http://www.kitebird.com/articles/pydbapi.html

-Chris

–
Christopher Barker, Ph.D.
Oceanographer

Emergency Response Division
NOAA/NOS/OR&R (206) 526-6959 voice
7600 Sand Point Way NE (206) 526-6329 fax

Seattle, WA 98115 (206) 526-6317 main reception

Chris.Barker@noaa.gov

To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwidgets.org
For additional commands, e-mail: wxPython-users-help@lists.wxwidgets.org