By daffie on
Change record status: 
Published (View all published change records)
Project: 
Drupal core
Introduced in branch: 
10.0.x
Introduced in version: 
10.0.0
Issue links: 
https://www.drupal.org/node/3109340
Description: 

The policy decision has been made that Drupal must be able to use JSON functionality on the database. MySQL, MariaDB and PostgreSQL have in their minimum supported version already all required JSON functionality. SQLite however does not and in 10.0 the json1 extension will be required.

The advantage of having JSON support in the database is that we can replace several serialized data structures in the database. Such as {config}.data, {cache_*}.data, the Layout Builder data of per-entity layouts, and plenty others. Many of these would benefit from being serialized as JSON instead of PHP.

Alternative databases that support JSON include

  • SQL Server 2016 or newer
  • Oracle 12c Release 1 or newer
  • MongoDB
Impacts: 
Site builders, administrators, editors
Module developers
Site templates, recipes and distribution developers