Kristyne McDaniel wrote: > I don't trust having all my data on someone else's machine.
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! Paul _______________________________________________ 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.
