Web Application

dependency-management-data comes with a web application (dmd-web) to make it easier to have a central place to go to view your database.

dmd-web provides a front-end for querying the database in the browser through a couple of means. The web-exposed nature of it also allows you to share common queries in a URL format, rather than passing around complex SQL statements!

dmd-web also has support for viewing the same reports that can be generated on the command-line through the browser.

The example data has an associated DMD web application which can be found at dependency-management-data-example.fly.dev.

User-provided configuration can be added to the web application to provide context around what the app is, information about when the data was last updated, and also allows for adding custom key-value data. Check out cmd/dmd-web/cmd/userconfig.go for more detail.

You can produce JSON-formatted logs by running dmd-web like so:

env LOG_FORMAT=json dmd-web ...

SQL Browser

Datasette

The optimum solution for browsing the database can be used by dmd-web embedding Datasette as an interactive SQLite browser.

Datasette is an excellent UI, and dmd-web will default to invoking datasette when it starts.

This can be reached at the /datasette/ URL on your deployed dmd-web instance.

It is also possible to disable the use of datassete with the --no-datasette command-line flag:

dmd-web --db /path/to/dmb.db --no-datasette

This replaces calls to the /datasette/ URL with the Embedded SQL browser.

Embedded SQL browser

Alternatively, as of dmd-web v0.97.0, it is possible to use a lightweight SQL browser implementation that's implemented in dmd-web.

This can be reached at the /browser/ URL on your deployed dmd-web instance.

The embedded browser encodes the SQL query in the querystring with Base64 URL encoding.