IreneKnapp/direct-sqlite

Enable math functions

Closed this issue · 3 comments

I guess having at least a flag to turn on math functions like sqrt would be very useful.

jchia commented

I've added a flag to enable built-in math functions.

Great, thank you. After looking into it a bit more, I found that the 'default' Sqlite binary for windows and in most Linux distributions has many flags enabled by default.

The way they become activated (I guess) is because the sqlite make files are used which enable them.
For example for windows or linux

Not sure whether this library should try to use them as a default, just wanted to mention this for future reference.

jchia commented

Which Linux distros has enabled the built-in math functions for their packaged sqlite? Ubuntu 20.04 is not one of them.