0.23.0

Windows 32-bit build (sqlean-win-x86.zip), courtesy of @lucydodo. Thank you, SeongTae!

0.22.0

Linux ARM build (sqlean-linux-arm64.zip), courtesy of @flaviomartins. Thank you, Flavio!

0.21.10

Print the actual error message when regexp compilation fails (#104).

Before:

select regexp_substr('abc5xyz', 'a(?<=\D*)\d');
-- Runtime error: out of memory (7)

Now:

select regexp_substr('abc5xyz', 'a(?<=\D*)\d');
-- Runtime error: lookbehind assertion is not fixed length (offset 1)

0.21.9

Marked unicode functions as deterministic to allow their use in virtual columns (#109).

0.21.8

Update to the define extension from it's author @0x09:

This updates the define virtual table with fixes from sqlite-statement-vtab, including a potential vulnerability on platforms with uncommon integer sizes detailed in 0x09/sqlite-statement-vtab@400bea1

0.21.7

No functional changes. Fixed utf8_lookup global symbol to facilitate sqlean.go (#92).

Huge thanks to @riyaz-ali for porting sqlean to Go!

0.21.6

No functional changes. Recompiled Linux extensions on Ubuntu 20.04 instead of 22.04 to fix #90.

0.21.5

Disabled symlink on Windows in the fileio extension.

Also, 0.21.5 is the first version of sqlean available as Python and JavaScript packages! 🎉

0.21.4

Added the ipaddr extension to the single-file sqlean bundle (except for Windows).

0.21.0

This release brings a single-file bundle containing all extensions from the main set:

• sqlean.so for Linux
• sqlean.dll for Windows
• sqlean.dylib for macOS

The bundle loads like other extensions, e.g:

sqlite> .load ./sqlean
sqlite> select median(value) from generate_series(1, 99);

When loaded, it activates functions from all existing extensions (except ipaddr, which does not work on Windows).