commits_fts

3,784 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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