./www/py-django-sql-explorer, Pluggable app that allows to execute SQL, view, and export the results

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 4.3, Package name: py312-django-sql-explorer-4.3, Maintainer: pkgsrc-users

SQL Explorer aims to make the flow of data between people fast, simple, and
confusion-free.

Quickly write and share SQL queries for any Django app in a simple, usable SQL
editor, preview the results in the browser, share links to download CSV files,
and keep the information flowing!

Explorer values simplicity, intuitive use, unobtrusiveness, stability, and the
principle of least surprise.

Django SQL Explorer is inspired by any number of great query and reporting
tools out there.


Required to run:
[www/py-django] [devel/py-setuptools] [databases/py-sqlparse] [lang/py-six] [databases/py-unicodecsv] [lang/python37]

Required to build:
[pkgtools/cwrappers]

Master sites:

Filesize: 665.695 KB

Version history: (Expand)


CVS history: (Expand)


   2024-11-11 08:29:31 by Thomas Klausner | Files touched by this commit (862)
Log message:
py-*: remove unused tool dependency

py-setuptools includes the py-wheel functionality nowadays
   2024-10-14 08:46:10 by Thomas Klausner | Files touched by this commit (325)
Log message:
*: clean-up after python38 removal
   2024-06-04 12:43:20 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-django-sql-explorer: updated to 4.3

4.3.0

Keyboard shortcut to show schema hints (cmd+S / ctrl+S -- note that is a capital
"S" so the full kbd commands is cmd+shift+s)
DB-managed LLM prompts (editable in django admin)
Versioned .js bundles (for cache busting)
Automatically populate assistant responses that contain code into the editor
Update schema/assistant tables/autocomplete on connection drop-down change
Import models so that migrations are properly understood by Django
Get CSRF from DOM (instead of cookie) if CSRF_USE_SESSIONS is set
   2024-05-07 05:59:49 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-django-sql-explorer: updated to 4.2

4.2

Tracking should be opt-in and not use the SECRET_KEY
Import error (sql_metadata) with 4.1 version
Accessing the database during app initialization
Regex-injection vulnerability
Improved assistant UI
   2024-02-08 23:52:01 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-django-sql-explorer: updated to 4.0.2

4.0.2

Minor bugfixes

4.0.1

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.
* Front-end modernization. CodeMirror 6. Bootstrap5. Vite-based build
* Django 5 support & tests
* S3 signature version support
* Record and show whether the last run of each query was successful
* 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
   2023-12-07 19:10:26 by Adam Ciarcinski | Files touched by this commit (3) | Package updated
Log message:
py-django-sql-explorer: updated to 3.2.1

3.2.1 (2023-07-13)

* Test for SET PASSWORD
* Fix User primary key reference

3.2.0 (2023-05-17)

* CSRF token httponly support + s3 destination for async results

3.1.1 (2023-02-27)

* Added makemigrations --check pre-commit hook
* Add missing migration

3.1.0 (2023-02-25)

* Favorite queries
* Add labels to params like $$paramName|label:defaultValue$$
* Pivot export
* ci: pre-commit autoupdate
* ci: ran pre-commit on all files for ci bot integration
* ci: coverage update
* ci: Adding django 4.2 to the test suite

3.0.1 (2022-12-16)

* Fix for running without optional packages

3.0 (2022-12-15)

Add support for Django >3.2 and drop support for <3.2
Add support for Python 3.9, 3.10 and 3.11 and drop support for <3.8
* Document breakage of "Format" button due to CSRF_COOKIE_HTTPONLY
* Avoid execution of parameterised queries when viewing query
* Change sql blacklist functionality from regex to sqlparse
* Form display in popup now requires sanitize: false flag
* Updated celery support
* Added pre-commit hooks
* Feature/more s3 providers
* Check sql blacklist on execution as well as save
* Conditionally import optional packages
   2023-07-13 12:03:31 by Thomas Klausner | Files touched by this commit (45)
Log message:
*: switch django users to py-django3
   2023-04-30 20:34:07 by Thomas Klausner | Files touched by this commit (1)
Log message:
py-django-sql-explorer: not for python 2