On Thu, 2007-07-05 at 21:08 -0700, Dave Brown wrote: > I am considering using FTS for a new feature. My question is: > > - If I use fts1 (or fts2) now, and then a new version of fts comes out which > is not backwards compatible, will I at least be able to upgrade users by > simply deleting the old FTS table and re-building it using the new FTS > system? > > In other words, my users will have a database file built with fts1, then my > new upgraded code (which contains sqlite with fts3, for example) will try to > upgrade them by deleting the fts1 table, and creating a new table. > > Will the delete of the old table at least be guaranteed to work?
fts1 and fts2 are separate extensions that happen to do similar things. You can load them both at the same time and have a single database connection access both fts1 and fts2 tables. The same should be true with fts3. Dan. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
