Anton Zhiyanov

## unhex Reverse function for `hex()`. Decodes the previously hex-encoded blob and returns it. Created by [Keith Medcalf](https://sqlite.org/forum/forumpost/dd104572f2833e48?t=h). ```sql sqlite> .load dist/unhex sqlite> select unhex(hex('hello')); hello ``` Download: [linux](https://github.com/nalgeon/sqlean/releases/download/incubator/unhex.so) |...

## fcmp Floating point numbers comparison and rounding. Created by [Keith Medcalf](http://www.dessus.com/files/sqlfcmp.c), Public Domain. ```sql sqlite> select 0.1*3 = 0.3; 0 sqlite> .load dist/fcmp sqlite> select feq(0.1*3, 0.3); 1 ```...

## isodate Additional date and time functions: - Extract date parts according to ISO 8601: week day, week of a year, year - Convert ISO 8601 datetime to unix timestamp...

## math2 Even more math functions and bit arithmetics. Created by [Keith Medcalf](http://www.dessus.com/files/sqlmath.c), Public Domain. ```sql sqlite> select round(m_e(), 3) 2.718 ``` Constants: ``` m_e() -> Euler's number (e) m_log2e()...

## besttype Implements `ToBestType(x)` function: - NULL returns NULL - TEXT/BLOB that "looks like a number" returns the number as Integer or Real as appropriate - TEXT/BLOB that is zero-length...

## recsize Еstimates total record size. Created by [Keith Medcalf](http://www.dessus.com/files/sqlsize.c), Public Domain. ```sql sqlite> .load dist/recsize sqlite> select recsize(10); 3 sqlite> select recsize(10, 20, 30); 7 ``` Download: [linux](https://github.com/nalgeon/sqlean/releases/download/incubator/recsize.so) |...

## stats2 Even more math statistics functions. Created by [Keith Medcalf](http://www.dessus.com/files/sqlfunc.c), Public Domain. ```sql sqlite> .load dist/stats2 sqlite> select sem(value) from generate_series(1, 99); 2.88675134594813 ``` Aggregate functions (also available as...

## compress Compress / uncompress data using zlib. Doesn't work on Windows. Created by [D. Richard Hipp](https://sqlite.org/src/file/ext/misc/compress.c), Public Domain. ```sql sqlite> .load dist/compress sqlite> select hex(compress('hello world')); 8B789CCB48CDC9C95728CF2FCA4901001A0B045D sqlite> select...

## sqlar Compress / uncompress data with zlib using the SQL Archive approach: - Only compress the value if it yields a smaller blob. - Uncompress the value if needed...

## zipfile Read and write zip files, both in memory and on disk. Doesn't work on Windows. Created by [D. Richard Hipp](https://sqlite.org/src/file/ext/misc/zipfile.c), Public Domain. [Documentation](https://sqlite.org/zipfile.html) ```sql sqlite> .load dist/zipfile sqlite>...