#34201 closed Cleanup/optimization (fixed)

Drop support for SQLite < 3.21.0

Reported by: Mariusz Felisiak Owned by: Mariusz Felisiak
Component: Database layer (models, ORM) Version: 4.1
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

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.

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.

Change History (4)

comment:1 by Carlton Gibson, 17 months ago

Triage Stage: UnreviewedAccepted

comment:2 by Claude Paroz, 17 months ago

+1

comment:3 by Mariusz Felisiak, 17 months ago

Has patch: set

comment:4 by GitHub <noreply@…>, 17 months ago

Resolution: fixed
Status: assignedclosed

In 95a101a6:

Fixed #34201 -- Bumped minimum supported SQLite to 3.21.0.

Note: See TracTickets for help on using tickets.
Back to Top