sqlite3 math extension

[bodemann]

I hope this is the right place to ask.

I'd like to use the math extension to be able to query like this:
stmt := conn.Prep("SELECT cos(lat) FROM t WHERE rowid = $id;")

Does anybody know how I could activate it?

[anacrolix]

I believe you need to add a define SQLITE_* to enable math and then possibly link against an appropriate library to provide math functions to C -lm.

[AdamSLevy]

This could be something we expose as a build tag perhaps. Or just decide to include it always. I'm not strictly opposed to including the extension by default but open to the opinions of others.

[anacrolix]

I think include it by default.

[bodemann]

Include it by default would be nice.

BTW: The sqlite binary from https://www.sqlite.org/download.html has quite a few extensions compiled in (I tested the linux binary). I would suggest this as a reference for what to include.

Thank you both for reacting to my question.