{"repo":"simonw/django-sql-dashboard","free":true,"listed":false,"github":"https://github.com/simonw/django-sql-dashboard","clone":"git clone https://github.com/simonw/django-sql-dashboard.git","description":"Django app for building dashboards using raw SQL queries","language":"Python","stars":468,"topics":["django","sql","dashboards","datasette-io","datasette-tool"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"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 accoun","default_branch":null,"files":null,"tree":[],"storefront":"/r/simonw","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/simonw/django-sql-dashboard/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}