repos: 347263722
This data as json
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 347263722 | MDEwOlJlcG9zaXRvcnkzNDcyNjM3MjI= | django-sql-dashboard | simonw/django-sql-dashboard | 0 | 9599 | https://github.com/simonw/django-sql-dashboard | Django app for building dashboards using raw SQL queries | 0 | 2021-03-13T03:38:23Z | 2022-04-19T01:13:12Z | 2022-04-20T00:27:39Z | https://django-sql-dashboard.datasette.io/ | 513 | 335 | 335 | Python | 1 | 1 | 1 | 1 | 0 | 28 | 0 | 0 | 25 | apache-2.0 | ["dashboards", "datasette-io", "datasette-tool", "django", "sql"] | 28 | 25 | 335 | main | {"admin": false, "maintain": false, "push": false, "triage": false, "pull": false} | 28 | 9 | # django-sql-dashboard [](https://pypi.org/project/django-sql-dashboard/) [](https://github.com/simonw/django-sql-dashboard/releases) [](https://github.com/simonw/django-sql-dashboard/actions?query=workflow%3ATest) [](http://django-sql-dashboard.datasette.io/en/latest/?badge=latest) [](https://github.com/simonw/django-sql-dashboard/blob/main/LICENSE) Django SQL Dashboard provides an authenticated interface for executing read-only SQL queries directly against your PostgreSQL database, bringing a useful subset of [Datasette](https://datasette.io/) to Django. Applications include ad-hoc analysis and debugging, plus the creation of reporting dashboards that can be shared with team members or published online. See my blog for [more about this project](https://simonwillison.net/2021/May/10/django-sql-dashboard/), including [a video demo](https://www.youtube.com/watch?v=ausrmMZkPEY). Features include: - Safely run read-only one or more SQL queries against your database and view the results in your browser - Bookmark queries and share those links with other members of your team - Create [saved dashboards](https://django-sql-dashboard.datasette.io/en/latest/saved-dashboards.html) from your queries, with full control over who can view and edit them - [Named parameters](https://django-sql-dashboard.datasette.io/en/latest/sql.html#sql-parameters) such as `select * from entries where id = %(id)s` will be turned into form fields, allowing quick creation of interactive dashboards - Produce [bar charts](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#bar-label-bar-quantity), [progress bars](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#total-count-completed-count) and more from SQL queries, with the ability to easily create new [custom dashboard widgets](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#custom-widgets) using the Django template system - Write SQL queries that safely construct and render [markdown](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#markdown) and [HTML](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#html) - Export the full results of a SQL query as a downloadable CSV or TSV file, using a combination of Django's [streaming HTTP response](https://docs.djangoproject.com/en/3.2/ref/request-response/#django.http.StreamingHttpResponse) mechanism and PostgreSQL [server-side cursors](https://www.psycopg.org/docs/usage.html#server-side-cursors) to efficiently stream large amounts of data without running out of resources - Copy and paste the results of SQL queries directly into tools such as Google Sheets or Excel - Uses Django's authentication system, so dashboard accounts can be granted using Django's Admin tools ## Documentation Full documentation is at [django-sql-dashboard.datasette.io](https://django-sql-dashboard.datasette.io/) ## Screenshot <img width="1018" alt="Screenshot showing a SQL query that produces a table and one that produces a bar chart" src="https://user-images.githubusercontent.com/9599/124050883-42ad2300-d9d0-11eb-83e6-44ad85f7ef64.png"> ## Alternatives - [django-sql-explorer](https://github.com/groveco/django-sql-explorer) provides a related set of functionality that also works against database backends other than PostgreSQL | <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-django-sql-dashboard" class="anchor" aria-hidden="true" href="#user-content-django-sql-dashboard"><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>django-sql-dashboard</h1> <p dir="auto"><a href="https://pypi.org/project/django-sql-dashboard/" rel="nofollow"><img src="https://camo.githubusercontent.com/87a7771e261b30e7b0da09a83f2d6120ce484b068a0d844a41d2f945141194d1/68747470733a2f2f696d672e736869656c64732e696f2f707970692f762f646a616e676f2d73716c2d64617368626f6172642e737667" alt="PyPI" data-canonical-src="https://img.shields.io/pypi/v/django-sql-dashboard.svg" style="max-width: 100%;"></a> <a href="https://github.com/simonw/django-sql-dashboard/releases"><img src="https://camo.githubusercontent.com/f3c931ccf5487f5df160f339f767aba9ac45e15a5f4e8beb37fd6e33cbc239c0/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f762f72656c656173652f73696d6f6e772f646a616e676f2d73716c2d64617368626f6172643f696e636c7564655f70726572656c6561736573266c6162656c3d6368616e67656c6f67" alt="Changelog" data-canonical-src="https://img.shields.io/github/v/release/simonw/django-sql-dashboard?include_prereleases&label=changelog" style="max-width: 100%;"></a> <a href="https://github.com/simonw/django-sql-dashboard/actions?query=workflow%3ATest"><img src="https://github.com/simonw/django-sql-dashboard/workflows/Test/badge.svg" alt="Tests" style="max-width: 100%;"></a> <a href="http://django-sql-dashboard.datasette.io/en/latest/?badge=latest" rel="nofollow"><img src="https://camo.githubusercontent.com/e5bd1be998e2bf35ee16299f10c1520b531a957a3b725b6b663e40d82d3c8425/68747470733a2f2f72656164746865646f63732e6f72672f70726f6a656374732f646a616e676f2d73716c2d64617368626f6172642f62616467652f3f76657273696f6e3d6c6174657374" alt="Documentation Status" data-canonical-src="https://readthedocs.org/projects/django-sql-dashboard/badge/?version=latest" style="max-width: 100%;"></a> <a href="https://github.com/simonw/django-sql-dashboard/blob/main/LICENSE"><img src="https://camo.githubusercontent.com/1698104e976c681143eb0841f9675c6f802bb7aa832afc0c7a4e719b1f3cf955/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d417061636865253230322e302d626c75652e737667" alt="License" data-canonical-src="https://img.shields.io/badge/license-Apache%202.0-blue.svg" style="max-width: 100%;"></a></p> <p dir="auto">Django SQL Dashboard provides an authenticated interface for executing read-only SQL queries directly against your PostgreSQL database, bringing a useful subset of <a href="https://datasette.io/" rel="nofollow">Datasette</a> to Django.</p> <p dir="auto">Applications include ad-hoc analysis and debugging, plus the creation of reporting dashboards that can be shared with team members or published online.</p> <p dir="auto">See my blog for <a href="https://simonwillison.net/2021/May/10/django-sql-dashboard/" rel="nofollow">more about this project</a>, including <a href="https://www.youtube.com/watch?v=ausrmMZkPEY" rel="nofollow">a video demo</a>.</p> <p dir="auto">Features include:</p> <ul dir="auto"> <li>Safely run read-only one or more SQL queries against your database and view the results in your browser</li> <li>Bookmark queries and share those links with other members of your team</li> <li>Create <a href="https://django-sql-dashboard.datasette.io/en/latest/saved-dashboards.html" rel="nofollow">saved dashboards</a> from your queries, with full control over who can view and edit them</li> <li><a href="https://django-sql-dashboard.datasette.io/en/latest/sql.html#sql-parameters" rel="nofollow">Named parameters</a> such as <code>select * from entries where id = %(id)s</code> will be turned into form fields, allowing quick creation of interactive dashboards</li> <li>Produce <a href="https://django-sql-dashboard.datasette.io/en/latest/widgets.html#bar-label-bar-quantity" rel="nofollow">bar charts</a>, <a href="https://django-sql-dashboard.datasette.io/en/latest/widgets.html#total-count-completed-count" rel="nofollow">progress bars</a> and more from SQL queries, with the ability to easily create new <a href="https://django-sql-dashboard.datasette.io/en/latest/widgets.html#custom-widgets" rel="nofollow">custom dashboard widgets</a> using the Django template system</li> <li>Write SQL queries that safely construct and render <a href="https://django-sql-dashboard.datasette.io/en/latest/widgets.html#markdown" rel="nofollow">markdown</a> and <a href="https://django-sql-dashboard.datasette.io/en/latest/widgets.html#html" rel="nofollow">HTML</a></li> <li>Export the full results of a SQL query as a downloadable CSV or TSV file, using a combination of Django's <a href="https://docs.djangoproject.com/en/3.2/ref/request-response/#django.http.StreamingHttpResponse" rel="nofollow">streaming HTTP response</a> mechanism and PostgreSQL <a href="https://www.psycopg.org/docs/usage.html#server-side-cursors" rel="nofollow">server-side cursors</a> to efficiently stream large amounts of data without running out of resources</li> <li>Copy and paste the results of SQL queries directly into tools such as Google Sheets or Excel</li> <li>Uses Django's authentication system, so dashboard accounts can be granted using Django's Admin tools</li> </ul> <h2 dir="auto"><a id="user-content-documentation" class="anchor" aria-hidden="true" href="#user-content-documentation"><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>Documentation</h2> <p dir="auto">Full documentation is at <a href="https://django-sql-dashboard.datasette.io/" rel="nofollow">django-sql-dashboard.datasette.io</a></p> <h2 dir="auto"><a id="user-content-screenshot" class="anchor" aria-hidden="true" href="#user-content-screenshot"><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>Screenshot</h2> <p><a target="_blank" rel="noopener noreferrer" href="https://user-images.githubusercontent.com/9599/124050883-42ad2300-d9d0-11eb-83e6-44ad85f7ef64.png"><img width="1018" alt="Screenshot showing a SQL query that produces a table and one that produces a bar chart" src="https://user-images.githubusercontent.com/9599/124050883-42ad2300-d9d0-11eb-83e6-44ad85f7ef64.png" style="max-width: 100%;"></a></p> <h2 dir="auto"><a id="user-content-alternatives" class="anchor" aria-hidden="true" href="#user-content-alternatives"><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>Alternatives</h2> <ul dir="auto"> <li><a href="https://github.com/groveco/django-sql-explorer">django-sql-explorer</a> provides a related set of functionality that also works against database backends other than PostgreSQL</li> </ul> </article></div> | 1 | public | 0 |
Links from other tables
- 35 rows from repo in releases