- Sep 14, 2023
-
-
And moving to my fork due to https://github.com/sqlc-dev/sqlc/issues/2729. Also requires updating the project name since the rename.
-
- Jun 17, 2023
-
-
Jamie Tanna authored
Now we have `table-joiner`, we can tweak how `endoflifedate` functionality works to reduce unnecessary duplication in the table generation, similar to `osvdev`, by creating a multi-join-able table. This requires a refactor of the existing table schema for end-of-life data, which is a breaking change. We can also simplify the query by looking at distinct packages across the projects, instead of retrieving everything, which in a larger database, resulted in 1/5 the size of queried rows. To make the `JOIN` work, we need a slightly more complex `inner join`, which makes sure to handle the (newly added) `current_version` field, as it may be NULL.
-
- Mar 04, 2023
-
-
Jamie Tanna authored
As part of #12, we want to query endoflife.date for EOL data for different dependencies. This also includes some initial support for some parsing Product + Cycle information from a given dependency.
-
- Feb 21, 2023
-
-
Jamie Tanna authored
To simplify onboarding and the structure, rather than having a lot of top-level packages we can put them under `datasources`. This also refactors the `db init` command to use a consistent interface for creation of tables, rather than it being done in the command itself.
-
- Feb 20, 2023
-
-
Jamie Tanna authored
Although the data isn't nearly as right as Renovate, it's handy to have both datasources available. Closes #6.
-
- Feb 16, 2023
-
-
Jamie Tanna authored
As part of the longer piece of work to introduce a suite of tools for managing dependency-management-data, we're starting with the commands to bootstrap a DMD SQLite database. This mirrors the `filter.rb` from renovate-graph with some additional data points we've found useful at Deliveroo. We use sqlc to make it nicer to interact with our database in a strongly typed fashion. As it doesn't support migrations - and we're not yet at the point we need migrations - we can simply just run the `CREATE ...` steps. Closes #2
-