HAOS add-on "SQLite Web" with Home Assistant Core

[tteck]

Given the ongoing enhancements in SQLite, numerous individuals, myself included, have opted to utilize the built-in database within Home Assistant Core. This decision led me to search for a web-based SQLite database browser. As a result, I've chosen to employ the HAOS add-on SQLite Web, which can be found here: https://github.com/hassio-addons/addon-sqlite-web

Let's install it:
(Only works if you have created a new Home Assistant Core LXC that is utilizing Python 3.12.x)

pip install sqlite-web
cat <<EOF >/etc/systemd/system/sqlite-web.service
[Unit]
Description=sqlite-web

[Service]
Type=simple
ExecStart=/root/.pyenv/versions/3.12.1/bin/sqlite_web -H 0.0.0.0 -p 8585 /root/.homeassistant/home-assistant_v2.db

[Install]
WantedBy=multi-user.target
EOF
systemctl enable -q --now sqlite-web

SQLite Web Interface IP:8585

[tteck]

With Home Assistant Container:
(Only difference is the database path)

pip install sqlite-web
cat <<EOF >/etc/systemd/system/sqlite-web.service
[Unit]
Description=sqlite-web

[Service]
Type=simple
ExecStart=/root/.pyenv/versions/3.12.1/bin/sqlite_web -H 0.0.0.0 -p 8585 /var/lib/docker/volumes/hass_config/_data/home-assistant_v2.db

[Install]
WantedBy=multi-user.target
EOF
systemctl enable -q --now sqlite-web

SQLite Web Interface IP:8585

[tteck]

With Dockge Home Assistant Container:
(Only difference is the database path, and install pip)

apt install -y pip
pip install sqlite-web
cat <<EOF >/etc/systemd/system/sqlite-web.service
[Unit]
Description=sqlite-web

[Service]
Type=simple
ExecStart=/root/.pyenv/versions/3.12.1/bin/sqlite_web -H 0.0.0.0 -p 8585 /opt/stacks/homeassistant/config/home-assistant_v2.db

[Install]
WantedBy=multi-user.target
EOF
systemctl enable -q --now sqlite-web

SQLite Web Interface IP:8585