sql-explorer

Minor bugfixes

• Add support for Django 5.0. Drop support for Python < 3.10.
• Basic code completion in the editor!
• Front-end must be built with Vite if installing from source.
• #565 : Front-end modernization. CodeMirror 6. Bootstrap5. Vite-based build
• #566 : Django 5 support & tests
• #537 : S3 signature version support
• #562 : Record and show whether the last run of each query was successful
• #571 : Replace isort and flake8 with Ruff (linting)

Note: There is no 4.0.0 release as 4.0.1 was needed to resolve a conflict on PyPi

• Simplify Vite inclusion of built files (does not require manifest.json)
• Dynamic use of STATIC_URL for different prod environments

• Fix additional bugs, break apart JS for faster loading.
• Removes floatThead dependency
• Removes python <3.10 support from setup.py

• Removes jquery-ui dependency (replaced with sortablejs)
• Uses dynamic imports so the JS is now chunked
• Fixes a subtle versioning info that prevents PyPi from flagging beta releases
• Adds back support for Django 3.2 (no code changes required - simply added back to tox tests and setup.py)
• Fixes a few styling bugs

What's New

• #565: Front-end modernization. Code completion via CodeMirror 6. Bootstrap5. Vite-based build
• #566: Django 5 support & tests
• #537: S3 signature version support
• #562: Visually show whether the last run was successful
• #571: Replace isort and flake8 with Ruff (linting)

What's Changed

• Test for SET PASSWORD by @covracer in https://github.com/groveco/django-sql-explorer/pull/539
• ci: pre-commit autoupdate by @pre-commit-ci in https://github.com/groveco/django-sql-explorer/pull/540
• ci: pre-commit autoupdate by @pre-commit-ci in https://github.com/groveco/django-sql-explorer/pull/541
• #543: Fix User.pk reference by @eeriksp in https://github.com/groveco/django-sql-explorer/pull/544

New Contributors

• @covracer made their first contribution in https://github.com/groveco/django-sql-explorer/pull/539

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/3.2.0...3.2.1

What's Changed

• Bump actions/checkout from 1 to 3 by @dependabot in https://github.com/groveco/django-sql-explorer/pull/530
• Bump actions/setup-python from 2 to 4 by @dependabot in https://github.com/groveco/django-sql-explorer/pull/531
• ci: pre-commit autoupdate by @pre-commit-ci in https://github.com/groveco/django-sql-explorer/pull/532
• CSRF token httponly support + s3 destination for async results by @YakiYaki in https://github.com/groveco/django-sql-explorer/pull/533
• ci: pre-commit autoupdate by @pre-commit-ci in https://github.com/groveco/django-sql-explorer/pull/536

New Contributors

• @YakiYaki made their first contribution in https://github.com/groveco/django-sql-explorer/pull/533

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/3.1.1...3.2.0

What's Changed

• fix: add missing migration by @scastlara in https://github.com/groveco/django-sql-explorer/pull/528
• chore: Release 3.1.1 by @marksweb in https://github.com/groveco/django-sql-explorer/pull/529

New Contributors

• @scastlara made their first contribution in https://github.com/groveco/django-sql-explorer/pull/528

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/3.1.0...3.1.1

What's Changed

• feat: Favorite queries by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/520
• feat: Add param labels by @spapas in https://github.com/groveco/django-sql-explorer/pull/519
• feat: pivot export by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/517
• ci: Adding django 4.2 to the test suite by @marksweb in https://github.com/groveco/django-sql-explorer/pull/521
• ci: ran pre-commit on all files for ci bot integration by @marksweb in https://github.com/groveco/django-sql-explorer/pull/523
• ci: coverage update by @marksweb in https://github.com/groveco/django-sql-explorer/pull/522
• ci: pre-commit autoupdate by @pre-commit-ci in https://github.com/groveco/django-sql-explorer/pull/524

New Contributors

• @pre-commit-ci made their first contribution in https://github.com/groveco/django-sql-explorer/pull/524

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/3.0.1...3.1.0

What's Changed

• Bump actions/checkout from 2 to 3 by @dependabot in https://github.com/groveco/django-sql-explorer/pull/510
• Bump actions/setup-python from 2 to 4 by @dependabot in https://github.com/groveco/django-sql-explorer/pull/512
• Bump github/codeql-action from 1 to 2 by @dependabot in https://github.com/groveco/django-sql-explorer/pull/511
• Fix for running without optional packages by @marksweb in https://github.com/groveco/django-sql-explorer/pull/515

New Contributors

• @dependabot made their first contribution in https://github.com/groveco/django-sql-explorer/pull/510

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/3.0...3.0.1

What's Changed

• Document breakage of Format button due to CSRF_COOKIE_HTTPONLY (#492) by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/496
• Avoid execution of parameterised queries when viewing query by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/497
• Change sql blacklist functionality from regex to sqlparse by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/498
• Form display in popup now requires sanitize: false flag by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/500
• pre-commit hooks by @marksweb in https://github.com/groveco/django-sql-explorer/pull/504
• Problem importing celery to enable tasks by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/501
• Feature/more s3 providers by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/505
• Check sql blacklist on execution as well as save by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/506
• Bugfix/premature imports by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/508
• 3.0 by @marksweb in https://github.com/groveco/django-sql-explorer/pull/509

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.5.0...3.0

What's Changed

• Improved templates to make easier to customize them for integration w… by @nad2000 in https://github.com/groveco/django-sql-explorer/pull/478
• Add pie and line chart tabs to query result preview by @eeriksp in https://github.com/groveco/django-sql-explorer/pull/481
• docs: Fix a few typos by @timgates42 in https://github.com/groveco/django-sql-explorer/pull/488
• Fixes Security hole in blacklist for MySQL #490 by @lawson89 in https://github.com/groveco/django-sql-explorer/pull/494

New Contributors

• @nad2000 made their first contribution in https://github.com/groveco/django-sql-explorer/pull/478
• @eeriksp made their first contribution in https://github.com/groveco/django-sql-explorer/pull/481
• @lawson89 made their first contribution in https://github.com/groveco/django-sql-explorer/pull/494

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.4.2...2.5.0

What's Changed

• Improved templates to make easier to customize them for integration w… by @nad2000 in https://github.com/groveco/django-sql-explorer/pull/478
• Add pie and line chart tabs to query result preview by @eeriksp in https://github.com/groveco/django-sql-explorer/pull/481

New Contributors

• @nad2000 made their first contribution in https://github.com/groveco/django-sql-explorer/pull/478
• @eeriksp made their first contribution in https://github.com/groveco/django-sql-explorer/pull/481

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.4.2...2.5.0-beta

What's Changed

• Add SET to blacklisted keywords by @assem-ch in https://github.com/groveco/django-sql-explorer/pull/475
• Fix for #483 by @spapas in https://github.com/groveco/django-sql-explorer/pull/484

New Contributors

• @assem-ch made their first contribution in https://github.com/groveco/django-sql-explorer/pull/475

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.4.1...2.4.2

What's Changed

• fix extra space around sql by @fearless0307 in https://github.com/groveco/django-sql-explorer/pull/471
• Some tests misusing assertTrue for comparisons fix by @code-review-doctor in https://github.com/groveco/django-sql-explorer/pull/474

New Contributors

• @code-review-doctor made their first contribution in https://github.com/groveco/django-sql-explorer/pull/474

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.4...2.4.1

What's Changed

• Add missing comma by @Bubbassauro in https://github.com/groveco/django-sql-explorer/pull/462
• Use Django built-in get_valid_filename by @SuJiKiNen in https://github.com/groveco/django-sql-explorer/pull/466
• Upgrade JS/CSS package by @fearless0307 in https://github.com/groveco/django-sql-explorer/pull/470

New Contributors

• @Bubbassauro made their first contribution in https://github.com/groveco/django-sql-explorer/pull/462
• @SuJiKiNen made their first contribution in https://github.com/groveco/django-sql-explorer/pull/466
• @fearless0307 made their first contribution in https://github.com/groveco/django-sql-explorer/pull/470

Full Changelog: https://github.com/groveco/django-sql-explorer/compare/2.3...2.4

Russian translations.

• Updated docs theme to furo
• #445: Added EXPLORER_NO_PERMISSION_VIEW setting to allow override of the "no permission" view (Fix #440)
• #444: Updated structure of the settings docs (Fix #443)

• #442: GET params passed to the fullscreen view (Fix #433)
• #441: Include BOM in CSV export (Fix #430)