Paul McNett wrote: > Here, here! > > I'm currently building into my framework a way to merge multiple "copies" of the same > sqlite database. So, the user has a local db to connect to (no need for internet > access). But they could upsize to a server db (MySQL or PostgreSQL) which could be > running anywhere (my server, their server). But they still can run offline using that > sqlite db, but when connected, the local db syncs with the remote db, and vice-versa. > > Or, could be that the user had the app running on two workstations, and now they want > to consolidate the data to one. Merge the two sqlite databases. > > Obviously, there will be user interaction required to sort out at least some > conflicts, but in the most common case of multiple users working on different > customers or invoices, it shouldn't be that big of a deal. > > VFP's OFFLINE feature was IMO very forward thinking, but the implementation was > pretty rough around the edges. I did have it working in one of my apps back in VFP5 > days, though, and working fairly well. This was so the owner could work comfortably > at home and only have to suffer the dialup slowness when it was time to upload the > offline changes to the master database at the business site. > > > SQLite is a great db to work with in single-user type applications. Now I hope to > make it great for using in partially-disconnected multi-user type applications, too!
How are you handling the generation of the primary keys? Are you using GUIDs? I can't see this scenario working any other way without great complexity in sync code. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
