Fuzzy Search of a sqlite database?

Not sure if loading SQLite extensions has become easier with Xojo now, but just in case, here’s a way to do it:

db.SQLSelect ("SELECT load_extension ("""+extFile.NativePath+""", ""sqlite3_icu_init"")")

The above is used to load the ICU extension (sqlite3_icu_extension.dylib) so that you get unicode support for textual functions and comparisons.

See also: SQLite ICU (unicode support) for Mac updated

3 Likes