repos
16 rows where default_branch = "main", license = "apache-2.0", stargazers_count > 10 and topics contains "sqlite"
This data as json, CSV (advanced)
Suggested facets: owner, homepage, language, has_projects, has_wiki, has_pages, forks_count, open_issues_count, topics, forks, open_issues, permissions, delete_branch_on_merge, network_count, subscribers_count, has_discussions, security_and_analysis, created_at (date), updated_at (date), pushed_at (date), topics (array)
id ▼ | node_id | name | full_name | private | owner | html_url | description | fork | created_at | updated_at | pushed_at | homepage | size | stargazers_count | watchers_count | language | has_issues | has_projects | has_downloads | has_wiki | has_pages | forks_count | archived | disabled | open_issues_count | license | topics | forks | open_issues | watchers | default_branch | permissions | organization | temp_clone_token | allow_squash_merge | allow_merge_commit | allow_rebase_merge | delete_branch_on_merge | network_count | subscribers_count | parent | source | allow_auto_merge | allow_forking | visibility | is_template | template_repository | allow_update_branch | use_squash_pr_title_as_default | web_commit_signoff_required | squash_merge_commit_title | merge_commit_title | has_discussions | security_and_analysis |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107914493 | MDEwOlJlcG9zaXRvcnkxMDc5MTQ0OTM= | datasette | simonw/datasette | 0 | simonw 9599 | https://github.com/simonw/datasette | An open source multi-tool for exploring and publishing data | 0 | 2017-10-23T00:39:03Z | 2023-07-19T01:56:05Z | 2023-07-13T09:30:37Z | https://datasette.io | 6190 | 7995 | 7995 | Python | 1 | 0 | 1 | 1 | 0 | 555 | 0 | 0 | 528 | Apache License 2.0 apache-2.0 | ["asgi", "automatic-api", "csv", "datasets", "datasette", "datasette-io", "docker", "json", "python", "sql", "sqlite"] | 555 | 528 | 7995 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | 1 | 1 | 1 | 1 | 555 | 102 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 1 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | |||||
140912432 | MDEwOlJlcG9zaXRvcnkxNDA5MTI0MzI= | sqlite-utils | simonw/sqlite-utils | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils | Python CLI utility and library for manipulating SQLite databases | 0 | 2018-07-14T03:21:46Z | 2023-07-17T09:23:52Z | 2023-07-03T05:42:28Z | https://sqlite-utils.datasette.io | 1543 | 1230 | 1230 | Python | 1 | 1 | 1 | 0 | 0 | 87 | 0 | 0 | 83 | Apache License 2.0 apache-2.0 | ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"] | 87 | 83 | 1230 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | 1 | 1 | 1 | 0 | 87 | 20 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | |||||
197882382 | MDEwOlJlcG9zaXRvcnkxOTc4ODIzODI= | healthkit-to-sqlite | dogsheep/healthkit-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/healthkit-to-sqlite | Convert an Apple Healthkit export zip to a SQLite database | 0 | 2019-07-20T05:03:12Z | 2023-07-13T18:49:05Z | 2023-01-01T17:29:57Z | https://datasette.io/tools/healthkit-to-sqlite | 29 | 167 | 167 | Python | 1 | 1 | 1 | 1 | 0 | 7 | 0 | 0 | 12 | Apache License 2.0 apache-2.0 | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] | 7 | 12 | 167 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 7 | 4 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | ||||
205429375 | MDEwOlJlcG9zaXRvcnkyMDU0MjkzNzU= | swarm-to-sqlite | dogsheep/swarm-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/swarm-to-sqlite | Create a SQLite database containing your checkin history from Foursquare Swarm | 0 | 2019-08-30T17:37:29Z | 2023-06-08T10:00:26Z | 2023-04-11T03:18:16Z | 34 | 55 | 55 | Python | 1 | 1 | 1 | 1 | 0 | 3 | 0 | 0 | 4 | Apache License 2.0 apache-2.0 | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] | 3 | 4 | 55 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 3 | 6 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | |||||
206156866 | MDEwOlJlcG9zaXRvcnkyMDYxNTY4NjY= | twitter-to-sqlite | dogsheep/twitter-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/twitter-to-sqlite | Save data from Twitter to a SQLite database | 0 | 2019-09-03T19:30:08Z | 2023-07-05T16:03:06Z | 2022-12-28T23:33:31Z | 307 | 387 | 387 | Python | 1 | 1 | 1 | 1 | 0 | 23 | 0 | 0 | 19 | Apache License 2.0 apache-2.0 | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] | 23 | 19 | 387 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 23 | 7 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | |||||
207052882 | MDEwOlJlcG9zaXRvcnkyMDcwNTI4ODI= | github-to-sqlite | dogsheep/github-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/github-to-sqlite | Save data from GitHub to a SQLite database | 0 | 2019-09-08T02:50:28Z | 2023-07-04T02:50:54Z | 2023-04-26T17:36:17Z | https://github-to-sqlite.dogsheep.net/ | 150 | 314 | 314 | Python | 1 | 1 | 1 | 1 | 0 | 38 | 0 | 0 | 23 | Apache License 2.0 apache-2.0 | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] | 38 | 23 | 314 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 38 | 7 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | ||||
213286752 | MDEwOlJlcG9zaXRvcnkyMTMyODY3NTI= | pocket-to-sqlite | dogsheep/pocket-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/pocket-to-sqlite | Create a SQLite database containing data from your Pocket account | 0 | 2019-10-07T03:24:14Z | 2023-07-18T15:50:48Z | 2023-07-10T19:24:26Z | 25 | 92 | 92 | Python | 1 | 1 | 1 | 1 | 0 | 4 | 0 | 0 | 5 | Apache License 2.0 apache-2.0 | ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] | 4 | 5 | 92 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 4 | 6 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "enabled"}} | |||||
219372133 | MDEwOlJlcG9zaXRvcnkyMTkzNzIxMzM= | sqlite-transform | simonw/sqlite-transform | 0 | simonw 9599 | https://github.com/simonw/sqlite-transform | Tool for running transformations on columns in a SQLite database | 0 | 2019-11-03T22:07:53Z | 2021-07-21T00:59:32Z | 2021-07-21T00:59:29Z | 32 | 25 | 25 | Python | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 4 | Apache License 2.0 apache-2.0 | ["sqlite", "datasette-io", "datasette-tool"] | 1 | 4 | 25 | main | {"admin": true, "push": true, "pull": true} | 1 | 1 | 1 | 0 | 1 | 1 | |||||||||||||||||
303218369 | MDEwOlJlcG9zaXRvcnkzMDMyMTgzNjk= | evernote-to-sqlite | dogsheep/evernote-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/evernote-to-sqlite | Tools for converting Evernote content to SQLite | 0 | 2020-10-11T21:45:49Z | 2023-06-26T01:36:28Z | 2021-11-02T20:04:32Z | 51 | 35 | 35 | Python | 1 | 1 | 1 | 1 | 0 | 5 | 0 | 0 | 5 | Apache License 2.0 apache-2.0 | ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] | 5 | 5 | 35 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 5 | 6 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "disabled"}} | |||||
561894605 | R_kgDOIX3UzQ | sqlite-regex | asg017/sqlite-regex | 0 | asg017 15178711 | https://github.com/asg017/sqlite-regex | A fast regular expression SQLite extension, written in Rust | 0 | 2022-11-04T18:31:01Z | 2023-03-19T08:02:55Z | 2023-03-08T17:03:09Z | 185 | 107 | 107 | Rust | 1 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 4 | Apache License 2.0 apache-2.0 | ["sqlite", "sqlite-extension"] | 2 | 4 | 107 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 2 | 2 | 1 | public | 0 | 0 | 0 | ||||||||||||||||
561895986 | R_kgDOIX3aMg | sqlite-jsonschema | asg017/sqlite-jsonschema | 0 | asg017 15178711 | https://github.com/asg017/sqlite-jsonschema | A SQLite extension for validating JSON objects with JSON Schema | 0 | 2022-11-04T18:34:59Z | 2023-03-06T19:18:32Z | 2023-03-06T22:15:05Z | https://alexgarcia.xyz/sqlite-jsonschema | 170 | 19 | 19 | TypeScript | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | ["sqlite", "sqlite-extension"] | 0 | 0 | 19 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 0 | 1 | 1 | public | 0 | 0 | 0 | |||||||||||||||
580533978 | R_kgDOIpo-2g | sqlite-ulid | asg017/sqlite-ulid | 0 | asg017 15178711 | https://github.com/asg017/sqlite-ulid | A SQLite extension for generating and working with ULIDs | 0 | 2022-12-20T19:58:44Z | 2023-03-12T20:48:09Z | 2023-03-11T06:14:27Z | 139 | 66 | 66 | Python | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | ["sqlite", "sqlite-extension"] | 1 | 0 | 66 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 1 | 1 | 1 | public | 0 | 0 | 0 | ||||||||||||||||
586060402 | R_kgDOIu6Scg | sqlite-fastrand | asg017/sqlite-fastrand | 0 | asg017 15178711 | https://github.com/asg017/sqlite-fastrand | A SQLite extension for quickly generating random numbers, booleans, characters, and blobs | 0 | 2023-01-06T20:46:06Z | 2023-02-11T03:47:32Z | 2023-03-08T17:10:52Z | 74 | 13 | 13 | Rust | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | ["datasette-plugin", "sqlite", "sqlite-extension"] | 0 | 0 | 13 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 0 | 1 | 1 | public | 0 | 0 | 0 | ||||||||||||||||
611552758 | R_kgDOJHON9g | apple-notes-to-sqlite | dogsheep/apple-notes-to-sqlite | 0 | dogsheep 53015001 | https://github.com/dogsheep/apple-notes-to-sqlite | Export Apple Notes to SQLite | 0 | 2023-03-09T03:44:10Z | 2023-07-15T19:41:49Z | 2023-04-02T15:37:34Z | 21 | 124 | 124 | Python | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 7 | Apache License 2.0 apache-2.0 | ["apple-notes", "datasette", "datasette-tool", "dogsheep", "sqlite"] | 1 | 7 | 124 | main | {"admin": true, "maintain": true, "push": true, "triage": true, "pull": true} | dogsheep 53015001 | 1 | 1 | 1 | 0 | 1 | 5 | 0 | 1 | public | 0 | 0 | 0 | 0 | COMMIT_OR_PR_TITLE | MERGE_MESSAGE | 0 | {"secret_scanning": {"status": "disabled"}, "secret_scanning_push_protection": {"status": "disabled"}, "dependabot_security_updates": {"status": "disabled"}} | |||||
618792846 | R_kgDOJOIHjg | datasette-ml | rclement/datasette-ml | 0 | rclement 1238873 | https://github.com/rclement/datasette-ml | A Datasette plugin providing an MLOps platform to train, eval and predict machine learning models | 0 | 2023-03-25T11:18:48Z | 2023-05-23T14:35:15Z | 2023-07-12T16:38:52Z | 665 | 12 | 12 | Python | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | Apache License 2.0 apache-2.0 | ["ai", "datasette", "datasette-plugin", "machine-learning", "mlops", "python", "scikit-learn", "sql", "sqlite"] | 0 | 3 | 12 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 0 | 2 | 1 | public | 0 | 0 | 0 | ||||||||||||||||
630446189 | R_kgDOJZPYbQ | sqlite-ml | rclement/sqlite-ml | 0 | rclement 1238873 | https://github.com/rclement/sqlite-ml | An SQLite extension for machine learning | 0 | 2023-04-20T11:56:53Z | 2023-07-13T21:14:27Z | 2023-07-12T16:25:34Z | 109 | 28 | 28 | Python | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 4 | Apache License 2.0 apache-2.0 | ["machine-learning", "mlops", "sql", "sqlite"] | 1 | 4 | 28 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": true} | 1 | 5 | 1 | public | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [repos] ( [id] INTEGER PRIMARY KEY, [node_id] TEXT, [name] TEXT, [full_name] TEXT, [private] INTEGER, [owner] INTEGER REFERENCES [users]([id]), [html_url] TEXT, [description] TEXT, [fork] INTEGER, [created_at] TEXT, [updated_at] TEXT, [pushed_at] TEXT, [homepage] TEXT, [size] INTEGER, [stargazers_count] INTEGER, [watchers_count] INTEGER, [language] TEXT, [has_issues] INTEGER, [has_projects] INTEGER, [has_downloads] INTEGER, [has_wiki] INTEGER, [has_pages] INTEGER, [forks_count] INTEGER, [archived] INTEGER, [disabled] INTEGER, [open_issues_count] INTEGER, [license] TEXT, [topics] TEXT, [forks] INTEGER, [open_issues] INTEGER, [watchers] INTEGER, [default_branch] TEXT, [permissions] TEXT, [organization] INTEGER REFERENCES [users]([id]), [temp_clone_token] TEXT, [allow_squash_merge] INTEGER, [allow_merge_commit] INTEGER, [allow_rebase_merge] INTEGER, [delete_branch_on_merge] INTEGER, [network_count] INTEGER, [subscribers_count] INTEGER, [parent] TEXT, [source] TEXT, [allow_auto_merge] INTEGER, [allow_forking] INTEGER, [visibility] TEXT, [is_template] INTEGER, [template_repository] TEXT, [allow_update_branch] INTEGER, [use_squash_pr_title_as_default] INTEGER, [web_commit_signoff_required] INTEGER, [squash_merge_commit_message] TEXT, [squash_merge_commit_title] TEXT, [merge_commit_message] TEXT, [merge_commit_title] TEXT, [has_discussions] INTEGER, [security_and_analysis] TEXT, FOREIGN KEY(license) REFERENCES licenses(key) ); CREATE INDEX [idx_repos_license] ON [repos] ([license]); CREATE INDEX [idx_repos_organization] ON [repos] ([organization]); CREATE INDEX [idx_repos_owner] ON [repos] ([owner]);