github

Custom SQL query returning 101 rows (hide)

This data as json, CSV

rowidmessagecommits_ftsrank
1 Added pinboard-to-sqlite 8  
2 Added goodreads-to-sqlite 8  
3 List of all current Dogsheep tools 8  
4 Initial commit 8  
5 First release 8  
6 Just pull for dogsheep repos + sqlite-utils and datasette I accidentally started pulling everything from the dependent repos as well. Commit messages with REFRESH_DB in now trigger a rebuild from scratch. 8  
7 --install=datasette-json-html 8  
8 Fetch previous copy of database Also installed missing bs4 dependency 8  
9 Scrape dependents demo, refs #34 8  
10 Release 2.1, refs #34 8  
11 Install test dependencies, refs #34 8  
12 New scrape-dependents command, refs #34 8  
13 Default milestones facets are now repo and state 8  
14 Release 2.0 Backwards incompatible schema change, refs #31 8  
15 Removed debug output, refs #32 8  
16 Added missing issue-comments.json, refs #32 8  
17 Debug list of files in tests, for #32 8  
18 Fix for issue_comments bug #32 Refs #31 8  
19 Fix for creator foreign key on milestones, refs #31 8  
20 Foreign keys for milestones table, refs #31 8  
21 Use foreign key to repos table on issues and milestones, refs #31 8  
22 milestones now has FK to creator, plus repo column - closes #29 8  
23 Ensure issues.milestone/assignee are integers, closes #30 8  
24 Ignore *.json and *.db and .DS_Store 8  
25 Release 1.1 8  
26 Note that demo includes datasette and sqlite-utils now 8  
27 Demo also pulls datasette and sqlite-utils 8  
28 Handle 204 No Content from GitHub API, refs #28 8  
29 New contributors command, refs #28 8  
30 Use INTEGER for organization column, fixes #27 8  
31 Updated foreign keys test, refs #27 8  
32 Extract organizaion to users table, refs #27 8  
33 Add datasette-pretty-json to demo 8  
34 Release 1.0.1 With bug fix for #26 8  
35 Send topic Accept header in fetch_repo() too, closes #26 8  
36 Also pull issue comments, refs #25 8  
37 --install=py-gfm 8  
38 --service github-to-sqlite 8  
39 Configure demo with demo-metadata.json This includes datasette-render-markdown 8  
40 Release 1.0, refs #23 8  
41 Link to demo from README, refs #13 and #23 8  
42 datasette-search-all plugin, refs #13 8  
43 Install datasette (for datasette publish) - refs #13 8  
44 Install sqlite3 in action, refs #13 8  
45 Redact email addresses before publishing 8  
46 Explicit title/description columns on milestone, refs #13 8  
47 Handle repos with no commits, closes #22 Refs #21 8  
48 Raise GitHub API errors as exceptions, refs #21 8  
49 Fixed bad bash syntax, refs #13 8  
50 Expose GITHUB_ACCESS_TOKEN env variable, refs #13 8  
51 Cat auth.json - revoke token immediately after this run, refs #13 8  
52 Cat auth.json - revoke token immediately after this run, refs #13 8  
53 Removed some debugging, refs #13 8  
54 No need for explicit auth.json if I get the key right, refs #13 8  
55 Revert "More debugging for actions, refs #13" This reverts commit aca2823f1987fafd1dfead79a275ce3819168f2a. 8  
56 More debugging for actions, refs #13 8  
57 Debug assertion, refs #13 8  
58 Just run against dogsheep repos, refs #13 Otherwise the demo will leak my private simonw repos 8  
59 Explicit auth.json, refs #13 8  
60 More action debugging, refs #13 8  
61 Some actions debugging output, refs #13 8  
62 Write auth.json with plain echo, refs #13 8  
63 Use jq to create auth.json Refs #13 8  
64 Deploy demo using Actions, refs #13 8  
65 raw_authors plus handle null authors, closes #18 8  
66 Upgrade to sqlite-utils 2.x, closes #20 8  
67 assets in a separate table, closes #15 8  
68 Full-text search for more tables, closes #19 8  
69 Release 0.7 8  
70 Docs for commits command, closes #17 8  
71 commits now only gets new commits unless --all, refs #17 8  
72 github-to-sqlite commits command, refs #17 8  
73 Release 0.6 8  
74 --auth is now optional, closes #9 8  
75 'github-to-sqlite repos' now accepts multiple usernames 8  
76 Fetch repo topics using Accept header 8  
77 'releases' command to fetch releases, closes #11 8  
78 Rename test file so it actually runs 8  
79 Release 0.5 8  
80 issue-comments command, closes #7 Also added --issue option to issues command, for fetching one specific issue. 8  
81 alter=True when upserting users 8  
82 Release 0.4 8  
83 'github-to-sqlite repos' command, closes #3 8  
84 Release 0.3 8  
85 Extract license from repos table, closes #2 8  
86 Release 0.2 8  
87 github-to-sqlite starred' command, closes #1 8  
88 Release 0.1.1 8  
89 Removed accidental debugging code 8  
90 Implemented 'issues' OAuthed data fetching 8  
91 Fixed README title 8  
92 Initial working version * "github-to-sqlite auth" command saves a token to auth.json * "github-to-sqlite issues" command only works with --load= 8  
93 Release 0.2 8  
94 Order of files in zip does not matter 8  
95 Implemented location-history import command 8  
96 Adjust sort order in test 8  
97 Use pytest -vv 8  
98 Initial working version 8  
99 clarification in README 8  
100 Release 0.3.1 Updated README for PyPI 8  
101 Added "Browsing your data with Datasette" section 8