repos_starred (view)
20 rows where topics = "["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"]"
This data as json
topics 1 ✖
- ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] · 20 ✖
created_at 1 ✖
0 records
CREATE VIEW repos_starred AS select stars.starred_at, starring_user.login as starred_by, repos.* from repos join stars on repos.id = stars.repo join users as starring_user on stars.user = starring_user.id join users on repos.owner = users.id order by starred_at desc;