Home Assistant Community Add-on: SQLite Web

ludeeus · September 16, 2018, 9:03pm

This add-on is provided by the Home Assistant Community Add-ons project.

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.

Search for the “SQLite Web” add-on in the add-on store and install it.
Start the “SQLite Web” add-on
Check the logs of the “SQLite Web” add-on to see if everything went well.
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:

The Home Assistant Community Add-ons Discord chat server for add-on support and feature requests.
The Home Assistant Discord chat server for general Home Assistant discussions and questions.
Join the Reddit subreddit in /r/homeassistant

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:

Open an issue for the add-on: SQLite Web
For general repository issues or add-on ideas open an issue here

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.

ludeeus · September 16, 2018, 10:06pm

Saved for future use…

ludeeus · September 28, 2018, 8:00pm

Release v0.2.0

Full Changelog

Changed

Adds Hassio API role to configuration

Upgrades GCC/G++ to 6.4.0-r9
upgrades Datasette to 0.25
Upgrades peewee to 3.7.0
Upgrades sqlite-web to 0.3.5

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

ludeeus · March 24, 2019, 12:27pm

v1.0.0

frenck · April 22, 2019, 8:30am

Release v1.1.0

Full Changelog

This is a general maintenance release.

Changes

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

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

ludeeus · May 18, 2019, 10:10am

Release of add-on SQLite Web 1.2.0

Changes

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

Full Changelog

frenck · August 23, 2019, 10:23pm

Release v2.0.0

Full Changelog

This release add ingress support!

Changes

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

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

frenck · November 25, 2019, 8:48pm

Release v2.0.1

Full Changelog

This is a general maintenance release.

Changes

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

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

febalci · November 29, 2019, 9:44am

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

ludeeus · November 29, 2019, 12:18pm

Correct, this is for SQLite only.

frenck · January 5, 2020, 8:12pm

Release v2.1.0

Full Changelog

This is a general maintenance release.

Changes

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

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

frenck · February 23, 2020, 3:22pm

Release v2.2.0

Full Changelog

This is a general maintenance release.

Changes

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

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

frenck · March 21, 2020, 9:27am

Release v2.2.1

Full Changelog

This is a general maintenance release.

Changes

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

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

vukisz · November 24, 2020, 8:09am

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

jap42 · June 8, 2021, 11:00pm

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

sergioalegre · July 23, 2021, 10:48am

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

Daniel_Furrer · November 7, 2021, 10:48pm

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.

denilsonsa · November 8, 2021, 9:00am

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.)

locorotondo-gitter · February 1, 2022, 7:07pm

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).

nikee · April 4, 2022, 12:55pm

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