SQLite Forum

libsqlite3 update
Login
> In Ubuntu 18.04,version of libsqlite3 default 3.22, but for Drupal 9, I need libsqlite3 3.26 or greater.

This is a vendor problem, not an SQLite problem.

The [Ubuntu 18.04 package for php-sqlite3](https://packages.ubuntu.com/bionic/amd64/php7.2-sqlite3/filelist)<sup>*</sup> seems to depend on system `libsqlite3.so`, so you can try to use [APT pinning](http://jaqque.sbih.org/kplug/apt-pinning.html) to install [SQLite 3.31.1-4ubuntu0.2 from Focal Fossa](https://packages.ubuntu.com/focal/libsqlite3-0), though this may break other users of `libsqlite3` (if they do something incompatible with the new SQLite3 version) or the whole system (if you perform pinning incorrectly and end up half-upgrading to Focal Fossa).

Alternatively, you can try to rebuild the `sqlite3` PHP extension from source with the new SQLite3 bundled inside and place the resulting `sqlite3.so` somewhere to make it override the system-provided version, but that's a [PHP problem](https://www.php.net/support).

By the way, mixing <https://cppget.org> with system packages is probably not a good idea: it may complicate future system upgrades or leave confusing configurations where it's not obvious whether system- or cppget-provided library is in use.

<sup>*</sup> It seems to return `HTTP 500 Internal Server Error` intermittently, but sometimes the link does work.