search

crawshaw / sqlite

Go SQLite3 driver
ISC License
561 stars 67 forks source link

sqlite3 math extension #136

Open bodemann opened 1 year ago

bodemann commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

I think include it by default.

bodemann commented 1 year ago

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.