[Django] #34201: Drop support for SQLite < 3.21.0

[Django]

#34201: Drop support for SQLite < 3.21.0
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: Mariusz Felisiak
Felisiak |
Type: | Status: assigned
Cleanup/optimization |
Component: Database | Version: 4.1
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.15+ supports functions in partial indexes.
SQLite 3.20+ can defer constraint checks and supports `PRAGMA` foreign key
checks.

Ubuntu Xenial ships with SQLite 3.22.0 (which will still by supported by
Django) and will EOL in April 2023. Debian Buster ships with 3.27.2 and
will EOL in June 2024. Python 3.7 ships with 3.21.0.

[https://www.sqlite.org/releaselog/3_21_0.html SQLite 3.21.0] was released
in October 2017. 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/34201>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#34201: Drop support for SQLite < 3.21.0
-------------------------------------+-------------------------------------

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

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

Changes (by Carlton Gibson):

* stage: Unreviewed => Accepted

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

[Django]

#34201: Drop support for SQLite < 3.21.0
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by Claude Paroz):

+1

--
Ticket URL: <https://code.djangoproject.com/ticket/34201#comment:2>

[Django]

#34201: Drop support for SQLite < 3.21.0
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak
Cleanup/optimization | Status: assigned
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted

Has patch: 1 | Needs documentation: 0

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

Changes (by Mariusz Felisiak):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/16366 PR]

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

[Django]

#34201: Drop support for SQLite < 3.21.0
-------------------------------------+-------------------------------------
Reporter: Mariusz Felisiak | Owner: Mariusz
Type: | Felisiak

Cleanup/optimization | Status: closed

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

Severity: Normal | Resolution: fixed

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

Changes (by GitHub <noreply@…>):

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

Comment:

In [changeset:"95a101a690402076321331d56e67d896e8f6dfbc" 95a101a6]:
{{{
#!CommitTicketReference repository=""
revision="95a101a690402076321331d56e67d896e8f6dfbc"
Fixed #34201 -- Bumped minimum supported SQLite to 3.21.0.
}}}

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