Opened 3 months ago

Closed 3 months ago

#35412 closed Cleanup/optimization (fixed)

Drop support for SQLite < 3.31.0.

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

Description

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.

Change History (5)

comment:1 by Mariusz Felisiak, 3 months ago

Version: 5.0dev

comment:2 by Mariusz Felisiak, 3 months ago

Needs documentation: set

comment:3 by Simon Charette, 3 months ago

Triage Stage: UnreviewedAccepted

comment:4 by Sarah Boyce, 3 months ago

Has patch: set
Needs documentation: unset
Triage Stage: AcceptedReady for checkin

comment:5 by Sarah Boyce <42296566+sarahboyce@…>, 3 months ago

Resolution: fixed
Status: assignedclosed

In 85c154d:

Fixed #35412 -- Dropped support for SQLite < 3.31.

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