[issue30952] include Math extension in SQlite

[Big Stone]

Big Stone  added the comment:

Hi Victor,

I would like to use math functions, specifically "exp(sum(log(x)))", on the 
Sqlite motor shipped embedded with Python on Windows.

It's an important corner case of what I miss in Sqlite motor, that forced me to 
(wait to) rely on SQLServer (or other big iron).

In my other hobby of Python-in-Scientific-cursus of France, having not a fully 
enabled SQLite (in its mathematic abilities) is also a problem.

Maybe there are other more important outstanding issues about embedded-SQlite 
integration with Python, but that one is hard to workaround.

--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue30952] include Math extension in SQlite

[STINNER Victor]

STINNER Victor  added the comment:

> I would be interested in having SQLite shipped with the math extension

Python uses the SQLite library installed on the system, at least on Linux. To 
load an extension, I found:
https://sqlite.org/loadext.html
https://sqlite.org/c3ref/load_extension.html

How am I supposed the math extension? The CLI ".load" command requires the name 
or even the full path to a shared library (".so" file on Linux).

I see that the issue was tagged as Windows. Are you talking about the SQLite 
bundled with Python installer on Windows?

--
nosy: +haypo

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue30952] include Math extension in SQlite

[Big Stone]

Big Stone  added the comment:

Sorry, I'm not skilled enough to do PR on Python core.

--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue30952] include Math extension in SQlite

[Zachary Ware]

Zachary Ware  added the comment:

Would you like to supply a PR?

--

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue30952] include Math extension in SQlite

[R. David Murray]

Changes by R. David Murray :


--
components: +Windows
nosy: +paul.moore, steve.dower, tim.golden, zach.ware

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue30952] include Math extension in SQlite

[Big Stone]

New submission from Big Stone:

I would be interested in having SQLite shipped with the math extension in 
python-3.7.
 
The log / exponential function are important for some sql use case like 
 exp(sum(log(x)))

--
components: Extension Modules
messages: 298555
nosy: Big Stone
priority: normal
severity: normal
status: open
title: include Math extension in SQlite
type: enhancement
versions: Python 3.7

___
Python tracker 

___
___
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com