Sqlite Plus Versions Save

Security fixes in crypto and fuzzy extensions.

Added the eval function to the define extension:

eval(sql[, separator])

Executes arbitrary SQL and returns the result as string (if any):

select eval('select 42');
42
select eval('select 10 + 32');
42
select eval('select abs(-42)');
42
select eval('select ''hello''');
hello

Changes in the define extension:

• Radically improved scalar functions performance by caching prepared statements.
• BREAKING: Always call define_free() before disconnecting to free resources.

This release brings the define extension. It allows creating user-defined functions in regular SQL.

Binaries for Apple silicon (ARM-based) macOS: sqlean-macos-arm64.zip

Improvements:

• Marked re functions as deterministic (#46)
• Packaged extensions for each platform (#41)

Bug fixes:

• Fixed string corruption in regexp_replace (#39 #45)

unicode extension now registers LIKE, upper() and lower() as UTF-16 functions. This (hopefully) helps SQLite to use overridden implementation when working with Unicode strings. See #36 for details.

json1 extension in SQLite 3.37 is buggy, switched to 3.36.

The evergreen incubator release. All incubator extensions are available to download here.

fileio extension:

• Added lsdir() function. It does not read file contents, and supports both recursive and non-recursive directory traversal.
• BREAKING: removed fsdir() function in favor of lsdir().