0.19.3

New functions:

• regexp_capture(source, pattern [, n]) extracts a captured group from the source string (regexp extension).
• sqlean_version() returns the current version (all extensions).

0.19.2

Changes in the fileio extension:

• fileio_append(path, str) appends a string to a file.
• fileio_read(path, offset, limit) reads a file fragment.

Thanks to @phrrngtn for fileio_read improvements! (#68)

0.19.1

Consistent function naming for the fileio extension:

readfile  -> fileio_read
scanfile  -> fileio_scan
writefile -> fileio_write
mkdir     -> fileio_mkdir
symlink   -> fileio_symlink
lsdir     -> fileio_ls
lsmode    -> fileio_mode

Old names still work for the sake of backward compatibility.

0.19.0

Added the scanfile function to the fileio extension:

scanfile(path)

Reads the file specified by path line by line, without loading the whole file into memory.

sqlite> select rowid, value, name from scanfile('hello.txt');
┌───────┬───────┬───────────┐
│ rowid │ value │   name    │
├───────┼───────┼───────────┤
│ 1     │ one   │ hello.txt │
│ 2     │ two   │ hello.txt │
│ 3     │ three │ hello.txt │
└───────┴───────┴───────────┘

0.18.4

Optimized regexp performance.

0.18.2

Unicode support in the regexp extension.

0.18.1

This release brings the regexp extension for all operating systems. It supports all major regular expression features. The old re extension is deprecated.

0.18.0

This release brings the regexp extension for Linux and macOS. It supports all major regular expression features. The old re extension is still available for Windows users.

The vsv extension now supports custom decimal separators (dsep parameter).

0.17.2

Security fixes in crypto and fuzzy extensions.

0.17.1

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