SQLite Forum

Table and index in separate files
We have a fairly widely distributed system with parts postrgresql and parts dbase.
Parts of dbase are updated in remote areas, some remain static for long periods, and some are updated from other locations.

The nice thing about some of the dbase parts are the separate index files which can contain all sorts of formulae to create sort of a pre-populated view, and which can be used stand alone, ie. like a index only 
database/table. This is very fast to change and distribute without remote areas/systems having to do re-indexing or other processing.

(I have a vfs with access to some of the dbase functionality.)

Thanks All!!