releases
35 rows where repo = 347263722
This data as json, CSV (advanced)
Suggested facets: prerelease, created_at (date), published_at (date)
| id ▼ | html_url | author | node_id | tag_name | target_commitish | name | draft | prerelease | created_at | published_at | body | repo | reactions | mentions_count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39755110 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.1a | simonw 9599 | MDc6UmVsZWFzZTM5NzU1MTEw | 0.1a | main | 0.1a | 0 | 1 | 2021-03-13T05:29:27Z | 2021-03-13T05:31:23Z | - Initial working alpha. | django-sql-dashboard 347263722 | ||
| 39755177 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.1a2 | simonw 9599 | MDc6UmVsZWFzZTM5NzU1MTc3 | 0.1a2 | main | 0.1a2 | 0 | 1 | 2021-03-13T05:37:53Z | 2021-03-13T05:38:20Z | - Workaround for `psycopg2` dependency bug on macOS. #3 | django-sql-dashboard 347263722 | ||
| 39755262 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.1a3 | simonw 9599 | MDc6UmVsZWFzZTM5NzU1MjYy | 0.1a3 | main | 0.1a3 | 0 | 1 | 2021-03-13T05:49:27Z | 2021-03-13T05:50:05Z | - Include templates and migrations in the release. #4 | django-sql-dashboard 347263722 | ||
| 39793214 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.2a0 | simonw 9599 | MDc6UmVsZWFzZTM5NzkzMjE0 | 0.2a0 | main | 0.2a0 | 0 | 1 | 2021-03-15T01:11:02Z | 2021-03-15T01:20:22Z | - Run tests against read-only 'dashboard' connection, refs #18 - Named SQL parameters are now extracted into form fields. #15 - Configure URLs using `include()` pattern. #14 - `?sql=` params are now signed, must first be created using a POST request. #13 - New custom widgets framework #20 - Big number widget for displaying a big number. #20 | django-sql-dashboard 347263722 | ||
| 39795482 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.2a1 | simonw 9599 | MDc6UmVsZWFzZTM5Nzk1NDgy | 0.2a1 | main | 0.2a1 | 0 | 1 | 2021-03-15T03:09:18Z | 2021-03-15T03:09:46Z | - Fix for bug where `templatetags` were not bundled in the release package. #22 | django-sql-dashboard 347263722 | ||
| 39795566 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.2a2 | simonw 9599 | MDc6UmVsZWFzZTM5Nzk1NTY2 | 0.2a2 | main | 0.2a2 | 0 | 1 | 2021-03-15T03:12:52Z | 2021-03-15T03:13:20Z | - Bundle widget templates in release. | django-sql-dashboard 347263722 | ||
| 39797264 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.3a0 | simonw 9599 | MDc6UmVsZWFzZTM5Nzk3MjY0 | 0.3a0 | main | 0.3a0 | 0 | 1 | 2021-03-15T04:46:27Z | 2021-03-15T04:47:46Z | - Added basic bar chart widget. [#10](https://github.com/simonw/django-sql-dashboard/issues/10) - Added `markdown` widget. [#12](https://github.com/simonw/django-sql-dashboard/issues/12) - Added `html` widget. [#12](https://github.com/simonw/django-sql-dashboard/issues/12) | django-sql-dashboard 347263722 | ||
| 39849994 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.3a1 | simonw 9599 | MDc6UmVsZWFzZTM5ODQ5OTk0 | 0.3a1 | main | 0.3a1 | 0 | 1 | 2021-03-16T00:13:39Z | 2021-03-16T00:14:51Z | - Changed default permission policy: saved dashboards are now inaccessible to the public by default (#37). This will change when permissions are implemented fully in #27. | django-sql-dashboard 347263722 | ||
| 40047073 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.4a0 | simonw 9599 | MDc6UmVsZWFzZTQwMDQ3MDcz | 0.4a0 | main | 0.4a0 | 0 | 1 | 2021-03-19T06:50:16Z | 2021-03-19T06:50:27Z | - Documentation now lives at https://django-sql-dashboard.readthedocs.io/ ([#36](https://github.com/simonw/django-sql-dashboard/issues/36)) - Ability to copy and paste TSV from the default table display. ([#29](https://github.com/simonw/django-sql-dashboard/issues/29)) - Fixed two bugs with the way count links in column headers work. ([#31](https://github.com/simonw/django-sql-dashboard/issues/31), [#32](https://github.com/simonw/django-sql-dashboard/issues/32)) - New permissions system: a saved dashboard can now be made public, private, unlisted, group-only, staff-only or superuser-only. ([#27](https://github.com/simonw/django-sql-dashboard/issues/27)) | django-sql-dashboard 347263722 | ||
| 40112731 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.4a1 | simonw 9599 | MDc6UmVsZWFzZTQwMTEyNzMx | 0.4a1 | main | 0.4a1 | 0 | 1 | 2021-03-21T00:39:37Z | 2021-03-21T00:40:22Z | - Serve `cache-control: private` HTTP header on private dashboards. #43 | django-sql-dashboard 347263722 | ||
| 40129415 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.4a2 | simonw 9599 | MDc6UmVsZWFzZTQwMTI5NDE1 | 0.4a2 | main | 0.4a2 | 0 | 1 | 2021-03-21T21:25:01Z | 2021-03-21T21:27:00Z | - Removed unnecessary migration dependency, so this should now install on versions of Django prior to 3.1. Thanks, @jefftriplett. [#46](https://github.com/simonw/django-sql-dashboard/issues/46) | django-sql-dashboard 347263722 | ||
| 40295443 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.5a0 | simonw 9599 | MDc6UmVsZWFzZTQwMjk1NDQz | 0.5a0 | main | 0.5a0 | 0 | 1 | 2021-03-24T14:38:39Z | 2021-03-24T14:42:32Z | - Link to dashboard from admin edit page. [#48](https://github.com/simonw/django-sql-dashboard/issues/48) - Better error message for queries with `%` that needs to be escaped. [#41](https://github.com/simonw/django-sql-dashboard/issues/41) | django-sql-dashboard 347263722 | ||
| 41161629 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.6a0 | simonw 9599 | MDc6UmVsZWFzZTQxMTYxNjI5 | 0.6a0 | main | 0.6a0 | 0 | 1 | 2021-04-09T04:43:21Z | 2021-04-09T04:44:11Z | - Fix for bug with columns with identical names. #52 - `DASHBOARD_ROW_LIMIT` setting. #53 - Size SQL textarea to fit SQL. #51 | django-sql-dashboard 347263722 | ||
| 41310263 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.7a0 | simonw 9599 | MDc6UmVsZWFzZTQxMzEwMjYz | 0.7a0 | main | 0.7a0 | 0 | 1 | 2021-04-12T23:15:50Z | 2021-04-12T23:17:12Z | - SQL textarea now always has at least 5 rows - Always strip trailing `;` from SQL, fixing bug with "count" links. [#56](https://github.com/simonw/django-sql-dashboard/issues/56) - URLize links in results. [#61](https://github.com/simonw/django-sql-dashboard/issues/61) | django-sql-dashboard 347263722 | ||
| 41393791 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.8a0 | simonw 9599 | MDc6UmVsZWFzZTQxMzkzNzkx | 0.8a0 | main | 0.8a0 | 0 | 1 | 2021-04-14T05:54:18Z | 2021-04-14T05:55:20Z | - Make it easy to provide a custom base template. #7 - `Content-Security-Policy: frame-ancestors` header. #64 - Signing no longer uses base64/json. #45 - `DASHBOARD_UPGRADE_OLD_BASE64_LINKS` mechanism. #65 | django-sql-dashboard 347263722 | ||
| 41394176 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.8a1 | simonw 9599 | MDc6UmVsZWFzZTQxMzk0MTc2 | 0.8a1 | main | 0.8a1 | 0 | 1 | 2021-04-14T06:08:27Z | 2021-04-14T06:09:03Z | - Fixed bug with `DASHBOARD_UPGRADE_OLD_BASE64_LINKS` setting. #67 | django-sql-dashboard 347263722 | ||
| 41394584 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.8a2 | simonw 9599 | MDc6UmVsZWFzZTQxMzk0NTg0 | 0.8a2 | main | 0.8a2 | 0 | 1 | 2021-04-14T06:22:00Z | 2021-04-14T06:22:53Z | - Correctly sign `?sql=` on redirects created using `DASHBOARD_UPGRADE_OLD_BASE64_LINKS`. #68 | django-sql-dashboard 347263722 | ||
| 41971073 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.9a0 | simonw 9599 | MDc6UmVsZWFzZTQxOTcxMDcz | 0.9a0 | main | 0.9a0 | 0 | 1 | 2021-04-25T17:03:45Z | 2021-04-25T17:05:06Z | - Do not show "[count]" links for unambiguous columns. [#69](https://github.com/simonw/django-sql-dashboard/issues/69) - Better HTML titles for pages, for better browser history. [#70](https://github.com/simonw/django-sql-dashboard/issues/70) - Pretty-print cells containing JSON. [#62](https://github.com/simonw/django-sql-dashboard/issues/62) | django-sql-dashboard 347263722 | ||
| 41971462 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.9a1 | simonw 9599 | MDc6UmVsZWFzZTQxOTcxNDYy | 0.9a1 | main | 0.9a1 | 0 | 1 | 2021-04-25T17:30:13Z | 2021-04-25T17:31:00Z | - Use separate styles for `pre.sql` and `pre.json` | django-sql-dashboard 347263722 | ||
| 41976815 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.10a0 | simonw 9599 | MDc6UmVsZWFzZTQxOTc2ODE1 | 0.10a0 | main | 0.10a0 | 0 | 1 | 2021-04-25T23:07:23Z | 2021-04-25T23:08:38Z | - Handle SQL queries too long for a GET. [#58](https://github.com/simonw/django-sql-dashboard/issues/58) - Export all results as CSV/TSV feature. [#50](https://github.com/simonw/django-sql-dashboard/issues/50) | django-sql-dashboard 347263722 | ||
| 41977023 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.10a1 | simonw 9599 | MDc6UmVsZWFzZTQxOTc3MDIz | 0.10a1 | main | 0.10a1 | 0 | 1 | 2021-04-25T23:24:07Z | 2021-04-25T23:24:58Z | - Fixed bug where large SQL queries submitted by POST did not correctly evaluate any named parameters. [#58](https://github.com/simonw/django-sql-dashboard/issues/58) | django-sql-dashboard 347263722 | ||
| 42027161 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.11a0 | simonw 9599 | MDc6UmVsZWFzZTQyMDI3MTYx | 0.11a0 | main | 0.11a0 | 0 | 1 | 2021-04-26T18:49:18Z | 2021-04-26T18:50:46Z | - "Copy to clipboard" button on pretty-printed JSON results. [#72](https://github.com/simonw/django-sql-dashboard/issues/72) - Saved dashboards no longer display broken export buttons. [#71](https://github.com/simonw/django-sql-dashboard/issues/71) | django-sql-dashboard 347263722 | ||
| 42658057 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.12 | simonw 9599 | MDc6UmVsZWFzZTQyNjU4MDU3 | 0.12 | main | 0.12 | 0 | 0 | 2021-05-09T04:27:59Z | 2021-05-09T04:30:09Z | First non-alpha release! Django SQL Dashboard is now ready for people to use against their production Django applications. - Saved dashboards can now be created from the interactive dashboard page. [#44](https://github.com/simonw/django-sql-dashboard/issues/44) - New progress bar widget for queries that return numeric columns `total_count` and `completed_count`. [#77](https://github.com/simonw/django-sql-dashboard/issues/77) - The list of available tables now better reflects your current permissions, and shows the columns for each listed table. [#79](https://github.com/simonw/django-sql-dashboard/issues/79), [#80](https://github.com/simonw/django-sql-dashboard/issues/80) - The dashboard index page now lists saved dashboards that the user is able to view or edit. [#81](https://github.com/simonw/django-sql-dashboard/issues/81) - "Edit" link for dashboards links to the Django Admin, which now respects the edit policy set for a dashboard. [#44](https://github.com/simonw/django-sql-dashboard/issues/44) - New documentation section covering security. [#6](https://github.com/simonw/django-sql-dashboard/issues/6) - Show row count on non-truncated results. [#76](https://github.com/simonw/django-sql-dashboard/issues/76) - More robust extraction of named parameteters from queries, fixing some errer-cases. [#75](https://github.com/simonw/django-sql-dashboard/issues/75) - Custom widgets can now extend a `django_sql_dashboard/widgets/_base_widget.html` base template. [#78](https://github.com/simonw/django-sql-dashboard/issues/78) - Fixed a bug caused by errors on saved dashboard pages being displayed as editable text. [#74](https://github.com/simonw/django-sql-dashboard/issues/74) - Unlisted public dashboards now include a robots tag to avoid being indexed by search engines. [#42](https://github.com/simonw/django-sql-dashboard/issues/42) | django-sql-dashboard 347263722 | ||
| 42658154 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.12.1 | simonw 9599 | MDc6UmVsZWFzZTQyNjU4MTU0 | 0.12.1 | main | 0.12.1 | 0 | 0 | 2021-05-09T04:39:48Z | 2021-05-09T04:41:38Z | - Improved and updated documentation for [saved dashboards](https://django-sql-dashboard.readthedocs.io/en/latest/saved-dashboards.html). [#84](https://github.com/simonw/django-sql-dashboard/issues/84) - Added "Remove all queries" link for resetting interactive dashboard. [#85](https://github.com/simonw/django-sql-dashboard/issues/85) | django-sql-dashboard 347263722 | ||
| 42658804 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.12.2 | simonw 9599 | MDc6UmVsZWFzZTQyNjU4ODA0 | 0.12.2 | main | 0.12.2 | 0 | 0 | 2021-05-09T05:45:12Z | 2021-05-09T05:47:24Z | - Documentation is now hosted at https://django-sql-dashboard.datasette.io/ [#86](https://github.com/simonw/django-sql-dashboard/issues/86) - Dashboard index link is no longer shown on saved dashboards to to users without permission to view it. [#87](https://github.com/simonw/django-sql-dashboard/issues/87) | django-sql-dashboard 347263722 | ||
| 42659370 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.12.3 | simonw 9599 | MDc6UmVsZWFzZTQyNjU5Mzcw | 0.12.3 | main | 0.12.3 | 0 | 0 | 2021-05-09T06:39:15Z | 2021-05-09T06:40:54Z | - Fixed bug where saved dashboards relating to groups could be displayed multiple times. [#90](https://github.com/simonw/django-sql-dashboard/issues/90) - Removed duplicate "Run queries" button. [#89](https://github.com/simonw/django-sql-dashboard/issues/89) - HTML page titles now include named parameter values, if available. [#88](https://github.com/simonw/django-sql-dashboard/issues/88) | django-sql-dashboard 347263722 | ||
| 42715132 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.13 | simonw 9599 | MDc6UmVsZWFzZTQyNzE1MTMy | 0.13 | main | 0.13 | 0 | 0 | 2021-05-10T15:44:18Z | 2021-05-10T15:47:08Z | - New word cloud widget displayed when queries return `wordcount_word` and `wordcount_count` columns. [#91](https://github.com/simonw/django-sql-dashboard/issues/91) - All pages are now served with `cache-control: private` header if the user is logged in. [#92](https://github.com/simonw/django-sql-dashboard/issues/92) - Much improved README, including a detailed list of features. [#40](https://github.com/simonw/django-sql-dashboard/issues/40) | django-sql-dashboard 347263722 | ||
| 43020565 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.14 | simonw 9599 | MDc6UmVsZWFzZTQzMDIwNTY1 | 0.14 | main | 0.14 | 0 | 0 | 2021-05-16T20:14:52Z | 2021-05-16T20:24:32Z | - Fixed a security and permissions flaw, where users without the `execute_sql` permission could still run custom queries by editing saved dashboards using the Django admin interface. [#94](https://github.com/simonw/django-sql-dashboard/issues/94) - Bar charts now preserve the order in which the data is returned by the query. [#106](https://github.com/simonw/django-sql-dashboard/issues/106) - Example select statements now include explicit columns. [#105](https://github.com/simonw/django-sql-dashboard/issues/105) - Columns on the dashboard page now respond to media queries, collapsing to a single column on narrow or mobile browser windows. [#106](https://github.com/simonw/django-sql-dashboard/issues/106) - Fixed hard-coded `/dashboard/` URL, thanks Flávio Juvenal da Silva Junior. [#99](https://github.com/simonw/django-sql-dashboard/issues/99) - Fixed bug where `?_save-` parameters could be accidentally reflected in the query string. [#104](https://github.com/simonw/django-sql-dashboard/issues/104) - Explicitly require at least Django 3.0. [#101](https://github.com/simonw/django-sql-dashboard/issues/101) - Fixed a warning about `AutoField` migrations with Django 3.2. [#103](https://github.com/simonw/django-sql-dashboard/issues/103) - Fixed a bug where users lacking permissions could end up in an infinite redirect. [#30](https://github.com/simonw/django-sql-dashboard/issues/30) - Configuration and security documentation now recommends using a read-only database replica as the most robust option. [#95](https://github.com/simonw/django-sql-dashboard/issues/95) - Added screenshots and demo links for all of the included [widgets](https://django-sql-dashboard.datasette.io/en/latest/widgets.html). [#96](https://github.com/simonw/django-sql-dashboard/issues/96) | django-sql-dashboard 347263722 | ||
| 43494476 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.15 | simonw 9599 | MDc6UmVsZWFzZTQzNDk0NDc2 | 0.15 | main | 0.15 | 0 | 0 | 2021-05-25T00:30:10Z | 2021-05-25T00:34:05Z | - Configuration instructions for people using `dj-database-url` and `django-configurations` - thanks, Paolo Melchiorre. [#110](https://github.com/simonw/django-sql-dashboard/issues/110) - Added a useful SQL pattern to the [progress bar widget documentation](https://django-sql-dashboard.datasette.io/en/latest/widgets.html#progress-bar-total-count-completed-count). - SQL queries on saved dashboards are now hidden behind a details/summary element. [#117](https://github.com/simonw/django-sql-dashboard/issues/117) - Documentation now [covers the execute_sql permission](https://django-sql-dashboard.datasette.io/en/latest/setup.html#django-permissions). [#112](https://github.com/simonw/django-sql-dashboard/issues/112) | django-sql-dashboard 347263722 | ||
| 44056696 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.15.1 | simonw 9599 | MDc6UmVsZWFzZTQ0MDU2Njk2 | 0.15.1 | main | 0.15.1 | 0 | 0 | 2021-06-03T16:26:37Z | 2021-06-03T16:27:35Z | - Fixed 500 error caused when markdown widget attempted to render a null value. [#124](https://github.com/simonw/django-sql-dashboard/issues/124) | django-sql-dashboard 347263722 | ||
| 44171283 | https://github.com/simonw/django-sql-dashboard/releases/tag/0.16 | simonw 9599 | MDc6UmVsZWFzZTQ0MTcxMjgz | 0.16 | main | 0.16 | 0 | 0 | 2021-06-06T19:10:26Z | 2021-06-06T19:12:45Z | - This release includes a small potentially backwards-incompatible change: the `description` field for a saved dashboard is now treated as Markdown and rendered as such when the saved dashboard is displayed. It is very unlikely that this will affect any of your existing dashboards but you should still check before applying the upgrade. Thanks, Atul Varma. [#115](https://github.com/simonw/django-sql-dashboard/issues/115) | django-sql-dashboard 347263722 | ||
| 45532877 | https://github.com/simonw/django-sql-dashboard/releases/tag/1.0 | simonw 9599 | MDc6UmVsZWFzZTQ1NTMyODc3 | 1.0 | main | 1.0 | 0 | 0 | 2021-07-01T03:52:11Z | 2021-07-01T03:58:28Z | - Implemented a new column cog menu, with options for sorting, counting distinct items and counting by values. [#57](https://github.com/simonw/django-sql-dashboard/issues/57) - Fixed bug where columns named after PostgreSQL reserved words (such as `on` or `group`) produced invalid suggested SELECT queries. [#134](https://github.com/simonw/django-sql-dashboard/issues/134) - New Docker Compose configuration to support Docker development environments. Thanks, Atul Varma. [#128](https://github.com/simonw/django-sql-dashboard/issues/128) - Admin change list view now only shows dashboards the user has permission to edit. Thanks, Atul Varma. [#130](https://github.com/simonw/django-sql-dashboard/issues/130) | django-sql-dashboard 347263722 | ||
| 45740775 | https://github.com/simonw/django-sql-dashboard/releases/tag/1.0.1 | simonw 9599 | MDc6UmVsZWFzZTQ1NzQwNzc1 | 1.0.1 | main | 1.0.1 | 0 | 0 | 2021-07-06T00:35:24Z | 2021-07-06T00:37:06Z | - Fixed an error when running against PostgreSQL 10 - thanks, Ryan Cheley. [#138](https://github.com/simonw/django-sql-dashboard/pull/138) - This tool is now tested against PostgreSQL 10, 11, 12 and 13. [#139](https://github.com/simonw/django-sql-dashboard/issues/139) | django-sql-dashboard 347263722 | ||
| 61310712 | https://github.com/simonw/django-sql-dashboard/releases/tag/1.0.2 | simonw 9599 | RE_kwDOFLLS6s4Dp4b4 | 1.0.2 | main | 1.0.2 | 0 | 0 | 2022-03-08T19:58:44Z | 2022-03-08T20:00:13Z | - Fixed a bug where queries that returned an array containing dates (or other objects without a defined Python JSON serialization) would result in a 500 error. [#146](https://github.com/simonw/django-sql-dashboard/issues/146) | django-sql-dashboard 347263722 | ||
| 64797039 | https://github.com/simonw/django-sql-dashboard/releases/tag/1.1 | simonw 9599 | RE_kwDOFLLS6s4D3Llv | 1.1 | main | 1.1 | 0 | 0 | 2022-04-20T00:23:41Z | 2022-04-20T00:24:47Z | - `<br>` tag is now supported in HTML output. [#150](https://github.com/simonw/django-sql-dashboard/issues/150) | django-sql-dashboard 347263722 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [releases] (
[html_url] TEXT,
[id] INTEGER PRIMARY KEY,
[author] INTEGER REFERENCES [users]([id]),
[node_id] TEXT,
[tag_name] TEXT,
[target_commitish] TEXT,
[name] TEXT,
[draft] INTEGER,
[prerelease] INTEGER,
[created_at] TEXT,
[published_at] TEXT,
[body] TEXT,
[repo] INTEGER REFERENCES [repos]([id])
, [reactions] TEXT, [mentions_count] INTEGER);
CREATE INDEX [idx_releases_repo]
ON [releases] ([repo]);
CREATE INDEX [idx_releases_author]
ON [releases] ([author]);