repos
3 rows where permissions = "{"admin": false, "maintain": false, "push": false, "triage": false, "pull": false}", topics contains "datasette-io" and watchers = 1
This data as json, CSV (advanced)
Suggested facets: 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 | temp_clone_token | organization | network_count | subscribers_count | readme | readme_html | allow_forking | visibility | is_template | template_repository | web_commit_signoff_required | has_discussions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 238339412 | MDEwOlJlcG9zaXRvcnkyMzgzMzk0MTI= | datasette-debug-asgi | simonw/datasette-debug-asgi | 0 | simonw 9599 | https://github.com/simonw/datasette-debug-asgi | Datasette plugin for dumping out the ASGI scope | 0 | 2020-02-05T00:57:09Z | 2021-08-17T23:40:02Z | 2021-08-17T23:41:03Z | https://datasette.io/plugins/datasette-debug-asgi | 16 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | Apache License 2.0 apache-2.0 | ["asgi", "datasette-io", "datasette-plugin"] | 0 | 0 | 1 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": false} | 0 | 1 | # datasette-debug-asgi [](https://pypi.org/project/datasette-debug-asgi/) [](https://github.com/simonw/datasette-debug-asgi/releases) [](https://github.com/simonw/datasette-debug-asgi/actions?query=workflow%3ATest) [](https://github.com/simonw/datasette-debug-asgi/blob/main/LICENSE) Datasette plugin for dumping out the ASGI scope. Adds a new URL at `/-/asgi-scope` which shows the current ASGI scope. Demo here: https://datasette.io/-/asgi-scope ## Installation pip install datasette-debug-asgi ## Usage Visit `/-/asgi-scope` to see debug output showing the ASGI scope. You can add query string parameters such as `/-/asgi-scope?q=hello`. You can also add extra path components such as `/-/asgi-scope/more/path/here`. | <div id="readme" class="md" data-path="README.md"><article class="markdown-body entry-content container-lg" itemprop="text"><h1><a id="user-content-datasette-debug-asgi" class="anchor" aria-hidden="true" href="#user-content-datasette-debug-asgi"><svg class="octicon octicon-link" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.775 3.275a.75.75 0 001.06 1.06l1.25-1.25a2 2 0 112.83 2.83l-2.5 2.5a2 2 0 01-2.83 0 .75.75 0 00-1.06 1.06 3.5 3.5 0 004.95 0l2.5-2.5a3.5 3.5 0 00-4.95-4.95l-1.25 1.25zm-4.69 9.64a2 2 0 010-2.83l2.5-2.5a2 2 0 012.83 0 .75.75 0 001.06-1.06 3.5 3.5 0 00-4.95 0l-2.5 2.5a3.5 3.5 0 004.95 4.95l1.25-1.25a.75.75 0 00-1.06-1.06l-1.25 1.25a2 2 0 01-2.83 0z"></path></svg></a>datasette-debug-asgi</h1> <p><a href="https://pypi.org/project/datasette-debug-asgi/" rel="nofollow"><img src="https://camo.githubusercontent.com/59ce0e036bd317f141a4ce0589ec0969f8fd2cfdef49c6b3c7c4dafc4bd9e332/68747470733a2f2f696d672e736869656c64732e696f2f707970692f762f6461746173657474652d64656275672d617367692e737667" alt="PyPI" data-canonical-src="https://img.shields.io/pypi/v/datasette-debug-asgi.svg" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-debug-asgi/releases"><img src="https://camo.githubusercontent.com/d3b776c6e5f4674675855b8268bbc26631391e18e23a50a4cc92204b89a1b701/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f73696d6f6e772f6461746173657474652d64656275672d617367693f696e636c7564655f70726572656c6561736573266c6162656c3d6368616e67656c6f67" alt="Changelog" data-canonical-src="https://img.shields.io/github/v/release/simonw/datasette-debug-asgi?include_prereleases&label=changelog" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-debug-asgi/actions?query=workflow%3ATest"><img src="https://github.com/simonw/datasette-debug-asgi/workflows/Test/badge.svg" alt="Tests" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-debug-asgi/blob/main/LICENSE"><img src="ht… | ||||||||
| 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-08-28T02:37:03Z | 2021-08-28T02:31:34Z | https://datasette.io/tools/datasette-verify | 0 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ["datasette", "datasette-io", "datasette-plugin"] | 0 | 0 | 1 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": false} | 0 | 1 | # datasette-verify [](https://pypi.org/project/datasette-verify/) [](https://github.com/simonw/datasette-verify/releases) [](https://github.com/simonw/datasette-verify/actions?query=workflow%3ATest) [](https://github.com/simonw/datasette-verify/blob/main/LICENSE) Verify that SQLite files can be opened using Datasette ## Installation Install this plugin in the same environment as Datasette. $ datasette install datasette-verify This plugin depends on [Datasette 0.59a2](https://github.com/simonw/datasette/releases/tag/0.59a2) or higher, as it uses the [register_commands()](https://docs.datasette.io/en/latest/plugin_hooks.html#plugin-hook-register-commands) plugin hook. ## Usage To confirm that files can be opened by Datasette, run the following: datasette verify file1.db file2.db You can pass one or more file paths. The command will exit silently with a 0 exit code if the files are all valid SQLite databases that Datasette can open. It will exit with a 1 exit code and display an error for the first file it finds that is not valid. ## Development To set up this plugin locally, first checkout the code. Then create a new virtual environment: cd datasette-verify python3 -mvenv venv source venv/bin/activate Or if you are using `pipenv`: pipenv shell Now install the dependencies and test dependencies: pip install -e '.[test]' To run the tests: pytest | <div id="readme" class="md" data-path="README.md"><article class="markdown-body entry-content container-lg" itemprop="text"><h1><a id="user-content-datasette-verify" class="anchor" aria-hidden="true" href="#user-content-datasette-verify"><svg class="octicon octicon-link" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.775 3.275a.75.75 0 001.06 1.06l1.25-1.25a2 2 0 112.83 2.83l-2.5 2.5a2 2 0 01-2.83 0 .75.75 0 00-1.06 1.06 3.5 3.5 0 004.95 0l2.5-2.5a3.5 3.5 0 00-4.95-4.95l-1.25 1.25zm-4.69 9.64a2 2 0 010-2.83l2.5-2.5a2 2 0 012.83 0 .75.75 0 001.06-1.06 3.5 3.5 0 00-4.95 0l-2.5 2.5a3.5 3.5 0 004.95 4.95l1.25-1.25a.75.75 0 00-1.06-1.06l-1.25 1.25a2 2 0 01-2.83 0z"></path></svg></a>datasette-verify</h1> <p><a href="https://pypi.org/project/datasette-verify/" rel="nofollow"><img src="https://camo.githubusercontent.com/054b14e587acf0c25a294d22ff99e43599ca4929bac5e4671b3933f180df398f/68747470733a2f2f696d672e736869656c64732e696f2f707970692f762f6461746173657474652d7665726966792e737667" alt="PyPI" data-canonical-src="https://img.shields.io/pypi/v/datasette-verify.svg" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-verify/releases"><img src="https://camo.githubusercontent.com/4b18b9f7b4f773b0914da3ef602b9e17772d48cc15af29c19110a11c57195363/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f73696d6f6e772f6461746173657474652d7665726966793f696e636c7564655f70726572656c6561736573266c6162656c3d6368616e67656c6f67" alt="Changelog" data-canonical-src="https://img.shields.io/github/v/release/simonw/datasette-verify?include_prereleases&label=changelog" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-verify/actions?query=workflow%3ATest"><img src="https://github.com/simonw/datasette-verify/workflows/Test/badge.svg" alt="Tests" style="max-width:100%;"></a> <a href="https://github.com/simonw/datasette-verify/blob/main/LICENSE"><img src="https://camo.githubusercontent.com/1698104e976c681143eb084… | |||||||||
| 430224716 | R_kgDOGaS1TA | datasette-redirect-to-https | simonw/datasette-redirect-to-https | 0 | simonw 9599 | https://github.com/simonw/datasette-redirect-to-https | Datasette plugin that redirects all non-https requests to https | 0 | 2021-11-20T22:43:33Z | 2022-04-24T03:48:01Z | 2022-07-07T17:38:32Z | 12 | 1 | 1 | Python | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | ["asgi", "datasette", "datasette-io", "datasette-plugin"] | 0 | 0 | 1 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": false} | 0 | 1 | # datasette-redirect-to-https [](https://pypi.org/project/datasette-redirect-to-https/) [](https://github.com/simonw/datasette-redirect-to-https/releases) [](https://github.com/simonw/datasette-redirect-to-https/actions?query=workflow%3ATest) [](https://github.com/simonw/datasette-redirect-to-https/blob/main/LICENSE) Datasette plugin that redirects all non-https requests to https ## Installation Install this plugin in the same environment as Datasette. $ datasette install datasette-redirect-to-https ## Usage Once installed, incoming GET requests to the `http://` protocol will be 301 redirected to the `https://` equivalent page. HTTP verbs other than GET will get a 405 Method Not Allowed HTTP error. ## Configuration Some hosting providers handle HTTPS for you, passing requests back to your application server over HTTP. For this plugin to work correctly, it needs to detect that the original incoming request came in over HTTP. Hosting providers like this often set an additional HTTP header such as `x-forwarded-proto: http` identifying the original protocol. You can configure `datasette-redirect-to-https` to respect this header using the following plugin configuration in `metadata.json`: ```json { "plugins": { "datasette-redirect-to-https": { "if_headers": { "x-forwarded-proto": "http" } } } } ``` The above example will redirect to `https://` if the incoming request has a `x-forwarded-proto: http` request header. If multiple `if_headers` are listed, the redirect will occur if any of them match. ## Development To set up this plugin locally, first checkout the code. Then create a new virtual environment: cd datasette… | <div id="readme" class="md" data-path="README.md"><article class="markdown-body entry-content container-lg" itemprop="text"><h1 dir="auto"><a id="user-content-datasette-redirect-to-https" class="anchor" aria-hidden="true" href="#user-content-datasette-redirect-to-https"><svg class="octicon octicon-link" viewBox="0 0 16 16" version="1.1" width="16" height="16" aria-hidden="true"><path fill-rule="evenodd" d="M7.775 3.275a.75.75 0 001.06 1.06l1.25-1.25a2 2 0 112.83 2.83l-2.5 2.5a2 2 0 01-2.83 0 .75.75 0 00-1.06 1.06 3.5 3.5 0 004.95 0l2.5-2.5a3.5 3.5 0 00-4.95-4.95l-1.25 1.25zm-4.69 9.64a2 2 0 010-2.83l2.5-2.5a2 2 0 012.83 0 .75.75 0 001.06-1.06 3.5 3.5 0 00-4.95 0l-2.5 2.5a3.5 3.5 0 004.95 4.95l1.25-1.25a.75.75 0 00-1.06-1.06l-1.25 1.25a2 2 0 01-2.83 0z"></path></svg></a>datasette-redirect-to-https</h1> <p dir="auto"><a href="https://pypi.org/project/datasette-redirect-to-https/" rel="nofollow"><img src="https://camo.githubusercontent.com/96eb43748c89385b2656ffbe4a6012ccf73035078c0ca1a323cf5f8f3dea31ad/68747470733a2f2f696d672e736869656c64732e696f2f707970692f762f6461746173657474652d72656469726563742d746f2d68747470732e737667" alt="PyPI" data-canonical-src="https://img.shields.io/pypi/v/datasette-redirect-to-https.svg" style="max-width: 100%;"></a> <a href="https://github.com/simonw/datasette-redirect-to-https/releases"><img src="https://camo.githubusercontent.com/b0c8deb890a7e5c1deb8c6bd4da6daf75c7ec8211983b8d5c91f42c9de337d00/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f73696d6f6e772f6461746173657474652d72656469726563742d746f2d68747470733f696e636c7564655f70726572656c6561736573266c6162656c3d6368616e67656c6f67" alt="Changelog" data-canonical-src="https://img.shields.io/github/v/release/simonw/datasette-redirect-to-https?include_prereleases&label=changelog" style="max-width: 100%;"></a> <a href="https://github.com/simonw/datasette-redirect-to-https/actions?query=workflow%3ATest"><img src="https://github.com/simonw/datasette-redirect-to-https/workflows/Test/badge.svg" alt="Tests" s… | 1 | public | 0 | {"id": 400878073, "node_id": "MDEwOlJlcG9zaXRvcnk0MDA4NzgwNzM=", "name": "datasette-plugin-template-repository", "full_name": "simonw/datasette-plugin-template-repository", "private": false, "owner": {"login": "simonw", "id": 9599, "node_id": "MDQ6VXNlcjk1OTk=", "avatar_url": "https://avatars.githubusercontent.com/u/9599?v=4", "gravatar_id": "", "url": "https://api.github.com/users/simonw", "html_url": "https://github.com/simonw", "followers_url": "https://api.github.com/users/simonw/followers", "following_url": "https://api.github.com/users/simonw/following{/other_user}", "gists_url": "https://api.github.com/users/simonw/gists{/gist_id}", "starred_url": "https://api.github.com/users/simonw/starred{/owner}{/repo}", "subscriptions_url": "https://api.github.com/users/simonw/subscriptions", "organizations_url": "https://api.github.com/users/simonw/orgs", "repos_url": "https://api.github.com/users/simonw/repos", "events_url": "https://api.github.com/users/simonw/events{/privacy}", "received_events_url": "https://api.github.com/users/simonw/received_events", "type": "User", "site_admin": false}, "html_url": "https://github.com/simonw/datasette-plugin-template-repository", "description": "GitHub template repository for creating new Datasette plugins, using the simonw/datasette-plugin cookiecutter template", "fork": false, "url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository", "forks_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/forks", "keys_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/keys{/key_id}", "collaborators_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/collaborators{/collaborator}", "teams_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/teams", "hooks_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/hooks", "issue_events_url": "https://api.github.com/repos/simonw/datasette-plugin-template-repository/issues/events{/numbe… | 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,
[temp_clone_token] TEXT,
[organization] INTEGER REFERENCES [users]([id]),
[network_count] INTEGER,
[subscribers_count] INTEGER, [readme] TEXT, [readme_html] TEXT, [allow_forking] INTEGER, [visibility] TEXT, [is_template] INTEGER, [template_repository] TEXT, [web_commit_signoff_required] INTEGER, [has_discussions] INTEGER,
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]);