id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
30056	Add SQLite support for StdDev() and Variance()	Nick Pope	Nick Pope	"`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` and `VARIANCE`.
- Django uses `STDDEV_POP` and `STDDEV_SAMP` for `StdDev()`; `VAR_POP` and `VAR_SAMP` for `Variance()` - 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."	New feature	closed	Database layer (models, ORM)	dev	Normal	fixed	sqlite, stddev, variance, statistics	Mariusz Felisiak	Accepted	1	0	0	0	0	0