Sqlite Plus Versions Save

Even more encode/decode algorithms in the crypto extension.

Base85 (aka Ascii85):

select encode('hello', 'base85');
-- BOu!rDZ
select decode('BOu!rDZ', 'base85');
-- hello

Hexadecimal:

select encode('hello', 'hex');
-- 68656c6c6f
select decode('68656c6c6f', 'hex');
-- hello

URL encoding:

select encode('/hello?text=(ಠ_ಠ)', 'url');
-- %2Fhello%3Ft%3D%28%E0%B2%A0_%E0%B2%A0%29
select decode('%2Fhello%3Ft%3D%28%E0%B2%A0_%E0%B2%A0%29', 'url');
-- /hello?t=(ಠ_ಠ)

Encode/decode functions in the crypto extension (similar to the ones in postgres).

Base32:

select encode('hello', 'base32');
-- NBSWY3DP
select decode('NBSWY3DP', 'base32');
-- hello

Base64:

select encode('hello', 'base64');
-- aGVsbG8=
select decode('aGVsbG8=', 'base64');
-- hello

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

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)

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.

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 │
└───────┴───────┴───────────┘

Optimized regexp performance.

Unicode support in the regexp extension.

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

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