Getting Started (with the example data)

If you don't (yet) want to use DMD with your own data, it's best to check out the example project, which provides some a pre-seeded database, and the associated data exports that you can test the experience with, as well as seeing how it has configured the tooling to build the database.

You can download the example database from the latest GitLab CI build and download the artifacts from the build-database job.

Alternatively, you can use the dmd-example CLI:

$ go install gitlab.com/tanna.dev/dependency-management-data-example/cmd/dmd-example@latest
$ dmd-example download
Successfully downloaded `dmd.db` (from the last run at dmd.db) to `2023-04-20 09:42:37.498 +0000 UTC`
$ ls dmd.db
dmd.db
$ dmd-example shell
# SQLite version 3.39.5 2022-10-14 20:58:05
# Enter ".help" for usage hints.
# sqlite>

The example data has a corresponding deployment of the DMD web application at dependency-management-data-example.fly.dev.

Some examples of queries:

• Show the use of unstable versions - select * from renovate where version like '0.%' or version like 'v0.%'; (web link)
• Show the list of packages by package manager - SELECT package_manager, count(*) from renovate group by package_manager order by count(*) desc; (web link)