How can I enable FTS5 in SQLite?

[waheed]

I'm using UniDAC 7.4, but I don't see where I enable FTS5 for SQLite. FTS5 is included in v.3.9 but not enabled by default except when I use "--enable-fts5" option when running the configure script. https://sqlite.org/fts5.html
But where can I enable it in UniConnection?
I'm using DirectMode=True

I found this in the documentation:

Code: Select all

UniConnection.ExecSQL('SELECT load_extension(''C:\ext.dll'', ''sqlite3_ext_init'');');

so I replaced it by:

Code: Select all

UniConnection1.ExecSQL('SELECT load_extension(''C:\sqlite\sqlite3.exe'', ''sqlite3_fts5_init'');');

But still it didn't work, it gave me (The specified procedure could not be found) error

[MaximG]

Please follow the steps to work with FTS5 and UniDAC in Direct Mode:

1. Compile Loadable Extension with FTS5 support as described in the docs: https://www.sqlite.org/loadext.html. On Windows, you’ll get a DLL file – you can name it fts5.dll, for example.
2. Enable support for Loadable Extension : UniConnection.SpecificOptions.Values['EnableLoadExtension'] := 'True';
3. Set the path to fts5.dll when downloading the extension (for example, to C:\fts5.dll): UniConnection.ExecSQL('SELECT load_extension(''C:\fts5.dll'', ''sqlite3_fts5_init'');');

The next version of UniDAC will support FTS5 in Direct Mode by default.

[waheed]

"The next version of UniDAC will support FTS5 in Direct Mode by default."

Does the new version support it?

[MaximG]

We were going to support FTS5 in Direct Mode in the latest version of UniDAC, however, we hadn't been able to ensure stable operation in all supported modes. For that reason, we haven't added this capability in the latest version of our driver.
We'll continue to work on adding support for FTS5 and we'll update you on the progress.

[waheed]

Anxiously waiting for it. Thanks

Meanwhile, if there is any one out there able to create a SQLite version with built-in FTS5 support enabled so I can connect to it in indirect mode, I will greatly appreciate it.

[MaximG]

We can prepare and send you a nightly build of our product with support for FTS5. What are your primary platforms (Win32, Win64, MacOS etc.)? Please send us your license key and IDE version number via e-support form https://www.devart.com/company/contactform.html

[waheed]

Has FTS5 in UniDAC for SQLite support implemented yet as you mentioned about a year ago?

[MaximG]

We're still working on adding native support for FTS5, without any extensions. Hopefully we'll release it in the next version of our components.

[Christoph]

"The next version of UniDAC will support FTS5 in Direct Mode by default"

As of version 9.1.1 for RAD Studio 10.4 FTS5 is still not available
Unfortunately, I haven't been able to load the extension myself.

[waheed]

Another year and another and another.

[Christoph]

Ok, looks like we are not there yet:-(

In the meantime, please provide a simple cookbook on how to create fts5.dll for Windows 10 32bit and 64 bit.
Is there perhaps a link available where I can download fts5.dll.
Perhaps, devart could provide it? :-)

[MaximG]

We have made the necessary changes to support FTS5 and are currently testing the driver for each supported platform.
We'll update you on the progress.