SQLite Web Frontends


Datasette is an open source multi-tool for exploring and publishing data. It provides a web frontend for SQLite databases that can be used to explore your tasks in following way:

datasette ~/TaskLite/main.db

You can then use any of TaskLite's predefined views:

Generate custom view by appending the SQL query to the URL. For example:*+FROM+tasks+WHERE+body+LIKE+%27%25xyz%25%27

You can then bookmark those views for easy access.

Screenshot of web app

SQLite Web

Another way to host a simple web frontend is SQLite Web.

You can run it with Docker like this:

docker run -it --rm \
  -p 8080:8080 \
  -v ~/TaskLite:/data \
  -e SQLITE_DATABASE=main.db \