django-sql-dashboard
Django SQL Dashboard provides an authenticated interface for executing read-only SQL queries directly against your PostgreSQL database, bringing a useful subset of Datasette 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, including a video demo.
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 from your queries, with full control over who can view and edit them
- Named parameters such as
select * from entries where id = %(id)swill be turned into form fields, allowing quick creation of interactive dashboards - Produce bar charts, progress bars and more from SQL queries, with the ability to easily create new custom dashboard widgets using the Django template system
- Write SQL queries that safely construct and render markdown and 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 mechanism and PostgreSQL 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
Screenshot
Alternatives
- django-sql-explorer provides a related set of functionality that also works against database backends other than PostgreSQL
1 maintainer
Metadata
1 maintainer
Release files for django-sql-dashboard 0.16
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| django-sql-dashboard-0.16.tar.gz | 25.0 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| django_sql_dashboard-0.16-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 58.0 kB
Release files / django-sql-dashboard-0.16.tar.gz
| Download URL | django-sql-dashboard-0.16.tar.gz |
|---|---|
| Size | 25.0 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
48cfba2b9aa20c711d8477d01d0fee6b4600fed2dc1cc41c440be54617a15b7f
|
|
BLAKE2b-256 checksum How to use checksums |
1cb30fc00f44c9afce6e0e0080d348aa221f4a9569bcf2165552031b536e86fa
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
|
Release files / django_sql_dashboard-0.16-py3-none-any.whl
| Download URL | django_sql_dashboard-0.16-py3-none-any.whl |
|---|---|
| Size | 33.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
d6aaedb490dea74b99b5e87ed023846db0ae2d0e363e61a58d37a4c84256fa93
|
|
BLAKE2b-256 checksum How to use checksums |
22a6de1ff6761406b9e6cf00bb0f169b00f402b9f577d0bb74338596fbab9639
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.4.1 importlib_metadata/4.5.0 pkginfo/1.7.0 requests/2.25.1 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.9.5
|
