search

dogsheep / github-to-sqlite

Save data from GitHub to a SQLite database
https://github-to-sqlite.dogsheep.net/
Apache License 2.0
402 stars 43 forks source link

issues foreign key to repo isn't working #39

Closed simonw closed 4 years ago

simonw commented 4 years ago

https://github-to-sqlite.dogsheep.net/github/issues?_facet=repo

github__issues__2_303_rows_where_sorted_by_updated_at_descending

If the foreign key was working those would be repository names.

From the schema at the bottom of the page:

   [repo] TEXT,

That's the wrong type and not a foreign key.

simonw commented 4 years ago

I think this is fixed: https://github-to-sqlite.dogsheep.net/github/issues?_facet=repo