#30056: Add SQLite support for StdDev() and Variance()
-------------------------------------+-------------------------------------
               Reporter:  Nick Pope  |          Owner:  nobody
                   Type:  New        |         Status:  new
  feature                            |
              Component:  Database   |        Version:  2.1
  layer (models, ORM)                |       Keywords:  sqlite, stddev,
               Severity:  Normal     |  variance, statistics
           Triage Stage:             |      Has patch:  0
  Unreviewed                         |
    Needs documentation:  0          |    Needs tests:  0
Patch needs improvement:  0          |  Easy pickings:  0
                  UI/UX:  0          |
-------------------------------------+-------------------------------------
 `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.

-- 
Ticket URL: <https://code.djangoproject.com/ticket/30056>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/050.2552dd7798fa43ba431ea751a5aa4c1c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to