This is what I think you are asking: - You have a "main office" computer that holds the current information on "everything" - You have several different categories of users (technicians, accountant, ...) that require different subsets of the data - Each user has his own computer, that may be disconnected from the "main office", e.g. for "field work" - When a user's computer is "attached" to the "main office", it needs to be "synchronized".
If this is correct, then you require either a "distributed" DBMS that handles synchronization by itself, or you need to do some programming both inside and outside of SQLite. This may be appropriate for you: - As already stated, SQLite has just 1 file to hold all tables and indexes of the schema. Make this identical for all users. You can always leave the tables empty with just minimal overhead. - Downloading from "office" to "user" is accomplished by using ATTACH to make the "user" and "office" databases accessible. Just run the appropriate INSERT ... INTO statements. Check the authorizer callback to allow different users to access only the tables/fields that they are allowed to see. Limiting the rows requires an appropriate WHERE clause. - "Work" done by the user while offline needs to be saved in a worklog table. - Uploading the "work" of a user would copy the new worklog records into the "office" worklog table, just another INSERT ... INTO, to be processed by a dedicated sync application. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von John R. Sowden Gesendet: Donnerstag, 02. August 2018 19:12 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] Common index for multiple databases I have been reviewing sqlite for a couple of years, but still use foxpro. I have a question regarding an index issue. Currently I have several types of databases (in foxpro, one per file) that all point to an index of a common field, a customer account number. The databases are for accounting, technical, general info lookup, etc. \ I do not want these databases to all reside in one sqlite file. How do I index each database on this customer account number when each database and associated index are in separate files? Is this what seems to be referred to as an external file? I assume that I would have to reindex each database each time it is opened, since a record could have been edited, etc. tia, John _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
