[Django] #36671: Drop support for SQLite < 3.37.0.

[Django]

#36671: Drop support for SQLite < 3.37.0.
-------------------------------------+-------------------------------------
Reporter: Mariusz | Owner: Mariusz Felisiak
Felisiak |
Type: | Status: assigned
Cleanup/optimization |
Component: Database | Version: dev
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.35.5+ supports `ALTER TABLE ... DROP COLUMN`.
SQLite 3.35+ can return columns from `INSERT` and `UPDATE`.

Ubuntu Noble ships with SQLite 3.45.1 (which will still by supported by
Django).

Debian Bullseye will EOL in August 2026 and Django 6.1 will be released in
August 2026, so we may ignore it.
Debian Bookworm ships with SQLite 3.40.1 (which will still by supported by
Django).

Python 3.12 ships with 3.43.1.

​SQLite 3.36.0 was released in June 2021. 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/36671>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#36671: Drop support for SQLite < 3.37.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: 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/19972 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/36671#comment:1>

[Django]

#36671: Drop support for SQLite < 3.37.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: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Natalia Bidart):

* stage: Unreviewed => Accepted

Comment:

Thank you Mariusz!
--
Ticket URL: <https://code.djangoproject.com/ticket/36671#comment:2>

[Django]

#36671: Drop support for SQLite < 3.37.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: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by GitHub <noreply@…>):

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

Comment:

In [changeset:"d506e4a52847ed4fb80754175d76b6b83ff90929" d506e4a5]:
{{{#!CommitTicketReference repository=""
revision="d506e4a52847ed4fb80754175d76b6b83ff90929"
Fixed #36671 -- Dropped support for SQLite < 3.37.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/36671#comment:3>