[SOLVED] Help with SQLite3 update

[TheOldPresbyope]

Thanks @the_bertrum and Kent for your response.
Build from source looks straightforward indeed. Please excuse my ignorance if my question doesn't make sense. Does build from source replace the existing installation with a fresh one, or does it update the existing installation. I mean, would moodeaudio be able to acess its existing internal database files with the new build, or would it lose them all?
I appreciate the possibility of no ready answer to the question and I am willing to test it out if need be.

-Jas

If you look at my example output you'll see that the new sqlite3 binary is written to the directory I built in. The next step would be to copy it into the /usr/bin directory in place of the existing sqlite3 v3.27.2. To continue my example, something like:

Code:

cd /usr/bin
# save the existing binary just in case
sudo mv sqlite3 sqlite3.dist
# copy in the new binary
sudo cp /home/pi/sqlite-amalgamation-3370200/sqlite3 .
# reboot is the brute-force way to make sure the new binary is used
sudo reboot

Since the database file for moOde, including its schema, etc., is stored in /var/local/www/db/moode-sqlite3.db it's safe.

Regards,
Kent