repos
87 rows where open_issues_count = 0 sorted by description
This data as json, CSV (advanced)
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 | has_discussions | forks_count | archived | disabled | open_issues_count | license | allow_forking | is_template | web_commit_signoff_required | topics | visibility | forks | open_issues | watchers | default_branch | organization |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
592995639 | R_kgDOI1hlNw | datasette-big-local | simonw/datasette-big-local | 0 | simonw 9599 | https://github.com/simonw/datasette-big-local | Integration between Datasette and Big Local News | 0 | 2023-01-25T01:08:21Z | 2023-01-31T23:58:14Z | 2023-01-26T19:51:26Z | 53 | 4 | 4 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 1 | 0 | 4 | main | |||
670776182 | R_kgDOJ_s7dg | sqlite-utils-litecli | simonw/sqlite-utils-litecli | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-litecli | Interactive shell for sqlite-utils using litecli | 0 | 2023-07-25T20:12:14Z | 2024-01-13T15:56:48Z | 2023-07-27T03:28:02Z | 169 | 11 | 11 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 11 | main | ||
350895171 | MDEwOlJlcG9zaXRvcnkzNTA4OTUxNzE= | iam-to-sqlite | simonw/iam-to-sqlite | 0 | simonw 9599 | https://github.com/simonw/iam-to-sqlite | Load Amazon IAM data into a SQLite database | 0 | 2021-03-24T00:16:15Z | 2023-03-24T02:53:10Z | 2021-03-24T00:20:26Z | 7 | 8 | 8 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 8 | main | ||
528611541 | R_kgDOH4H41Q | datasette-multiline-links | simonw/datasette-multiline-links | 0 | simonw 9599 | https://github.com/simonw/datasette-multiline-links | Make multiple newline separated URLs clickable in Datasette | 0 | 2022-08-24T22:16:30Z | 2022-08-24T22:16:52Z | 2022-08-24T22:56:16Z | 12 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 1 | 0 | 0 | main | ||
174619733 | MDEwOlJlcG9zaXRvcnkxNzQ2MTk3MzM= | datasette-car-2019 | simonw/datasette-car-2019 | 0 | simonw 9599 | https://github.com/simonw/datasette-car-2019 | Notes from my CAR 2019 Datasette tutorial | 0 | 2019-03-08T22:34:27Z | 2019-10-04T17:35:53Z | 2019-03-09T17:01:11Z | 20 | 7 | 7 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 1 | 0 | 7 | master | ||||
390535500 | MDEwOlJlcG9zaXRvcnkzOTA1MzU1MDA= | datasette-remote-metadata | simonw/datasette-remote-metadata | 0 | simonw 9599 | https://github.com/simonw/datasette-remote-metadata | Periodically refresh Datasette metadata from a remote URL | 0 | 2021-07-28T23:17:19Z | 2022-12-31T17:34:29Z | 2021-12-13T19:40:48Z | 14 | 6 | 6 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 6 | main | ||
677187897 | R_kgDOKF0ROQ | sqlite-utils-jq | simonw/sqlite-utils-jq | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-jq | Plugin adding a jq() SQL function to sqlite-utils | 0 | 2023-08-11T00:45:35Z | 2023-12-31T15:57:19Z | 2023-08-11T00:53:58Z | 3 | 8 | 8 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 8 | main | |||
555992212 | R_kgDOISPElA | datasette-gunicorn | simonw/datasette-gunicorn | 0 | simonw 9599 | https://github.com/simonw/datasette-gunicorn | Plugin for running Datasette using Gunicorn | 0 | 2022-10-22T20:23:57Z | 2023-01-31T20:42:01Z | 2022-12-18T06:46:37Z | https://datasette.io/plugins/datasette-gunicorn | 15 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette", "datasette-plugin"] | public | 1 | 0 | 1 | main | |
184168864 | MDEwOlJlcG9zaXRvcnkxODQxNjg4NjQ= | datasette-render-html | simonw/datasette-render-html | 0 | simonw 9599 | https://github.com/simonw/datasette-render-html | Plugin for selectively rendering the HTML is specific columns | 0 | 2019-04-30T01:21:25Z | 2023-03-25T07:24:10Z | 2023-03-09T02:46:43Z | https://datasette.io/plugins/datasette-render-html | 13 | 4 | 4 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 2 | 0 | 4 | master | ||
438003374 | R_kgDOGhtmrg | datasette-pretty-traces | simonw/datasette-pretty-traces | 0 | simonw 9599 | https://github.com/simonw/datasette-pretty-traces | Prettier formatting for ?_trace=1 traces | 0 | 2021-12-13T19:43:28Z | 2023-01-25T20:57:57Z | 2022-01-14T02:08:51Z | 17 | 5 | 5 | JavaScript | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 5 | main | ||
572254041 | R_kgDOIhvnWQ | datasette-ephemeral-tables | simonw/datasette-ephemeral-tables | 0 | simonw 9599 | https://github.com/simonw/datasette-ephemeral-tables | Provide tables that expire after a time limit | 0 | 2022-11-29T21:54:16Z | 2023-01-01T01:23:54Z | 2022-12-02T00:36:31Z | 22 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main | ||
352249703 | MDEwOlJlcG9zaXRvcnkzNTIyNDk3MDM= | datasette-publish-azure | simonw/datasette-publish-azure | 0 | simonw 9599 | https://github.com/simonw/datasette-publish-azure | Publish Datasette instances to Azure Functions (in progress) | 0 | 2021-03-28T05:35:15Z | 2021-04-17T19:01:07Z | 2021-03-28T05:36:41Z | 3 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 1 | main | |||
254492408 | MDEwOlJlcG9zaXRvcnkyNTQ0OTI0MDg= | big-local-datasette | simonw/big-local-datasette | 0 | simonw 9599 | https://github.com/simonw/big-local-datasette | Publishing a Datasette of open projects from biglocalnews.org | 0 | 2020-04-09T22:35:42Z | 2022-03-22T01:50:38Z | 2022-03-22T17:16:29Z | https://biglocal.datasettes.com/ | 118 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette"] | public | 0 | 0 | 2 | master | ||
279988350 | MDEwOlJlcG9zaXRvcnkyNzk5ODgzNTA= | srccon-2020-datasette | simonw/srccon-2020-datasette | 0 | simonw 9599 | https://github.com/simonw/srccon-2020-datasette | Publishing the SRCCON schedule using Datasette | 0 | 2020-07-15T21:55:13Z | 2020-07-16T19:09:49Z | 2020-07-16T19:09:46Z | https://srccon-2020.datasette.io/ | 13 | 1 | 1 | Python | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "srccon"] | public | 0 | 0 | 1 | main | ||
287625934 | MDEwOlJlcG9zaXRvcnkyODc2MjU5MzQ= | datasette-io-redirect | simonw/datasette-io-redirect | 0 | simonw 9599 | https://github.com/simonw/datasette-io-redirect | Redirect datasette.io to docs.datasette.io | 0 | 2020-08-14T21:18:29Z | 2020-08-14T21:21:00Z | 2020-08-14T21:20:26Z | https://datasette.io/ | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 0 | main | |||
301879297 | MDEwOlJlcG9zaXRvcnkzMDE4NzkyOTc= | buildpack-datasette | simonw/buildpack-datasette | 0 | simonw 9599 | https://github.com/simonw/buildpack-datasette | Repository template for creating a new Datasette buildpack instance | 0 | 2020-10-06T23:31:39Z | 2021-03-12T00:21:17Z | 2020-12-18T02:31:46Z | https://docs.datasette.io/en/stable/deploying.html#deploying-using-buildpacks | 48 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | ["buildpacks", "datasette"] | public | 0 | 0 | 1 | main | |||
589732541 | R_kgDOIyaavQ | datasette-granian | simonw/datasette-granian | 0 | simonw 9599 | https://github.com/simonw/datasette-granian | Run Datasette using the Granian HTTP server | 0 | 2023-01-16T20:04:57Z | 2023-01-31T07:09:42Z | 2024-01-23T20:58:06Z | 11 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette", "datasette-plugin", "granian"] | public | 0 | 0 | 2 | main | ||
576703971 | R_kgDOIl_N4w | datasette-secret-santa | simonw/datasette-secret-santa | 0 | simonw 9599 | https://github.com/simonw/datasette-secret-santa | Run secret santa gift circles using Datasette | 0 | 2022-12-10T17:54:39Z | 2023-11-20T16:36:15Z | 2022-12-11T01:41:10Z | 328 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 1 | 0 | 3 | main | ||
406996472 | MDEwOlJlcG9zaXRvcnk0MDY5OTY0NzI= | datasette-statistics | simonw/datasette-statistics | 0 | simonw 9599 | https://github.com/simonw/datasette-statistics | SQL statistics functions for Datasette | 0 | 2021-09-16T02:51:09Z | 2024-01-05T12:54:25Z | 2023-11-30T23:34:58Z | 20 | 6 | 6 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 1 | 0 | 6 | main | |||
527045109 | R_kgDOH2oR9Q | scotrail-datasette | simonw/scotrail-datasette | 0 | simonw 9599 | https://github.com/simonw/scotrail-datasette | ScotRail announcements in Datasette | 0 | 2022-08-20T21:37:29Z | 2023-11-03T01:24:18Z | 2022-08-21T20:53:05Z | https://scotrail.datasette.io | 50 | 6 | 6 | Shell | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["scotrail"] | public | 0 | 0 | 6 | main | ||
493337430 | R_kgDOHWe7Vg | datasette-screenshots | simonw/datasette-screenshots | 0 | simonw 9599 | https://github.com/simonw/datasette-screenshots | Screenshots of Datasette, taken using shot-scraper | 0 | 2022-05-17T16:49:47Z | 2023-03-07T00:19:02Z | 2023-01-28T05:37:48Z | https://simonw.github.io/datasette-screenshots/ | 32962 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | ["shot-scraper"] | public | 1 | 0 | 3 | main | |||
162077240 | MDEwOlJlcG9zaXRvcnkxNjIwNzcyNDA= | 24ways-datasette | simonw/24ways-datasette | 0 | simonw 9599 | https://github.com/simonw/24ways-datasette | Supporting material for my 24 ways article in 2018 | 0 | 2018-12-17T05:03:57Z | 2021-09-22T04:45:41Z | 2020-05-21T23:37:28Z | https://24ways.org/2018/fast-autocomplete-search-for-your-website/ | 14 | 4 | 4 | Jupyter Notebook | 1 | 1 | 1 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["24ways", "datasette", "jupyter-notebook", "sqlite"] | public | 3 | 0 | 4 | master | |
143637623 | MDEwOlJlcG9zaXRvcnkxNDM2Mzc2MjM= | russian-troll-tweets-datasette | simonw/russian-troll-tweets-datasette | 0 | simonw 9599 | https://github.com/simonw/russian-troll-tweets-datasette | The FiveThirtyEight collection of Russian troll tweets published using Datasette | 0 | 2018-08-05T18:25:00Z | 2021-01-18T05:57:59Z | 2021-01-18T05:57:56Z | http://russian-troll-tweets.datasettes.com/ | 4 | 2 | 2 | Dockerfile | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "fivethirtyeight"] | public | 1 | 0 | 2 | main | ||
419525110 | R_kgDOGQFx9g | datasette-hello-world | simonw/datasette-hello-world | 0 | simonw 9599 | https://github.com/simonw/datasette-hello-world | The hello world of Datasette plugins | 0 | 2021-10-21T00:01:35Z | 2021-11-14T04:58:05Z | 2021-11-14T04:58:36Z | 8 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 0 | main | |||
618571120 | R_kgDOJN6lcA | datasette-no-truncate | simonw/datasette-no-truncate | 0 | simonw 9599 | https://github.com/simonw/datasette-no-truncate | Tiny Datasette plugin to disable text truncation in table displays | 0 | 2023-03-24T19:03:43Z | 2023-03-24T19:04:12Z | 2023-03-24T19:08:40Z | 9 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 0 | main | ||
274264484 | MDEwOlJlcG9zaXRvcnkyNzQyNjQ0ODQ= | sqlite-generate | simonw/sqlite-generate | 0 | simonw 9599 | https://github.com/simonw/sqlite-generate | Tool for generating demo SQLite databases | 0 | 2020-06-22T23:36:44Z | 2023-10-27T22:48:17Z | 2021-02-27T15:25:24Z | https://sqlite-generate-demo.datasette.io/ | 56 | 22 | 22 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette-io", "datasette-tool", "sqlite"] | public | 0 | 0 | 22 | main | |
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 | 2023-01-28T07:04:45Z | 2021-08-02T22:07:57Z | 64 | 30 | 30 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette-io", "datasette-tool", "sqlite"] | public | 0 | 0 | 30 | main | ||
395137513 | MDEwOlJlcG9zaXRvcnkzOTUxMzc1MTM= | datasette-x-forwarded-host | simonw/datasette-x-forwarded-host | 0 | simonw 9599 | https://github.com/simonw/datasette-x-forwarded-host | Treat the X-Forwarded-Host header as the Host header | 0 | 2021-08-11T23:10:44Z | 2022-04-27T15:06:31Z | 2021-11-12T20:48:41Z | 4 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette-io", "datasette-plugin"] | public | 0 | 0 | 1 | main | |||
394107614 | MDEwOlJlcG9zaXRvcnkzOTQxMDc2MTQ= | datasette-query-links | simonw/datasette-query-links | 0 | simonw 9599 | https://github.com/simonw/datasette-query-links | Turn SELECT queries returned by a query into links to execute them | 0 | 2021-08-09T01:16:59Z | 2022-04-27T15:06:37Z | 2021-08-09T02:56:40Z | 7 | 5 | 5 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 1 | 0 | 5 | main | |||
587924230 | R_kgDOIwsDBg | datasette-cookies-for-magic-parameters | simonw/datasette-cookies-for-magic-parameters | 0 | simonw 9599 | https://github.com/simonw/datasette-cookies-for-magic-parameters | UI for setting cookies to populate magic parameters | 0 | 2023-01-11T22:47:31Z | 2023-01-16T19:11:46Z | 2023-01-12T19:04:37Z | https://datasette.io/plugins/datasette-cookies-for-magic-parameters | 11 | 0 | 0 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | ["datasette", "datasette-plugin"] | public | 0 | 0 | 0 | main | |
284131154 | MDEwOlJlcG9zaXRvcnkyODQxMzExNTQ= | datasette-insert-unsafe | simonw/datasette-insert-unsafe | 0 | simonw 9599 | https://github.com/simonw/datasette-insert-unsafe | Unsafe permissions for datasette-insert - allows all actions without authentication | 0 | 2020-07-31T21:17:44Z | 2022-04-04T18:03:37Z | 2020-07-31T21:46:27Z | 3 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 1 | main | |||
393999598 | MDEwOlJlcG9zaXRvcnkzOTM5OTk1OTg= | datasette-pyinstrument | simonw/datasette-pyinstrument | 0 | simonw 9599 | https://github.com/simonw/datasette-pyinstrument | Use pyinstrument to analyze Datasette page performance | 0 | 2021-08-08T15:33:29Z | 2022-04-27T15:06:42Z | 2021-08-08T15:50:52Z | 5 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | [] | public | 0 | 0 | 2 | main | |||
327957983 | MDEwOlJlcG9zaXRvcnkzMjc5NTc5ODM= | cbsa-datasette | simonw/cbsa-datasette | 0 | simonw 9599 | https://github.com/simonw/cbsa-datasette | Using Datasette to provide an API for Core Based Statistical Areas | 0 | 2021-01-08T16:40:25Z | 2022-03-22T01:55:14Z | 2023-01-09T20:56:39Z | https://cbsa.datasettes.com | 19 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette"] | public | 0 | 0 | 0 | main | |||
275615947 | MDEwOlJlcG9zaXRvcnkyNzU2MTU5NDc= | datasette-glitch | simonw/datasette-glitch | 0 | simonw 9599 | https://github.com/simonw/datasette-glitch | Utilities to help run Datasette on Glitch | 0 | 2020-06-28T15:41:25Z | 2020-07-01T22:48:35Z | 2020-07-01T22:49:22Z | 3 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin", "glitch"] | public | 0 | 0 | 1 | main | |||
400678317 | MDEwOlJlcG9zaXRvcnk0MDA2NzgzMTc= | datasette-verify | simonw/datasette-verify | 0 | simonw 9599 | https://github.com/simonw/datasette-verify | Verify that files can be opened by Datasette | 0 | 2021-08-28T01:59:12Z | 2021-09-07T22:56:11Z | 2021-08-28T02:31:34Z | https://datasette.io/tools/datasette-verify | 3 | 2 | 2 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | public | 0 | 0 | 2 | main | ||
685770791 | R_kgDOKOAIJw | sqlite-utils-move-tables | simonw/sqlite-utils-move-tables | 0 | simonw 9599 | https://github.com/simonw/sqlite-utils-move-tables | sqlite-utils plugin adding a move-tables command | 0 | 2023-09-01T01:14:23Z | 2023-09-02T17:26:56Z | 2023-09-01T02:09:14Z | 8 | 3 | 3 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | 1 | 0 | 0 | [] | public | 0 | 0 | 3 | main |
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, [has_discussions] INTEGER, [forks_count] INTEGER, [archived] INTEGER, [disabled] INTEGER, [open_issues_count] INTEGER, [license] TEXT REFERENCES [licenses]([key]), [allow_forking] INTEGER, [is_template] INTEGER, [web_commit_signoff_required] INTEGER, [topics] TEXT, [visibility] TEXT, [forks] INTEGER, [open_issues] INTEGER, [watchers] INTEGER, [default_branch] TEXT, [organization] INTEGER REFERENCES [users]([id]) ); CREATE INDEX [idx_repos_organization] ON [repos] ([organization]); CREATE INDEX [idx_repos_license] ON [repos] ([license]); CREATE INDEX [idx_repos_owner] ON [repos] ([owner]);