Drop support for SQLite < 3.27.0

[Mariusz Felisiak]

SQLite 3.24+ supports updating rows on constraint or uniqueness errors during INSERT.
SQLite 3.25+ supports window functions and renaming columns.
SQLite 3.26+ support DDL operations requiring references rename in a transaction.

Ubuntu Focal ships with SQLite 3.31.1 (which will still by supported by Django).
Debian Buster ships with 3.27.2 and will EOL in June 2024.
Python 3.8 ships with 3.28.0.

​SQLite 3.26.0 was released in December 2018. SQLite version support seems like a similar situation as GEOS libraries which we generally support about 5 years after released.

[Natalia Bidart]

Sounds good, though following the rationale I'm not sure I understand why we wouldn't drop support for < 3.27?

[Mariusz Felisiak]

Replying to Natalia Bidart:

Sounds good, though following the rationale I'm not sure I understand why we wouldn't drop support for < 3.27?

3.27 will not be 5 years old, when Django 5.0 is released.

[Natalia Bidart]

Replying to Mariusz Felisiak:

Replying to Natalia Bidart:

Sounds good, though following the rationale I'm not sure I understand why we wouldn't drop support for < 3.27?

3.27 will not be 5 years old, when Django 5.0 is released.

Right, but 3.26 will be, so I was wondering if we should also drop 3.26. From the ticket title I understood you mean drop every version less than 3.26? Or did you mean <= 3.26"?

[Mariusz Felisiak]

Agreed, let's bump to 3.27.0.

[Mariusz Felisiak]

​PR

[GitHub <noreply@…>]

In 2b582387:

Fixed #34760 -- Dropped support for SQLite < 3.27.