SQlite FTS Support

ravink · Post by **ravink** » Thu 04 Aug 2011 03:09

Hi

I am considering upgrading from Ibdac to unidac as I require FTS support. I cannot find any information or examples on FTS on the Devart website and forum.

Is FTS available for Sqlite. Is it also available in Mysql.

Also is there any problems using Ibdac and Unidac at the same time. I am using Delphi 2007

Regards

Ravi K.
________
Colorado Medical Marijuana Dispensary

AlexP · Post by **AlexP** » Thu 04 Aug 2011 08:34

Hello,

The FTS mechanism is implemented on the server level, and if it is supported in the version of your servers, UniDAC will work with FTS for SQLite as well as for MySQL correctly.

We don't know about any problems with using UniDAC and IBDAC simultaneously on one IDE (on Delphi 2007 particularly). But for both the products to work correctly you need to have compatible versions of UniDAC and IBDAC, as they share basic libraries. The latest compatible versions are UniDAC 3.70.0.19 and IBDAC 3.60.0.24.

P.S. FTS3 and FTS4 are included into the SQLite core source code, they are not enabled by default.
So you should manually build SQLite3.dll from the source code with the DSQLITE_ENABLE_FTS3 directive enabled.
You can find more detailed information at http://www.sqlite.org/fts3.html

ravink · Post by **ravink** » Thu 04 Aug 2011 11:29

The FTS mechanism is implemented on the server level, and if it is supported in the version of your servers, UniDAC will work with FTS for SQLite as well as for MySQL correctly.

The application will not be on a server, but emebedded. It would be good to have an example.

So you should manually build SQLite3.dll from the source code with the DSQLITE_ENABLE_FTS3 directive enabled.

Is this done on Delphi?

Any possibility of some documentation on this. I really prefer to use Unidac.

Regards

Ravi K.
________