>Take a look at
www.dabodev.com. Dabo does exactly what you are looking for - it uses sqlite as the cursor and almost any database as the storage.
When I looked at Dabo they used dicts from records in lists, but went back to Sqlite for the manipulation via SQL, which while efficient enough for small amounts of data is not a sound architecture to scale on. Do they have a local Sqlite in-between layer for remote data similar to a remote view or vfp cursor generated by a cursoradapter ?
@Daniel
The architecture you describe sounds very similar to the things I targeted, even down to speeding some things up via Cython.
The whole thing did not materialize because
a) Python was an uphill battle compared to java when discussing with large clients having own IT centers
b) the mobile story of Python back then was somewhere between lousy and checkered
If it had occurred, I would have written something similar to a local cursor/cursoradapter layer for Dabo utilizing Sqlite, using the Dabo list of dicts only for list based GUI elements but munging data locally via Sqlite similar to cursors in vfp.
>
>The stable version is a little old at this point but we should have a newer version that uses wxPython 3.x in the near future. The wxPython 3.x version works on Linux and Mac currently (if that is a platform you are considering). The Windows version is much closer as of two days ago. You can at least read the code and see if that will help you on your project.
>
>
>Johnf