All Versions
29
Latest Version
Avg Release Cycle
137 days
Latest Release
986 days ago

Changelog History
Page 2

  • v2.0.0 Changes

    October 09, 2020
    • 💥 BREAKING CHANGE: #403: Dropping support for EOL Python 2.7 <https://www.python.org/doc/sunset-python-2/>_ and 3.5 <https://pythoninsider.blogspot.com/2020/10/python-35-is-no-longer-supported.html>_

    Major Changes

    • 👍 #404_: Add support for Django 3.1 and drop support for (EOL) <2.2
    • 🔨 #408_: Refactored the application, updating the URLs to use path and the views into a module

    Minor Changes

    • 👍 #334_: Django 2.1 support
    • #337_: Fix Oracle query failure caused by TextField in a group by clause
    • 🌐 #345_: Added (some) Chinese translation
    • #366_: Changes to Travis django versions
    • #372_: Run queries as atomic requests
    • 👍 #382_: Django 2.2 support
    • #383_: Typo in the README
    • 🚚 #385_: Removed deprecated render_to_response usage
    • #386_: Bump minimum django version to 2.2
    • 👍 #387_: Django 3 support
    • #390_: README formatting changes
    • 📦 #393_: Added option to install XlsxWriter as an extra package
    • #397_: Bump patch version of django 2.2
    • #406_: Show some love to the README
    • 🛠 Fix #341_: PYC files excluded from build

  • v1.1.3 Changes

    September 23, 2019

    2019-09-23

    • #347: URL-friendly parameter encoding
    • ⚡️ #354: Updating dependency reference for Python 3 compatibility
    • #357: Include database views in list of tables
    • #359: Fix unicode issue when generating migration with py2 or py3
    • 👻 #363: Do not use "message" attribute on exception

    • 368: Update EXPLORER_SCHEMA_EXCLUDE_TABLE_PREFIXES

    • Minor Changes

      • release checklist included in repo
      • readme updated with new screenshots
      • python dependencies/optional-dependencies updated to latest
      • six, xlsxwriter, factory-boy, sqlparse

  • v1.1.2 Changes

    August 14, 2018

    2018-08-14

    • 🛠 Fix #269
    • 🛠 Fix bug when deleting query

    • 🛠 Fix bug when invalid characters present in Excel worksheet name

    • Major Changes

      • Django 2.0 compatibility
      • Improved interface to database connection management

    • Minor Changes

      • Documentation updates
      • Load images over same protocol as originating page

  • v1.1.1 Changes

    March 21, 2017

    2017-03-21

    • 🛠 Fix #288 (incorrect import)

  • v1.1.0 Changes

    March 19, 2017

    2017-03-19

    • BREAKING CHANGE: EXPLORER_DATA_EXPORTERS setting is now a list of tuples insead of a dictionary. This only affects you if you have customized this setting. This was to preserve ordering of the export buttons in the UI.

    • BREAKING CHANGE: Values from the database are now escaped by default. Disable this behavior (enabling potential XSS attacks) with the EXPLORER_UNSAFE_RENDERING setting.

    • Major Changes

      • Django 1.10 and 2.0 compatibility
      • Theming & visual updates
      • PDF export
      • Query-param based authentication (https://github.com/groveco/django-sql-explorer/pull/254)
      • Schema built via SQL querying rather than Django app/model introspection. Paves the way for the tool to be pointed at any DB, not just Django DBs

    • Minor Changes

      • Switched from TinyS3 to Boto (will switch to Boto3 in next release)
      • Optionally show row numbers in results preview pane
      • Full-screen view (icon on top-right of preview pane)
      • Moved 'open in playground' to icon on top-right on SQL editor
      • Save-only option (does not execute query)
      • Show the time that the query was rendered (useful if you've had a tab open a while)

  • v1.0.0 Changes

    June 16, 2016
    • 💥 BREAKING CHANGE: Dropped support for Python 2.6. See .travis.yml for test matrix.
    • 💥 BREAKING CHANGE: The 'export' methods have all changed. Those these weren't originally designed to be external APIs, folks have written consuming code that directly called export code.

    If you had code that looked like:

      ``explorer.utils.csv_report(query)``

    You will now need to do something like:

      ``explorer.exporters.get_exporter_class('csv')(query).get_file_output()``
    • There is a new export system! v1 is shipping with support for CSV, JSON, and Excel (xlsx). The availablility of these can be configured via the EXPLORER_DATA_EXPORTERS setting.
      • Note that for Excel export to work, you will need to install xlsxwriter from optional-requirements.txt.
    • Introduced Query History link. Find it towards the top right of a saved query.
    • 🐎 Front end performance improvements and library upgrades.
    • 👍 Allow non-admins with permission to log into explorer.
    • ➕ Added a proper test_project for an easier entry-point for contributors, or folks who want to kick the tires.
    • 🛠 Loads of little bugfixes.

  • v0.9.2 Changes

    February 02, 2016
    • 🛠 Fixed readme issue (.1) and setup.py issue (.2)

  • v0.9.1 Changes

    February 01, 2016

    Major changes

    • ⬇️ Dropped support for Django 1.6, added support for Django 1.9. See .travis.yml for test matrix.
    • ⬇️ Dropped charted.js & visualization because it didn't work well.
    • Client-side pivot tables with pivot.js. This is ridiculously cool!

    Minor (but awesome!) changes

    • Cmd-/ to comment/uncomment a block of SQL
    • Quick 'shortcut' links to the corresponding querylog to more quickly share results. Look at the top-right of the editor. Also works for playground!
    • Prompt for unsaved changes before navigating away
    • 👌 Support for default parameter values via $$paramName:defaultValue$$
    • 🏗 Optional Celery task for truncating query logs as entries build up

    • Display historical average query runtime

    • 0️⃣ Increased default number of rows from 100 to 1000

    • Increased SQL editor size (5 additional visible lines)

    • 👍 CSS cleanup and streamlining (making better use of foundation)

    • 🛠 Various bugfixes (blacklist not enforced on playground being the big one)

    • ⬆️ Upgraded front-end libraries

    • Hide Celery-based features if tasks not enabled.

  • v0.8.0 Changes

    October 21, 2015

    2015-10-21

    • ⏱ Snapshots! Dump the csv results of a query to S3 on a regular schedule. More details in readme.rst under 'features'.
    • Async queries + email! If you have a query that takes a long time to run, execute it in the background and Explorer will send you an email with the results when they are ready. More details in readme.rst
    • 👀 Run counts! Explorer inspects the query log to see how many times a query has been executed.
    • 👀 Column Statistics! Click the ... on top of numeric columns in the results pane to see min, max, avg, sum, count, and missing values.
    • Python 3! - Django 1.9!
    • Delimiters! Export with delimiters other than commas.
    • 👀 Listings respect permissions! If you've given permission to queries to non-admins, they will see only those queries on the listing page.

  • v0.7.0 Changes

    February 18, 2015

    2015-02-18

    • ➕ Added search functionality to schema view and explorer view (using list.js).
    • Python 2.6 compatibility.
    • Basic charts via charted (from Medium via charted.co).
    • SQL formatting function.
    • Token authentication to retrieve csv version of queries.
    • 🛠 Fixed south_migrations packaging issue.
    • 🔨 Refactored front-end and pulled CSS and JS into dedicated files.