Fuzzy search

[onkoe]

I'd like for the literal search functionality (CollectionModifier::Literal) to use fuzzy searching if at all possible.

There's an extension to do that within the sqlean SQLite extension collection located here. However, SQLx doesn't compile extensions for you.

So, we need to add libsqlite3-sys without default features. Then, in our build.rs build script, we should compile SQLite and the extension, then emit [env] SQLITE3_STATIC=1 and [env] SQLITE3_LIB_DIR="<target dir...>/sqlite3/build/ or whatever.

If it's possible, we may be able to dynamically patch SQLite with the extension (at build time), then happily ask libsqlite3-sys to build it for us with [env] SQLITE3_INCLUDE_DIR. I'd prefer this, as building stuff manually is always some dirty business. :p

A fork might work too, as SQLite is well-known for stability, and in general, there's really not much security concern within this project. I

Here are some references:

• sqlean: nice extension collection :D
• sqlx::sqlite docs: explains a little about how sqlx relies on libsqlite3-sys
• rustqlite3-sys README - Notes on Building: review of the build process for the Rust bindings
• sqlx GitHub Issues - "SQLite: Is there a way to load extensions?": info about how to load extensions dynamically, and some discussion about PR #2062 (which adds dynamic extension support in the connection settings)
• Stack Overflow - "How to compile an extension into SQLite?": hope I don't have to use this...
• SQLite docs - "How to Compile SQLite"

[onkoe]

Before I put wayyyy too much time into this, I'm going to try FTS5 first to get some basic functionality.