Anton Zhiyanov
Anton Zhiyanov
Thanks for noticing! Unfortunately, I don't have a Windows machine to check this issue. Will look into it when I have a chance. The source code for the `regexp_replace()` function...
Found the bug and fixed it in [0.15.3](https://github.com/nalgeon/sqlean/releases/tag/0.15.3).
This extension does not support lazy quantifiers, and I have no plans to add it.
## eval Dinamically runs arbitrary SQL statements. Merged into the [main set](https://github.com/nalgeon/sqlean/blob/main/docs/define.md) 🎉
## cbrt Cube root function. Created by [Anton Zhiyanov](https://github.com/nalgeon/sqlean/blob/incubator/src/cbrt.c), MIT License. ```sql sqlite> .load dist/cbrt sqlite> select cbrt(27); 3.0 ``` Download: [linux](https://github.com/nalgeon/sqlean/releases/download/incubator/cbrt.so) | [windows](https://github.com/nalgeon/sqlean/releases/download/incubator/cbrt.dll) | [macos](https://github.com/nalgeon/sqlean/releases/download/incubator/cbrt.dylib)
## xmltojson Converts an XML string to the corresponding JSON string. Created by [jakethaw](https://github.com/jakethaw/xml_to_json), MIT License. ```sql sqlite> .load dist/xmltojson sqlite> select xml_to_json('42'); {"answer":"42"} ``` Download: [linux](https://github.com/nalgeon/sqlean/releases/download/incubator/xmltojson.so) | [windows](https://github.com/nalgeon/sqlean/releases/download/incubator/xmltojson.dll) |...
## pivotvtab Creates a pivot table from a regular one. Created by [jakethaw](https://github.com/jakethaw/pivot_vtab), MIT License. Suppose we have a table with quarterly sales for years 2018-2021: ```sql select * from...
## pearson Returns Pearson correlation coefficient between two data sets. Created by [Alex Wilson](https://github.com/mrwilson/squib/blob/master/pearson.c), MIT License. ```sql sqlite> .load dist/pearson sqlite> create table data as select value as x, value*2...
## envfuncs Returns the value of the environment variable. Created by [John Howie](https://github.com/jhowie/sqlite3-ext/blob/main/envfuncs.c), BSD-3-Clause License. ```sql sqlite> .load dist/envfuncs sqlite> select getenv('USER'); antonz ``` Download: [linux](https://github.com/nalgeon/sqlean/releases/download/incubator/envfuncs.so) | [windows](https://github.com/nalgeon/sqlean/releases/download/incubator/envfuncs.dll) | [macos](https://github.com/nalgeon/sqlean/releases/download/incubator/envfuncs.dylib)
## cron Compares dates against cron patterns, whether they match or not. Created by [David Schramm ](https://github.com/daschr/sqlite3_extensions/blob/master/cron.c), MIT License. ```sql sqlite> .load dist/cron sqlite> select cron_match('2006-01-02 15:04:05','4 15 * *...