Aleksandar Petrovic wrote: > Hello folks. > > I need to write an desktop application to manage some data. And I was > thinking about packing it all together (some sort of "web server", > SQLite or plain CSV, perl and my code) in nice PAR (or similar) package. > Obviosly GUI would be handeled by their browser of choice ... > > Did anyone did something similar?
Yes. Michael Peters did this with "Smolder". It bundles Apache, SQLite and many Perl modules into a solution that is failry stand-alone and easy to install. (Although it doesn't go as far as PAR). Smolder is in turn built on "Matchstick", which is a framework to build applications in a similar manner. I would probably still consider "Matchstick" to be alpha quality, though. > Application itself would need to connect to main server from time to > time and sync the DB's - any sugestion on that would also be welcome. Two-way sync'ing is tricky, because there can be conflicts. In that case, you either have to blindly to decide one or the other is correct, or have a human look at the conflict to choose. I would either try to avoid 2-way sync'ing, or use a standard tool for this, like "unison", which I use for desktop/laptop sync'ing. However, unison wouldn't be helpful for binary database files. > I was thinking of adding a filed for time of last change of that record, > and then resend everything since the last time sync was done. If you are going to use a "real db", then they might also have third-party sync'ing tools to consider. For example there is "Slony" for PostgreSQL, but it is only one-way sync'ing. Mark --------------------------------------------------------------------- Web Archive: http://www.mail-archive.com/[email protected]/ http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2 To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
