Django app for building dashboards using raw SQL queries
Project description
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)s
will 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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
django-sql-dashboard-1.0.2.tar.gz
(26.8 kB
view hashes)
Built Distribution
Close
Hashes for django-sql-dashboard-1.0.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6982af8bc30d1d80a9b0713d075b7a705570366bd50c4c79ee18b08e89a3ba2e |
|
MD5 | 1c75721fa89edc8a065a5106b9ce3b6f |
|
BLAKE2b-256 | 1c7a437c93a4f7443886ff5c7c20f2bfdf1573c0021b03e027e47ae56b290402 |
Close
Hashes for django_sql_dashboard-1.0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a4bc1193a69025d49aae5d47e3ecb0a5e94edf488b8462aa728b9ad1b120f293 |
|
MD5 | 30b02fb4eaf57160851036a5b492e86e |
|
BLAKE2b-256 | e911a815fa6649ba75fe2cfde0a896d3055ff269d4ca10c7dfcf72093d57cccc |