Ed Leafe wrote: > BTW, I always did my VFP apps with a MySQL backend for the main > data, but kept a lot of local stuff (config settings, etc.) in DBFs, > since that was much handier. You can do the same with SQLite: use a > server for the main backend, but use SQLite to store local stuff.
I agree. I think SQLite shines for single-user things, or even shared situations where the users understand that they are merely sharing a file on a fileserver. I'm thinking of all kinds of off-the-shelf apps such as Quicken, iTunes, etc. They would all benefit from switching to SQLite I think. I'm using SQLite for my current project, which is a relatively simple app distributed to a bunch of customers where each customer has their own database, and is presumed to be single-user/single-computer. However, for the administration program run by my client, that data is in MySQL because multiple employees need concurrent access. Included in the MySQL tables are master data that periodically gets converted to sqlite and propagated out to the customers. So, best tool for the job. -- pkm ~ http://paulmcnett.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
