libsqlite3 update

(1) By anonymous on 2020-09-04 22:25:04 [source]

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

I've pulled source code from git://git.build2.org/packaging/sqlite/sqlite.git and used bpkg to install libsqlite3 by bpkg install -g libsqlite3.

But I got error:

    info: Install /bpkg/libsqlite3/master from remote https://raw.githubusercontent.com [https://github.com]
    warn: package.json doesn`t exist
    warn: Makefile not found, skipping remote: https://raw.githubusercontent.com/bpkg/libsqlite3/master
    error: package not found on any remote

Could some body help me to upgrade libsqlite3?

(2) By anonymous on 2020-09-05 11:52:23 in reply to 1 [link] [source]

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^* seems to depend on system libsqlite3.so, so you can try to use APT pinning to install SQLite 3.31.1-4ubuntu0.2 from Focal Fossa, 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.

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.

^* It seems to return HTTP 500 Internal Server Error intermittently, but sometimes the link does work.