- 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
- 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.)
- Add ability to turn off date localization (add config item "localize" set to "false")
- Add --debug flag to SqlPad cli to enable extra logging
- Port and passphrase may be set via environment variables SQLPAD_PORT and SQLPAD_PASSPHRASE
- Add support for Crate.io
- Auto-refresh query every x seconds
- Fix crash when unregistered user tries to log in
- MySQL connections can now old/insecure pre 4.1 auth system
- links now available to display just the chart or data grid
- 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
totrue
. - Query results can now be downloaded as xlsx file. (link will be hidden if csv downloads are disabled)
- Connection password no longer visible on connection screen.
- Duplicate content headers prevented when csv filename contains comma.
- 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
- Tags now look like tags
- Typeahead added for easy tag creation
- Code cleanup
- remove console logging used for debugging
- Vertica now supported via Vertica driver
- CSVs no longer generated if disabled
- optimizations made to schema-info processing
- improved db tree/schema info performance
- Charts can be saved as images
- work-around to handle multiple statements using postgres driver
- fix to provide MAX_SAFE_INTEGER if not defined
- 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
- 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.
- Add initial Vertica support via use of Postgres driver
- SqlPad is released!