Opened 6 years ago
Closed 6 years ago
#30056 closed New feature (fixed)
Add SQLite support for StdDev() and Variance()
Reported by: | Nick Pope | Owned by: | Nick Pope |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | sqlite, stddev, variance, statistics |
Cc: | Mariusz Felisiak | Triage Stage: | Accepted |
Has patch: | yes | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
StdDev()
and Variance()
are currently supported for SpatiaLite, but not SQLite. Django's documentation highlights that there is an extension module available that provides support, but there are problems with this suggestion:
- This extension module is not provided compiled and only implements
STDDEV
andVARIANCE
. - Django uses
STDDEV_POP
andSTDDEV_SAMP
forStdDev()
;VAR_POP
andVAR_SAMP
forVariance()
- so they wouldn't work anyway.
As an alternative, we can make use of the statistics
module added to the standard library in Python 3.4.
Change History (4)
comment:1 by , 6 years ago
Has patch: | set |
---|---|
Owner: | changed from | to
Status: | new → assigned |
Version: | 2.1 → master |
comment:2 by , 6 years ago
Triage Stage: | Unreviewed → Accepted |
---|
comment:3 by , 6 years ago
Cc: | added |
---|
Note:
See TracTickets
for help on using tickets.
PR