[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Pablo Galindo Salgado : -- pull_requests: -25775 ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Pablo Galindo Salgado : -- nosy: +pablogsal nosy_count: 10.0 -> 11.0 pull_requests: +25775 pull_request: https://github.com/python/cpython/pull/27228 ___ Python tracker

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Łukasz Langa added the comment: Merged into 3.10 and 3.11. -- resolution: -> fixed stage: patch review -> resolved status: open -> closed ___ Python tracker ___

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Łukasz Langa added the comment: New changeset 4bb0a815ef2b683af75f43ab20d52eaffe78b436 by Miss Islington (bot) in branch '3.10': bpo-42686: Enable SQLite math functions in Windows build (GH-24053) (#25892) https://github.com/python/cpython/commit/4bb0a815ef2b683af75f43ab20d52eaffe78b436

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by miss-islington : -- nosy: +miss-islington nosy_count: 8.0 -> 9.0 pull_requests: +24566 pull_request: https://github.com/python/cpython/pull/25892 ___ Python tracker

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: See bpo-43492 for upgrading the macOS & Windows installers to SQLite 3.35.0. -- ___ Python tracker ___

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Mark Dickinson : -- nosy: -mark.dickinson ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Erlend Egeberg Aasland : -- components: +Library (Lib), Windows nosy: +paul.moore, tim.golden, zach.ware ___ Python tracker ___

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Mark Dickinson : -- nosy: +mark.dickinson ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: Steve, I've put up a PR that prepares the Windows build for this. Would you mind taking a look at it? -- nosy: +steve.dower ___ Python tracker

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Change by Erlend Egeberg Aasland : -- keywords: +patch pull_requests: +22888 stage: -> patch review pull_request: https://github.com/python/cpython/pull/24053 ___ Python tracker

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: Yes, R. Hipp has fixed this here: https://www2.sqlite.org/cgi/src/info/e5d7209e118a8453 We still need to modify PCbuild in order to build the SQLite library with math functions from 3.35.0 and onwards. --

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Big Stone added the comment: it seems resolved now, at least with VS 2019 -- ___ Python tracker ___ ___ Python-bugs-list mailing

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: FYI, I've opened a thread on the SQLite Forum: https://sqlite.org/forum/forumpost/721645dc36 -- ___ Python tracker ___

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: Using SQLite 3.35.0 nightly build, building Python using PCbuild/build.bat and PCBuild\pcbuild.sln with VS 2017 (does this reflect how the Windows team build the installers?), I can confirm that math functions are _not_ included by default. I added

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: > So, can this be closed? For macOS, the SQLITE_ENABLE_MATH_FUNCTIONS option is enabled by default, but I'm not sure about the Windows build. The SQLite docs says: "This option is also included on Windows builds using the "Makefile.msc" makefile

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Raymond Hettinger added the comment: > but why would you do your maths computations in sql? There are number of reasons it might be more convenient in SQL. For example, it could be handy to create views measured in degrees instead of radians. That might make where clauses in queries a

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Steven D'Aprano added the comment: It is probably harmless to enable the option, especially if it will be the SQLite default, but why would you do your maths computations in sql, using the limited set of functions available, when you could do them in Python, with a much larger set of

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: Seems like the math functions will be included by default anyways, so we'll have to explicitly exclude them if we don't want them. https://www.sqlite.org/draft/compile.html#enable_math_functions: "This option [SQLITE_ENABLE_MATH_FUNCTIONS] is

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Erlend Egeberg Aasland added the comment: I see no reason not to build SQLite with -DSQLITE_ENABLE_MATH_FUNCTIONS for the Windows and macOS builds. Why take the detour through the Python library when you can use the built-in SQLite functions? The change is trivial: Add

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

Steven D'Aprano added the comment: As far as I can tell, every one of those are already available in Python. https://docs.python.org/3/library/math.html -- nosy: +steven.daprano ___ Python tracker

[issue42686] include built-in Math functions in SQLite to 3.35.0 of march 2021

New submission from Big Stone : SQlite-3.35.0 of mach 2021 will have Built-In Math Functions option. https://sqlite.org/draft/releaselog/3_35_0.html Would it be possible to have it activated in the following versions update of Python ? It's pretty usefull for some basic statistics