https://django-sql-dashboard.datasette.io/en/latest/

django-sql-dashboard
latest
[                    ] 
  * Installation and configuration
  * Running SQL queries
  * Saved dashboards
  * Widgets
  * Custom widgets
  * Security
  * Contributing

django-sql-dashboard

  *  >>
  * Django SQL Dashboard
  * Edit on GitHub

---------------------------------------------------------------------

Django SQL DashboardP

  * Installation and configuration
      + Install using pip
      + Configuration
      + Setting up read-only PostgreSQL credentials
      + Configuring the "dashboard" database alias
          o Danger mode: configuration without a read-only database
            user
      + Additional settings
      + Custom templates
  * Running SQL queries
      + SQL parameters
  * Saved dashboards
  * Widgets
      + Bar chart: bar_label, bar_quantity
      + Big number: big_number, label
      + Progress bar: total_count, completed_count
      + Word cloud: wordcloud_word, wordcloud_count
      + markdown
      + html
  * Custom widgets
  * Security
  * Contributing
      + Running the tests
      + Generating new migrations
      + Code style
      + Documentation

django-sql-dashboardP

PyPI Changelog Tests 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 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

DocumentationP

Full documentation is at django-sql-dashboard.datasette.io

ScreenshotP

Screenshot showing a SQL query that produces a table and one that
produces a bar chart
Next
---------------------------------------------------------------------

(c) Copyright 2021, Simon Willison. Revision cc1dfd30.

Built with Sphinx using a theme provided by Read the Docs.
Read the Docs v: latest

Versions
    latest
    stable

Downloads
    pdf

On Read the Docs
    Project Home
    Builds