Home Assistant Community Add-on: SQLite Web

Installation Home Assistant OS
,
#1

hassio-addons
hassio-addons512×512 41 KB
This add-on is provided by the Home Assistant Community Add-ons project.

GitHub Release GitLab CI Project Stage Project Maintenance

Supports armhf Architecture Supports aarch64 Architecture Supports amd64 Architecture Supports i386 Architecture

Explore your Home Assistant database from your web browser!

About

This enables you to easily explore all tables and content that is saved in your database.

Installation

The installation of this add-on is pretty straightforward and not different in comparison to installing any other add-on.

  1. Search for the “SQLite Web” add-on in the add-on store and install it.
  2. Start the “SQLite Web” add-on
  3. Check the logs of the “SQLite Web” add-on to see if everything went well.
  4. Click “OPEN WEB UI” to open the SQLite Web interface.

Support

You can always get support here at the Home Assistant community forums, join the conversation!

You have several options to get them answered:

You could also open an issue on GitHub, in case you ran into a bug, or maybe you have an idea on improving the add-on:

We will do our best to help you out!

Repository on GitHub

Looking for more add-ons?

The primary goal of our add-ons project is to provide you (as a Home Assistant user) with additional, high quality, add-ons that allow you to take your automated home to the next level.

Check out some of our other add-ons in our Home Assistant Community Add-on project.

5 Likes
Extract SOME old data from "home-assistant_v2.db" and export to new home-assistant_v2.db file
Energy Dashboard cost/compensation calculation stopped working when I upgraded to 2021.9
Console Access on OVA (was: Password for OVA?)
#2

Saved for future use…

#3

:tada: Release v0.2.0

Full Changelog

Changed

  • :snowflake:Adds Hassio API role to configuration
  • :arrow_up: Upgrades GCC/G++ to 6.4.0-r9
  • :arrow_up: upgrades Datasette to 0.25
  • :arrow_up: Upgrades peewee to 3.7.0
  • :arrow_up: Upgrades sqlite-web to 0.3.5

Questions? Join our Discord server! https://discord.me/hassioaddons

#4

v1.0.0

#5

:tada: Release v1.1.0

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Upgrades base image to Python 1.1.0
  • :arrow_up: Upgrades gcc/g++ to 8.3.0-r0
  • :sparkles: Adds ARMv7 support
  • :hammer: Makes log_level optional
  • :ambulance: Workaround Docker issue by reinstating legacy tags
  • :hammer: Removes unused while loop
  • :hammer: Makes NGinx wait for SQLite Web before starting
  • :fire: Removes default config options
  • :hammer: Refactor of init scripts
  • :fire: Removes IPv6 switch
  • :fire: Removes custom log format override
  • :sparkles: Adds port descriptions
  • :books: Updates documentation to match latest changes
  • :arrow_up: Updates peewee to v3.9.4 (#24)

Questions? Join our Discord server! https://discord.me/hassioaddons

#6

:arrow_up: Release of add-on SQLite Web 1.2.0

Changes

  • :arrow_up: Updates peewee to v3.9.5 (#25) @renovate[bot]
  • :arrow_up: Updates lua-resty-http to version 0.13-r0 (#27)
  • :arrow_up: Updates nginx-mod-http-lua to version 1.14.2-r1 (#28)
  • :arrow_up: Updates nginx to version 1.14.2-r1 (#29)
  • :arrow_up: Updates datasette to v0.27.1 (#30) @renovate[bot]
  • :arrow_up: Updates flask to v1.0.3 (#33) @renovate[bot]

Full Changelog

#7

:tada: Release v2.0.0

Full Changelog

This release add ingress support! :tada:

:hammer: Changes

  • :pencil2: Maintaince -> Maintenance
  • :arrow_up: Updates flask to v1.1.1 (#37)
  • :arrow_up: Updates datasette to v0.29.2 (#39)
  • :arrow_up: Updates peewee to v3.10.0 (#44)
  • :arrow_up: Upgrades add-on base image to v2.0.3
  • :arrow_up: Upgrades cython to 0.29.10-r0
  • :racehorse: Improves build speed by leveraging the Home Assistant Wheels server
  • :sparkles: Adds Ingress support (#45)
  • :arrow_up: Upgrades nginx to 1.16.1-r0
  • :hammer: Updates HA Auth URL in NGinx LUA script
  • :arrow_up: Upgrades add-on base image to v2.1.0
  • :hammer: Use Hass.io DNS as NGinx resolver

Questions? Join our Discord server! https://discord.me/hassioaddons

#8

:tada: Release v2.0.1

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :sparkles: Adds icon to show in the sidebar (#48)
  • :arrow_up: Updates peewee to v3.11.2 (#52)
  • :arrow_up: Upgrades add-on base image to v3.0.0
  • :arrow_up: Updates datasette to v0.32 (#57)
  • :arrow_up: Upgrades add-on base image to v3.0.1
  • :arrow_up: Upgrades nginx to 1.16.1-r1

Questions? Join our Discord server! https://discord.me/hassioaddons

#9

As i get it, there is no way to use this with mariadb on hassio?

#10

Correct, this is for SQLite only.

#11

:tada: Release v2.1.0

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Updates peewee to v3.13.1 (#61)
  • :arrow_up: Updates datasette to v0.33 (#62)
  • :fireworks: Updates maintenance/license year to 2020
  • :books: Adjust add-on installation instructions
  • :pencil2: Fixes some spelling and grammar
  • :arrow_up: Upgrades add-on base image to v4.0.0
  • :arrow_up: Upgrades gcc to 9.2.0-r3
  • :arrow_up: Upgrades nginx to 1.16.1-r4
  • :arrow_up: Upgrades lua-resty-http to 0.15-r0
  • :arrow_up: Upgrades cython to 0.29.14-r0
  • :hammer: Update Hass.io wheels for Alpine 3.11
  • :ambulance: Only activate datasette proxy when enabled
  • :ambulance: Fix Pyhton 3.7->3.8 paths

Questions? Join our Discord server! https://discord.me/hassioaddons

#12

:tada: Release v2.2.0

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Upgrades nginx to 1.16.1-r6
  • :books: Update add-on documentation to use new YAML configuration format
  • :hammer: Re-branding
  • :hammer: Update add-on config with new password & list features
  • :hammer: Updates for upstream Supervisor changes
  • :arrow_up: Updates datasette to v0.36 (#65)
  • :arrow_up: Upgrades add-on base image to v5.0.1
  • :hammer: Update community forum links

Questions? Join our Discord server! https://discord.me/hassioaddons

#13

:tada: Release v2.2.1

Full Changelog

This is a general maintenance release.

:hammer: Changes

  • :arrow_up: Updates datasette to v0.38 (#69)
  • :arrow_up: Upgrades add-on base image to v5.0.3
  • :arrow_up: Upgrades gcc to 9.2.0-r4

Questions? Join our Discord server! https://discord.me/hassioaddons

#14

Hi.
Thanks @frenck, neat plugin.
What does “toggle helper tables” do and how does it work? :slight_smile:

1 Like
#16

It would be nice to be able to explore other .DB files in the config. For instance the zigbee.db from the ZHA Intergration.

#17

I used this addon and i must say congrats!

Because a need i moved .db file to non default path, i changed the recorder component, URL setting. It worked for HA, but looks like addon look for it on the default path only isnt it?

Is there any way to tell addon where to look for it?

Thanks in advance

1 Like
#18

It would be great if there was some status indication when executing a query.

E.g. I’m trying to execute the query below from this guide:

SELECT
  SUM(pgsize) bytes,
  name
FROM dbstat
GROUP BY name
ORDER BY bytes DESC

However, when I click Execute nothing happens. It took me a while to figure out that the query takes too long to execute and simpler queries work.

1 Like
#19

Your best bet is to suggest such feature to the original sqlite-web project. Or, better yet, if you have coding experience you can try implementing it yourself.
(The HA add-on just encapsulates that project into a docker image and pre-configures it to run inside HAOS.)

#20

I would welcome this as well. This add-on famously has no configuration options, but maybe a “path to Db” would be a good addition. My db also is not in the standard path (mainly to keep backups small).

#22

Cant find SQLite Web in the AddOn Store.
Has it been removed?