django-sql-dashboard
django-sql-dashboard copied to clipboard
simonw
Django app for building dashboards using raw SQL queries
https://simonwillison.net/dashboard/tag-cloud-by-year.json?year=2023 returns this: ```json { "title": "Tag cloud by year", "queries": [ { "sql": "SELECT \"tag\" AS wordcloud_word, COUNT(*) AS wordcloud_count \r\nFROM (\r\n SELECT blog_tag.tag \r\n FROM blog_entry_tags \r\n JOIN...
This adds a number of new fields to the dashboard query object, to meet some of the needs described in issue #141. The new fields are: - `title` - a...
This error message here: https://github.com/simonw/django-sql-dashboard/blob/422fce166cfd11f1905ed925a94e25c915ba0373/django_sql_dashboard/views.py#L242-L245 Would be more useful if it suggested replacing that `;` with `chr(59)`.
More about codespell: https://github.com/codespell-project/codespell . I personally introduced it to dozens if not hundreds of projects already and so far only positive feedback. CI workflow has 'permissions' set only to...
django_sql_dashboard fails with psycopg3 because of ModuleNotFoundError: ./django_sql_dashboard/views.py:from psycopg2.extensions import quote_ident I take it this is a reexport? In psycopg3 that would be something like this: ``` import psycopg from...
