Release v0.2.0
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.5Questions? Join our Discord server! https://discord.me/hassioaddons
Release v1.1.0This 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
Release of add-on SQLite Web 1.2.0
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] Release v2.0.0This 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 resolverQuestions? Join our Discord server! https://discord.me/hassioaddons
Release v2.0.1This 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-r1Questions? Join our Discord server! https://discord.me/hassioaddons
As i get it, there is no way to use this with mariadb on hassio?
Correct, this is for SQLite only.
Release v2.1.0This 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 pathsQuestions? Join our Discord server! https://discord.me/hassioaddons
Release v2.2.0This 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 linksQuestions? Join our Discord server! https://discord.me/hassioaddons
Release v2.2.1This 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-r4Questions? Join our Discord server! https://discord.me/hassioaddons
Hi.
Thanks @frenck, neat plugin.
What does “toggle helper tables” do and how does it work? 
It would be nice to be able to explore other .DB files in the config. For instance the zigbee.db from the ZHA Intergration.
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
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.
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.)
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).
Cant find SQLite Web in the AddOn Store.
Has it been removed?
No it is still there
Did you open the add-on store with the button in the lower right corner?
