[Django] #35412: Drop support for SQLite < 3.31.0.

[Django]

#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.

[Django]

#35412: Drop support for SQLite < 3.31.0.
-------------------------------------+-------------------------------------

Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak):

* version: 5.0 => dev

--
Ticket URL: <https://code.djangoproject.com/ticket/35412#comment:1>

[Django]

#35412: Drop support for SQLite < 3.31.0.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed

Has patch: 0 | Needs documentation: 1

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_docs: 0 => 1

Comment:

[https://github.com/django/django/pull/18111 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/35412#comment:2>

[Django]

#35412: Drop support for SQLite < 3.31.0.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Accepted

Has patch: 0 | Needs documentation: 1
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Simon Charette):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/35412#comment:3>

[Django]

#35412: Drop support for SQLite < 3.31.0.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Sarah Boyce):

* has_patch: 0 => 1
* needs_docs: 1 => 0
* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/35412#comment:4>

[Django]

#35412: Drop support for SQLite < 3.31.0.
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak

Cleanup/optimization | Status: closed

Component: Database layer | Version: dev
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Sarah Boyce <42296566+sarahboyce@…>):

* resolution: => fixed
* status: assigned => closed

Comment:

In [changeset:"85c154da2f07485a1cdc4d886eee4c1a1ef56137" 85c154d]:
{{{#!CommitTicketReference repository=""
revision="85c154da2f07485a1cdc4d886eee4c1a1ef56137"
Fixed #35412 -- Dropped support for SQLite < 3.31.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/35412#comment:5>