0.24.0

Functions for working with UUID v7 in the uuid extension, courtesy of @nghduc97. Thank you, Đức!

uuid7

Generate a version 7 (time-ordered, random) UUID.

sqlite> select uuid7();
018ff383-3e37-7615-b764-c241f544e573

sqlite> select uuid7();
018ff383-94fd-70fa-8da6-339180b8e15d

uuid7_timestamp_ms

Extract unix timestamp in miliseconds from version 7 UUID X. Returns null if the detected UUID version is not 7.

sqlite> select uuid7_timestamp_ms('018ff38a-a5c9-712d-bc80-0550b3ad41a2');
1717777901001

sqlite> select datetime(uuid7_timestamp_ms('018ff38a-a5c9-712d-bc80-0550b3ad41a2') / 1000, 'unixepoch');
2024-06-07 16:31:41

sqlite> select uuid7_timestamp_ms(uuid4()) is null;
1

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).