I am using SQLite to add a database engine to a product I hope to sell. One thing that is desirable is to allow the customers to enhance the database for their specific needs. For example, they could add new tables to reflect their environment, and then design queries that look at both the standard and added tables.
However, since this all new to me I have two questions. If I offer an upgrade version with new tables how difficult will it be for the user to merge their database into the latest version? I will insure that any customer table names will not conflict with my table names. Would it make more sense to have the customers create a new database and then design their queries to deal with two databases?
