SQLite & SQL Server Compact Toolbox extension for Visual Studio 2022 - scripting SQlite database with FTS5 error

[alexey-leonovich]

SQLite & SQL Server Compact Toolbox extension for Visual Studio 2022 - scripting SQlite database with FTS5 error

[alexey-leonovich]

I found this: https://sqlite.org/forum/info/4cf36abaf7011e76cbb73e07591d4a0cae6bcc9b7c2fe5e548f6fed02710e503

                var dllFullFileName = Path.Combine(path, "SQLite.Interop.dll");
                connection.Open();
                connection.EnableExtensions(true);
                connection.LoadExtension(dllFullFileName, "sqlite3_fts5_init");

@ErikEJ sorry, again I've missed all github notifications somehow :( That code is correct. I'm working with fts5 SQLite database same way. P. S. fts5 is a full-text search extension that was introduced in sqlite 3.9.0 (2015-10-14).

[ErikEJ]

What is fts5 ?? Is it supported in Sqlite 3.40?

[ErikEJ]

I found this: https://sqlite.org/forum/info/4cf36abaf7011e76cbb73e07591d4a0cae6bcc9b7c2fe5e548f6fed02710e503

[ErikEJ]

@alexey-leonovich thoughts?

[ErikEJ]

                var dllFullFileName = Path.Combine(path, "SQLite.Interop.dll");
                connection.Open();
                connection.EnableExtensions(true);
                connection.LoadExtension(dllFullFileName, "sqlite3_fts5_init");

[ErikEJ]

@alexey-leonovich Thanks for conforming, I hope to get around to implementing this one day.