On 1/13/11 8:04 AM, Stephen Russell wrote: > On Thu, Jan 13, 2011 at 9:22 AM, Paul McNett<[email protected]> wrote: > >> I use SQLite as the database for my big commercial app. This app just >> happens to be >> deployed to off-line single users around the world. The local SQLite database >> instances get and set some data on the MySQL mothership periodically, though >> (when >> online). >> >> It would have been heavyweight to require a local database server to be >> installed on >> all these remote machines just to get the application working. > ---------------------- > > That sounds appropriate and at the same time not the norm for any of us.
Oh, and just a sidenote: while we don't officially support it, I know of a handful of these users that have networked their sqlite database. Multiple workstations on their network successfully read/write to the single shared sqlite database. There haven't been any issues with this, which does surprise me a little. I'd imagine there will be scaling problems if they try to get dozens of computers connected to the same database at the same time though. 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.
