I compiled sqlite3 as @ColinRobbins suggested, but adding a different prefix. Just change the
./configure
to
./configure --prefix=/opt/sqlite
Then, I edited the systemctl script (/etc/systemd/system/[email protected]) to point at the new libs:
[Unit]
Description=Home Assistant
After=network-online.target[Service]
Type=simple
User=%i
Environment=“GPIOZERO_PIN_FACTORY=pigpio”
Environment=“PIGPIO_ADDR=127.0.0.1”
Environment=“LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/sqlite//lib”
ExecStart=/opt/homeassistant/bin/hass -c “/home/%i/.homeassistant”[Install]
WantedBy=multi-user.target
Pretty clean.