Upgrade sqlite3 to custom package

Question

I have a server running centos7 with sqlite3 installed using Yum/rpm. By default the sqlite package is not compiled with the extension JSON1 which I need. The extension can be enabled when the package is compiled using the flag -DSQLITE_ENABLE_JSON1 After working at it for a full day I've managed to find the RPM source files, updated the spec so it compiles with the flag, and recompiled it into a new package. Now I can run rpm -U current-sqlite-package.rpm custom-sqlite-package.rpm and upgrade to my custom package. Both yum and rpm say that the package but when I run /user/bin/sqlite3 --version it is still the old version.

How do I upgrade to my custom package? How does yum/rpm packages tie to the software in /user/bin?

Answer 1

Current versions of SQLite3 support runtime extension loading. So you can just download and compile the JSON1 extension as a separate .so file and load it via .load ~/path/to/json1.so

This will allow you to receive updates for SQLite via the default package manager and no need to rebuild it yourself.