Anton Zhiyanov

## uint [Natural](https://en.wikipedia.org/wiki/Natural_sort_order) string sorting and comparison. Created by [D. Richard Hipp](https://sqlite.org/src/file/ext/misc/uint.c), Public Domain. ```sql sqlite> .load dist/uint sqlite> select '2' < '10' collate uint; 1 sqlite> select '01' =...

## classifier Binary classifier via logistic regression. Created by [Alex Wilson](https://github.com/mrwilson/squib/blob/master/classifier.c), MIT License. ```sql sqlite> .load dist/classifier sqlite> select train(feature1, feature2, feature3, label) from data; sqlite> select classify(1, 1, 0);...

## bloom Bloom filter — a fast index to tell if a value is probably in a table or certainly isn't. Created by [Shawn Wagner](https://github.com/shawnw/useful_sqlite_extensions/blob/master/src/bloom_filter.c), MIT License. ```sql sqlite> .load...

## spellfix Provides a mechanism to search a large vocabulary for close matches. Created by [D. Richard Hipp](https://sqlite.org/src/file/ext/misc/spellfix.c), Public Domain. [Documentation](https://sqlite.org/spellfix1.html) ```sql sqlite> .load dist/spellfix sqlite> create virtual table dictionary...

## stats3 And even more math statistics functions. Created by [Shawn Wagner](https://github.com/shawnw/useful_sqlite_extensions/blob/master/src/math_funcs.c), MIT License. ```sql sqlite> .load dist/stats3 sqlite> select geo_mean(value) from generate_series(1, 99); 37.6231004740974 ``` ``` corr(x, y) ->...

## text2 Even more string functions. Created by [Shawn Wagner](https://github.com/shawnw/useful_sqlite_extensions/blob/master/src/more_str_funcs.c), MIT License. - `repeat(string, count)` - repeat the `string` `count` times - `concat(string, ...)` - concatenate strings - `concat_ws(sep, string,...

## array One-dimensional arrays for SQLite. Supports integers, real numbers and strings (with limited max size). Uses 1-based indexing. Stores itself as a blob value. ```sql sqlite> .load dist/array sqlite>...

## define Create scalar and table-valued functions from SQL. Merged into the [main set](https://github.com/nalgeon/sqlean/blob/main/docs/define.md) 🎉

## btreeinfo Shows information about all btrees (tables and indexes) in an SQLite database file: - if the btree has a rowid, - estimated number of entries, - estimated number...

## closure Navigate hierarchic tables with parent/child relationships. Created by [D. Richard Hipp](https://sqlite.org/src/file/ext/misc/closure.c), Public Domain. ```sql .load dist/closure -- create a parent/child table create table employees ( id integer primary...