commits_fts

3,922 rows

✖

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE [commits_fts] USING FTS5 (
                [message],
                content=[commits]
            );