Skip to content

Latest commit

 

History

History
418 lines (282 loc) · 11.6 KB

CHANGELOG.md

File metadata and controls

418 lines (282 loc) · 11.6 KB
Raw

Changelog

2.7.1

August 2, 2018

  • Fix query editor not responding to input after query result scroll

2.7.0

July 1, 2018

2.6.1

June 17, 2018

  • Fix query editor loading when connections load slowly

2.6.0

May 5, 2018

  • Add Cassandra support
  • Sort driver dropdown in connection form

2.5.8

May 5, 2018

  • Extend data grid to full width of container

2.5.7

May 4, 2018

  • Implement data grid using react-virtualized (fixes resizable columns)
  • Fix chart rendering error when columns no longer returned by query are referenced
  • Allow case insensitive user lookup by email (fixes case sensitive signup/signin issues)

2.5.6

April 25, 2018

  • Revert chart fix from 2.5.5 preventing charts from rendering

2.5.5

April 23, 2018

  • Remove frameguard protection (fixes iframe embeds)
  • Use CDN for bootstrap font (fixes missing icons when using baseUrl)
  • Update dependencies
  • Fix 0 values classified as string in query results
  • Fix UI chart error when referencing columns no longer returned by query
  • Fix SQLPad crash postgres queries exceeding max row limit
  • Only show admin registration open message if admin registration is actually open
  • Fix baseUrl of undefined error
  • A lot of driver refactoring
    • Driver implementations now consolidated at /server/drivers
    • All drivers now tested
  • New docker build process/root-level Dockerfile

2.5.4

April 1, 2018

  • Fixed password reset link when using base url

2.5.3

March 29, 2018

  • Fix SAP HANA schema not being cached due to dots in column name

2.5.2

March 27, 2018

  • Fix error when updating connection
  • Fix SQLPAD_BASE_URL / --base-url use

2.5.1

February 5, 2018

  • Fix early session expiration / extend session expiration every response

2.5.0

February 5, 2018

  • Added support for SAP HANA (ccmehil)
  • Many security improvements
    • Majority of dependencies updated
    • Implemented expressjs security best practices
    • Helmet middleware added
    • Express-session used instead of cookie-session
    • Randomly generated cookie secrets
    • Sessions now expire (1 hour)
    • Limited amount of config info sent to front end
  • Updated styling for User and Connection admin pages (bringing boring tables back. updates to rest of app to follow)
  • Schema sidebar updates
    • Limits presto schema sidebar to schema if provided in connection info
    • Removed (view) label on views

2.4.2

December 27, 2017

  • Fixed generic schema info query for case-sensitive collation

2.4.1

December 3, 2017

  • Fixed disappearing data table after vis resize

2.4.0

December 3, 2017

  • Added resizable panes to query editor
  • Added SQL formatter to query editor (KochamCie)
  • Added clone query button to query editor
  • Added prompt when navigating away from unsaved query edits
  • Redesigned bar charts in data grid to a more minimal design
  • Redesigned query editor nav bar
    • Brings query name input out of modal
    • Adds unsaved changes indicator to save button
    • Adds shortcut/tip documentation to modal
    • Uses nav links instead of buttons for less visual noise
  • Updated editor shortcuts
    • Running query now ctrl+return or command+return
    • Format query with shift+return
  • Updated tauCharts to latest version
  • Implemented react-router & fix unnecessary page loads on navigation
  • Bundled remaining vendor JavaScript libs
  • Removed external font-awesome dependency from CDN
  • Fixed bigint handling for MySQL
  • Fixed date display in charts
  • Fixed date display for MySQL
  • Fixed cell content not expanding when cell is expanded
  • Fixed unintended page refresh on editor sidebar link clicks
  • Fixed layout bugs from flexbox
  • Lots of misc front-end refactoring

2.3.2

October 21, 2017

  • Fix --base-url config use
  • Refactored layout styling to use flexbox css

2.3.1

October 7, 2017

  • Force no-cache on fetch requests (fixes some odd IE issues)
  • Fix docker entry point

2.3.0

September 4, 2017

  • New features
    • Added systemd socket activation support (epeli)
    • Added option to disable update check
    • Resizable data grid columns (slightly buggy)
  • Fixes
    • Fixes MySQL schema sidebar showing extra dbs
    • Fixes loss of precision of numbers in UI grid (even if they were text)
    • Fixes Presto driver
    • Fixes React deprecation warnings
    • Fixes incorrect date display in UI
      • All dates were being localized. now displayed without localization
  • Compatibility notes
    • Node v6.x now required at minimum

2.2.0

May 29, 2017

  • added SOCKS proxy support for postgres (brysgo)

2.2.0-beta2

March 19, 2017

  • fixed version displayed in about modal

2.2.0-beta1

March 18, 2017

  • fixed query tag weirdness from previous v1 weirdness
  • leading 0s preserved in query results and treated as strings instead of numbers
  • support for postgres ssl certs (johicks and nikicat)
  • fixed crate v1 schema support (mikethebeer)
  • naive autocomplete
  • refactored connection admin screen
  • changed build system to fork create-react-app

2.1.3

January 28, 2017

  • Ensure strict db startup order (vweevers)
  • Improve query editor performance/reduce SQL editor lag

2.1.2

December 9, 2016

  • Fix chart only view not displaying charts
  • Fix query editor search
  • Update dependencies

2.1.1

November 29, 2016

  • Fix: disabling of links on query details modal (vweevers)
  • Fix: Vis tab loading indicator behaves same as query tab, hiding error on rerun (vweevers)
  • Fix: Charts rendered lazily. Query result grid loads faster, large query results won't lock browser until you try to chart. (vweevers)
  • Fix: Hide local auth form if DISABLE_USERPASS_AUTH=true

2.1.0

November 20, 2016

  • run https via sqlpad directly (see additional setting) (jameswinegar)
  • Support non English characters when downloading files (askluyao)
  • render booleans/null timestamps properly

2.0.0

October 12, 2016

  • (See beta 1 - 3 release notes)

2.0.0-beta3

October 11, 2016

  • Password reset/forogot password functionality added
    • Admins may generate reset links manually
    • If smtp is set up forgot password link is enabled
  • EMAIL
  • Configuration:
    • Checklist added for OAuth and Email
    • Item is disabled in UI if value is provided by environment or cli
    • sensitive values are only masked if environment variables

2.0.0-beta2

September 19, 2016

  • Move to single-page-app architecture
  • New query loading animation
  • Title and export options added to chart/table only views
  • Add Presto DB support
  • Basic Auth available for non-admin api
  • More performance improvements
  • Misc bug fixes
  • More code cleanup

2.0.0-beta1

September 1, 2016

  • UI design updates everywhere
  • Query Listing:
    • preview query contents by hovering over query listing
    • occassional search/filter weirdness has been fixed
  • Query Editor:
    • Schema sidebar no longer separates views and tables in hierarchy
    • New result grid
      • inline bar plot rendered for numeric values
      • display issues fixed for certain browsers
    • New tags widget for cleaner input
    • Browser tab name now reflects query name
    • Updated taucharts library with stacked bar charts
    • Line and Scatterplot charts may have chart filters enabled
    • 'show advanced settings' in vis editor now has a few advanced settings depending on chart (y min/max, show trendline, show filter)
    • switching between sql/vis tabs won't reset chart series toggles
    • table/chart only links may be set to no longer require login (see configuration page)
  • Configuration:
    • Specific config inputs and labels - no more open ended key/value inputs
    • Current environment config documented with assistive popovers
  • Update notification moved in-app
  • Under the hood
    • updated all the code dependencies
    • reworked some foundation code for easier future development
  • Known issues / not yet implemented:
    • Query tag input does not allow creation
    • Query auto-refresh not yet implemented

1.17.0

  • empty postgres queries (like executing a comment only) no longer crash sqlpad
  • materialized views are included in schema sidebar for postgres

1.16.0

  • SQLPad may now be mounted under a base url path by providing --base-url cli flag or SQLPAD_BASE_URL env variable
  • Updated taucharts to 0.9.1
  • Legends are now included when saving png chart images

1.15.0

  • Many client-side and server-side dependencies updated
  • Add ability to bind to a specific IP address via the --ip flag or the SQLPAD_IP environment variable
  • Removed sort inputs for bar charts. (Chart sort may instead be influenced using ORDER BY in SQL query.)

1.14.0

  • Add ability to turn off date localization (add config item "localize" set to "false")

1.13.0

  • Add --debug flag to SQLPad cli to enable extra logging
  • Port and passphrase may be set via environment variables SQLPAD_PORT and SQLPAD_PASSPHRASE

1.12.0

  • Add support for Crate.io

1.11.0

  • Auto-refresh query every x seconds
  • Fix crash when unregistered user tries to log in

1.10.0

  • MySQL connections can now old/insecure pre 4.1 auth system
  • links now available to display just the chart or data grid

1.9.0

  • Charting now handled by the very cool tauCharts library. It's a bit faster, has facets, grammar of graphics concepts, handles time series data better, trendlines.
  • When changing chart types, SQLPad will remember and reapply the field selections where applicable.
  • SQLPad database files compacted every 10 minutes, instead of once a day
  • Signup page styling is fixed.
  • Schema-item-name copy-to-clipboard buttons now available. Opt in by creating configuration item showSchemaCopyButton to true.
  • Query results can now be downloaded as xlsx file. (link will be hidden if csv downloads are disabled)

1.8.2

  • Connection password no longer visible on connection screen.

1.8.1

  • Duplicate content headers prevented when csv filename contains comma.

1.8.0

  • Authentication now managed by Passport.js
  • Username/Password authenication strategy can be disabled by setting environment variable DISABLE_USERPASS_AUTH
  • Google OAuth strategy can be enabled by setting GOOGLE_CLIENT_ID, GOOGLE_CLIENT_SECRET, and PUBLIC_URL environment variables
  • Query can be posted to Slack webhook when saved. To enable, create configuration item with key "slackWebhook", and set the value to a Slack incoming WebHook URL.
  • Whitelist domains for username administration by setting environment variable WHITELISTED_DOMAINS
  • Query connection now selected by default if only one exists

1.7.0

  • Tags now look like tags
  • Typeahead added for easy tag creation

1.6.0

  • Code cleanup

1.5.1

  • remove console logging used for debugging

1.5.0

  • Vertica now supported via Vertica driver
  • CSVs no longer generated if disabled
  • optimizations made to schema-info processing

1.4.1

  • improved db tree/schema info performance

1.4.0

  • Charts can be saved as images

1.3.0

  • work-around to handle multiple statements using postgres driver
  • fix to provide MAX_SAFE_INTEGER if not defined

1.2.1

  • query results are limited to 50,000 records. This can be changed by adding a configuration key "queryResultMaxRows" and providing the number of max rows you would like returned.
  • Minor bugfixes
  • Text selection enabled on query results
  • schema information now cached
  • connection port is optional in UI

1.2.0

  • Added port property to connections
  • Configuration system has been added
  • CSV downloads can be disabled via configuration. Add new item with key "allowCsvDownload" with value "false" to disable.

1.1.0

  • Add initial Vertica support via use of Postgres driver

1.0.0

  • SQLPad is released