01-26-2022, 12:48 PM
(This post was last modified: 01-27-2022, 07:50 AM by jass199012.)
Hi.
Can anyone please guide me on how to upgrade SQLite3 to version 3.33 or above? Or is this even possible at all?
I am running moode 7.6 and noticed it has SQLite3 version 3.27.
I am using a database file stored in a tmpfs mount to store some variables and track changes in their values. The particular feature I am looking for is the UPDATE FROM statement, which is supported only in SQLite 3.33 onwards.
https://www.sqlite.org/lang_update.html
While in buster repository, the latest available version is 3.27, bullseye has 3.34. I tried pointing the apt sources to bullseye repository, but it didn't work. Direct installation of deb package shows missing dependencies. I didn't try too much afterwards as I feared I might break the system. Thank you.
Can anyone please guide me on how to upgrade SQLite3 to version 3.33 or above? Or is this even possible at all?
I am running moode 7.6 and noticed it has SQLite3 version 3.27.
I am using a database file stored in a tmpfs mount to store some variables and track changes in their values. The particular feature I am looking for is the UPDATE FROM statement, which is supported only in SQLite 3.33 onwards.
https://www.sqlite.org/lang_update.html
While in buster repository, the latest available version is 3.27, bullseye has 3.34. I tried pointing the apt sources to bullseye repository, but it didn't work. Direct installation of deb package shows missing dependencies. I didn't try too much afterwards as I feared I might break the system. Thank you.
