#35412: Drop support for SQLite < 3.31.0. -------------------------------------+------------------------------------- Reporter: Mariusz | Owner: Mariusz Felisiak Felisiak | Type: | Status: assigned Cleanup/optimization | Component: Database | Version: 5.0 layer (models, ORM) | Severity: Normal | Keywords: Triage Stage: | Has patch: 0 Unreviewed | Needs documentation: 0 | Needs tests: 0 Patch needs improvement: 0 | Easy pickings: 0 UI/UX: 0 | -------------------------------------+------------------------------------- SQLite 3.28+ supports `EXCLUSION` and fixed distances in window expressions. SQLite 3.30.1+ supports SQL 2003 `FILTER (WHERE ...)` in aggregate expressions. SQLite 3.31+ supports virtual fields.
Ubuntu Focal ships with SQLite 3.31.1 (which will still by supported by Django). Debian Bullseye ships with 3.34.1 (which will still by supported by Django) and will EOL in July 2024. Python 3.10 ships with 3.35.4(5). SQLite 3.30.1 was released in October 2019. SQLite version support seems like a similar situation as GEOS libraries which we generally support about 5 years after released. -- Ticket URL: <https://code.djangoproject.com/ticket/35412> 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 django-updates+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-updates/0107018f257cba41-b4bf7612-69d6-4062-a6d9-dc671c4ea8b3-000000%40eu-central-1.amazonses.com.