On Tue, Sep 9, 2008 at 6:56 PM, Che M <[EMAIL PROTECTED]> 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 _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor
