Re: [sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread drh
Russell Leighton <[EMAIL PROTECTED]> wrote: > Given you can attach multiple database files in sqlite, perhaps it could > be extended such that: > > * When you name an index, you optionally prepend the database name > which can be in another currently attached db > * You attached to

Re: [sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread Lindsay
Russell Leighton wrote: > > Big distruptive code change? Also more opportunites for things to go wrong with mismatched index/db files Also no longer can copy/move db as a single file -- Lindsay

[sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread Russell Leighton
Given you can attach multiple database files in sqlite, perhaps it could be extended such that: * When you name an index, you optionally prepend the database name which can be in another currently attached db * You attached to multiple db files that have cross references as: