libsqlite3 update

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

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

> 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.