[issue30952] [Windows] include Math extension in SQlite

[Erlend E. Aasland]

Erlend E. Aasland  added the comment:

This was fixed in bpo-42686. Closing as duplicate.

--
nosy: +erlendaasland
resolution:  -> duplicate
stage:  -> resolved
status: open -> closed
superseder:  -> include built-in Math functions in SQLite to 3.35.0 of march 
2021

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[Big Stone]

Big Stone  added the comment:

Please apologize. I indeed went off-topic. I can understand few person find 
this request usefull, and over-react to defend it.

Sorry again.

--
status: pending -> open

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[Serhiy Storchaka]

Change by Serhiy Storchaka :


--
status: open -> pending

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[STINNER Victor]

STINNER Victor  added the comment:

"If you want SQlite because of its performance, recent version starts to do 
multi-threading, and/or fear to leave other langages a stupid sizeable 
performance advantage, then you may perhaps don't leave the situation as it is."

I'm not sure of what you are asking here. Is it related to the math module? If 
not, you might open a different issue.


"then you may perhaps don't leave the situation as it is"

Reminder: Python is developed by volunteers working in their free time. It's 
not a product for which you pay a commercial support.

"Look at latest Intel cpu shooting for quadcore, Iphone 8 being 6 cores, latest 
stable nodejs gaining a big speed bump, ... etc ... etc... and the need of 
efficiency to keep the planet cool enough."

Ok, now you are really off-topic.

*I* don't know anything about sqlite. That's why I asked how this feature is 
supposed to be implemented.

If nobody proposes a pull request or explain how to implement it, this issue is 
not going to make progress ;-)

--

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[Zachary Ware]

Zachary Ware  added the comment:

I, for one, don't have the time to work on this, especially since I don't 
regularly use the sqlite3 module.  If this is something you want, submit a PR.  
Lack of skill is not a legitimate reason not to do so; the devguide provides 
instructions on the mechanics of submitting a patch and any questions you have 
along the way can be asked here, on the core-mentorship mailing list, or on the 
#python-dev channel on freenode.

It's much easier to justify 2 minutes to answer a question, even if that 2 
minutes happens 10 times, than 2 hours to add a feature that I won't use and 
will be expected to maintain :)

--

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[Big Stone]

Big Stone  added the comment:

I know you can do create_function(): 
https://raw.githubusercontent.com/stonebig/sqlite_bro/master/docs/sqlite_bro.GIF

But the performance is crappy at best because of string conversion in the API.

If you want SQlite because of its performance, recent version starts to do 
multi-threading, and/or fear to leave other langages a stupid sizeable 
performance advantage, then you may perhaps don't leave the situation as it is.

Didn't Victor spoke about the need to 2X CPython performance recently, for it 
to stay in the game ? 

Look at latest Intel cpu shooting for quadcore, Iphone 8 being 6 cores, latest 
stable nodejs gaining a big speed bump, ... etc ... etc... and the need of 
efficiency to keep the planet cool enough.

--

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[Peter Otten]

Peter Otten <__pete...@web.de> added the comment:

A possible workaround is to use create_function():

>>> import sqlite3, math
>>> db = sqlite3.connect(":memory:")
>>> db.execute("select sin(?);", (math.pi,)).fetchone()
Traceback (most recent call last):
  File "", line 1, in 
sqlite3.OperationalError: no such function: sin
>>> db.create_function("sin", 1, math.sin)
>>> db.execute("select sin(?);", (math.pi,)).fetchone()
(1.2246467991473532e-16,)

--
nosy: +peter.otten

___
Python tracker 

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

[issue30952] [Windows] include Math extension in SQlite

[STINNER Victor]

Change by STINNER Victor :


--
title: include Math extension in SQlite -> [Windows] include Math extension in 
SQlite

___
Python tracker 

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