SQLite Forum: Table and index in separate files

Came accross

https://www.sqlite.org/withoutrowid.html

which I thinnk is a way SQLite can closely similate the separate db/index setup:

I'll create a SQLite database containing all `WITHOUT ROWID` tables representing the dbase calculated index entries:

For example:

CREATE TABLE IF NOT EXISTS Index01(
  DBaseFieldToIndex TEXT PRIMARY KEY,
  DBaseRecordNr INTEGER
) WITHOUT ROWID;
CREATE TABLE IF NOT EXISTS Index02(
  DBaseCalculatedFieldToIndex TEXT PRIMARY KEY,
  DBaseRecordNr INTEGER
) WITHOUT ROWID;

And populate them by selecting needed subsets from dbase files

I can actually use it to separate SQLite database and index files also!!

Philip
z