[11.x] [policy] Treat SQLite as a dev (rather than prod) requirement and allow it to be raised in Drupal minors

Open on Drupal.org →

Created on 27 February 2022, almost 3 years ago

Updated 10 July 2023, over 1 year ago

Problem/Motivation

The SQLite requirement for Drupal 10.0 is currently 3.26, because that is the version installed on RHEL 8.
Over the course of Drupal 10's lifetime, the version of SQLite that's commonly available on systems that developers and CI systems use will increase. E.g., RHEL 9 will ship this year. Other operating systems (e.g., MacOS) will release new versions too.
SQLite is intended primarily for Drupal development (running tests) and evaluation (running the Quick Start command). It is not intended for production, and therefore doesn't need to be supported on non-latest operating systems (e.g., RHEL 8 once RHEL 9 is available for local installation and CI system installation). However, I don't know if we've officially documented that anywhere.
Newer versions of SQLite will be useful during Drupal 10's lifetime. For example, SQLite 3.38 (released in Feb. 2022) adds support for the -> and ->> operators that will be useful to us when we add a JSON querying API to our database API, which we would like to do in Drupal 10 minors.

Proposed resolution

Decide on and communicate that SQLite is a dev requirement, and as such, can be raised in Drupal 10 minors, rather than being locked until Drupal 11.
Monitor when SQLite 3.38 becomes commonly available (e.g., if Ubuntu 22.04, RHEL 9, the late 2022 version of MacOS, etc.) all ship with it.
When the above happens, raise the SQLite requirement to 3.38, even if that's in a Drupal minor like 10.1 or 10.2.

Remaining tasks

Discuss and agree on (or not) the proposed resolution.
What about Debian? The next version of Debian won't be released until 2023. Should that hold back a SQLite requirement increase, or do we not consider Debian to be an OS that we need to support SQLite usage on?

User interface changes

None

API changes

Explicit classification of SQLite as a dev requirement. I don't know if that's been officially communicated before.
When the time is right, an increase of the SQLite requirement to 3.38.

Data model changes

None

Release notes snippet

TBD

✨ Feature request

Status

Closed: won't fix

Version

11.0 🔥

Component

SQLite driver →

Last updated 2 days ago

No maintainer

Created by

🇳🇱Netherlands daffie

Live updates comments and jobs are added and updated live.

Needs release manager review
It is used to alert the release manager core committer(s) that an issue significantly affects the overall technical debt or release timeline of Drupal, and their signoff is needed. See the governance policy draft for more information.

sqlite

Drupal 11

Major version only

Incomplete comments

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment almost 2 years ago →
🇺🇸United States xjm
Ooh yes, we can ask the DA for those.
Comment over 1 year ago →
🇭🇺Hungary Gábor Hojtsy Hungary
Updating title, tags and version number based on recent announcement at https://www.drupal.org/about/core/blog/new-drupal-core-branching-scheme-... →
Status changed to Closed: won't fix over 1 year ago8:35pm 9 May 2023
Comment over 1 year ago →
🇺🇸United States effulgentsia
No objections to marking this "won't fix" (meaning, we won't raise SQLite requirements in Drupal minors) since #17, so doing so. 📌 [11.x] [policy] Set the SQLite minimum requirement to at least 3.45 Needs review is the issue for deciding on what the SQLite minimum should be for Drupal 11.
Comment over 1 year ago →
🇫🇷France andypost
I think we need to reopen it to add support of JSON which is required since 10.0, maybe "recommended version" can help
Comment over 1 year ago →
🇺🇸United States effulgentsia
SQLite 3.26's JSON support is already pretty good. What specific features from later versions are needed? 3.38 has -> and ->> operators, but why do we need those?

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024