[Tutor] ways to sync databases with Python and SQLite?

[Kent Johnson]

On Tue, Sep 9, 2008 at 6:56 PM, Che M <pine508 at hotmail.com> wrote:
> Hi list,
>
> I have been trying to create a small desktop application with Python
> that uses a small SQLite database.  Recently I've got use of a 2nd computer
> (for my job) and have thought now about using the app on that one as well.
>
> I'd like to get ideas about how I could extend the application so that the
> databases on each computer could be kept "synchronized" (not sure that is
> the right term here); that is, each new change on either computer would
> be updated on the other computer(s), given a bit of help from the user.

Does it have to be SQLite? Many databases, but not SQLite, can run as
a server. If both computers are on the same network, an easy way to
keep them in sync would be for them both to share a singe database.
Both MySQL and PostgreSQL are free and work this way.

> (I realize a good way to do all of this is entirely as a web service, but
> that is beyond
> my abilities, and I am trying to just complete a desktop app before learning
> much of that)

Web applications aren't necessarily that hard. For example you can get
simple create/read/update/delete functionality pretty much for free
with Django (in the admin and databrowse apps).
http://www.djangobook.com/en/1.0/chapter06/
http://www.djangoproject.com/documentation/databrowse/
http://www.b-list.org/weblog/2007/nov/13/instant-sites/

You could continue to use the SQLite database, serve it from one
computer and view it from both. Of course I have no idea how complex
your app is and whether this will come close to meeting your needs...

Kent