Opened 8 months ago
Closed 8 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 , 8 months ago
| Version: | 5.0 → dev |
|---|
comment:2 by , 8 months ago
| Needs documentation: | set |
|---|
comment:3 by , 8 months ago
| Triage Stage: | Unreviewed → Accepted |
|---|
comment:4 by , 8 months ago
| Has patch: | set |
|---|---|
| Needs documentation: | unset |
| Triage Stage: | Accepted → Ready for checkin |
Note:
See TracTickets
for help on using tickets.
PR