v4.2.0

rickbergfalk · rickbergfalk · commit 60e8e2c9ef30 · 2020-04-06T14:54:02.000-05:00
diff --git a/CHANGELOG.md b/CHANGELOG.md
@@ -1,5 +1,55 @@
 # Changelog
 
+## 4.2.0
+
+### April 6, 2020
+
+#### Features
+
+- Add Google BigQuery support [documentation](https://rickbergfalk.github.io/sqlpad/#/connections?id=bigquery)
+
+- Add SQLite support [documentation](https://rickbergfalk.github.io/sqlpad/#/connections?id=sqlite)
+
+- Adds batch query support to ODBC (last statement is shown in UI)
+
+- Auth: Add option to disable authentication. [documentation](https://rickbergfalk.github.io/sqlpad/#/authentication?id=no-authentication)
+
+  When auth is disabled, application no longer requires authentication.
+
+- Auth: Add proxy authentication support. [documentation](https://rickbergfalk.github.io/sqlpad/#/authentication?id=auth-proxy)
+
+- Add private/shared query model.
+
+  Going forward queries are _private_ by default. When sharing is enabled, query is shared with all users (and they are given write permissions). Finer-grained access to be added in the future (share with specific user, read vs write)
+
+- Add connection and query seed data support [documentation](https://rickbergfalk.github.io/sqlpad/#/seed-data)
+
+- Add service tokens (api tokens). New menu option is available when logged in as admin.
+
+- Add application header for application-level administration
+
+- Adds multi-statement transaction support for Postgres, SQLite, and ODBC. [documentation](https://rickbergfalk.github.io/sqlpad/#/connections?id=multi-statement-transaction-support)
+
+- Add config deprecation for following keys: `debug`, `tableChartLinksRequireAuth`, `keyPath`, `certPath`, `certPassphrase`
+
+- Add connection template support [documentation](https://rickbergfalk.github.io/sqlpad/#/connection-templates)
+
+- Adds additional query run logging for queries executed and details surrounding them (logged under `info` level)
+
+#### Fixes
+
+- Fix: long connection form display to always show save/test buttons
+
+- Use ISO 8601 timestamps for log messages instead of unix epoch
+
+#### Maintenance / Misc / Dev updates
+
+- Updated dependencies
+- Introduced SQLite as backing store. nedb data (embedded db currently in use) will eventually be migrated to SQLite.
+- Added migration framework. Migrations are run at server startup.
+- Added mult-stage build
+- Lots of refactoring to better organize authentication, addition of new features.
+
 ## 4.1.1
 
 ### March 10, 2020
diff --git a/client/package-lock.json b/client/package-lock.json
diff --git a/client/package.json b/client/package.json
@@ -1,6 +1,6 @@
 {
   "name": "sqlpad-front-end",
-  "version": "4.1.1",
+  "version": "4.2.0",
   "private": true,
   "proxy": "http://localhost:3010",
   "dependencies": {
diff --git a/docs/_sidebar.md b/docs/_sidebar.md
@@ -4,6 +4,7 @@
   - [Connections](/connections.md)
   - [Authentication](/authentication.md)
   - [Seed Data](/seed-data.md)
+  - [Connection Templates](/connection-templates.md)
   - [Logging](/logging.md)
 - Release Notes
   - [Version 3](/version-3.md)
diff --git a/docs/authentication.md b/docs/authentication.md
@@ -16,13 +16,13 @@ Local authentication can be disabled by setting `disableUserpassAuth` to `true`.
 
 ## No Authentication
 
-!> This is under development and available in `latest` or future 4.2 release
+?> Available as of `4.2.0`
 
 SQLPad can be configured to run without any configuration at all. This can be enabled by setting `disableAuth` to `true`.
 
 ## Auth Proxy
 
-!> This is under development and available in `latest` or future 4.2 release
+?> Available as of `4.2.0`
 
 !> When using this feature be sure to restrict access to SQLPad by listening to a restricted IP using `ip`/`SQLPAD_IP` configuration or other method
 
diff --git a/docs/configuration.md b/docs/configuration.md
@@ -11,7 +11,7 @@ node server.js --config ~/sqlpad.ini
 
 For INI and JSON config file examples, see [config-example.ini](https://github.com/rickbergfalk/sqlpad/blob/master/config-example.ini) and [config-example.json](https://github.com/rickbergfalk/sqlpad/blob/master/config-example.json) in GitHub repository.
 
-!> For examples below, **key** refers to key in INI/JSON file. **Env** for environment variable.
+?> For examples below, **key** refers to key in INI/JSON file. **Env** for environment variable.
 
 ## admin
 
@@ -44,13 +44,17 @@ Path to mount sqlpad app following domain. Example, if '/sqlpad' is provided que
 
 ## certPassphrase
 
+!> Deprecated. To be removed in v6. [Use reverse proxy](https://github.com/goldbergyoni/nodebestpractices/blob/master/sections/production/delegatetoproxy.md)
+
 Passphrase for your SSL certification file
 
 - Key: `certPassphrase`
 - Env: `CERT_PASSPHRASE`
 
 ## certPath
 
+!> Deprecated. To be removed in v6. [Use reverse proxy](https://github.com/goldbergyoni/nodebestpractices/blob/master/sections/production/delegatetoproxy.md)
+
 Absolute path to where SSL certificate is stored
 
 - Key: `certPath`
@@ -88,6 +92,8 @@ If enabled, runs embedded database `nedb` in memory. `dbPath` is still required
 
 ## debug
 
+!> Deprecated. To be removed in v5. Set app and/or web log level to `debug` instead.
+
 Add a variety of logging to console while running SQLPad
 
 - Key: `debug`
@@ -146,6 +152,8 @@ IP address to bind to. By default SQLPad will listen from all available addresse
 
 ## keyPath
 
+!> Deprecated. To be removed in v6. [Use reverse proxy](https://github.com/goldbergyoni/nodebestpractices/blob/master/sections/production/delegatetoproxy.md)
+
 Absolute path to where SSL certificate key is stored
 
 - Key: `keyPath`
@@ -291,6 +299,8 @@ Acquire socket from systemd if available
 
 ## tableChartLinksRequireAuth
 
+!> Deprecated. To be removed in v5. Use reverse-proxy and alternative auth mechanism such as auth-proxy to authenticate user passively instead (or open GitHub issue requesting per-query public sharing links feature).
+
 When false, table and chart result links will be operational without login.
 
 - Key: `tableChartLinksRequireAuth`
diff --git a/docs/connections.md b/docs/connections.md
@@ -8,7 +8,7 @@ Admins can create connections in the UI, but connections can also be created in
 
 ## Multi-Statement Transaction Support
 
-!> This feature is under-development, and only available in `latest` or future `4.2+` release
+?> Available as of `4.2.0`
 
 Multi-statement transaction support adds the ability for a user to use the same underlying connection across query executions. This allows things like opening a transaction, running queries, and rolling the transaction back or comitting the transaction across query runs. It also opens up the ability to create and use temp tables that are generally scoped per connection session.
 
diff --git a/docs/seed-data.md b/docs/seed-data.md
@@ -2,7 +2,7 @@
 
 !> **EXPERIMENTAL This feature may continue to change before being finalized. Use at your own risk**
 
-?> Version added: latest (in development)
+?> Available as of `4.2.0`
 
 Data may be seeded to a SQLPad instance via JSON files on the file system. At this time only query and connection data may be seeded.
 
diff --git a/package-lock.json b/package-lock.json
diff --git a/package.json b/package.json
@@ -1,6 +1,6 @@
 {
   "name": "sqlpad-project",
-  "version": "4.1.1",
+  "version": "4.2.0",
   "private": true,
   "devDependencies": {
     "husky": "^4.2.3",
diff --git a/scripts/version.sh b/scripts/version.sh
@@ -35,4 +35,4 @@ git commit -a -m "v$VERSION"
 git tag -a "v$VERSION" -m "v$VERSION"
 
 git push origin master
-git push --tags
+git push origin "v$VERSION"
diff --git a/server/lib/config/config-items.js b/server/lib/config/config-items.js
@@ -151,7 +151,7 @@ const configItems = [
     envVar: 'SQLPAD_TABLE_CHART_LINKS_REQUIRE_AUTH',
     default: true,
     deprecated:
-      'To be removed in v5. Use reverse-proxy and alternative auth mechanism such as auth-proxy to authenticate user passively instead (or request per-query public sharing links be created in GitHub).'
+      'To be removed in v5. Use reverse-proxy and alternative auth mechanism such as auth-proxy to authenticate user passively instead (or open GitHub issue requesting per-query public sharing links feature).'
   },
   {
     key: 'smtpFrom',

Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`{`
`2`	`2`	`"name": "sqlpad-front-end",`
`3`		`- "version": "4.1.1",`
	`3`	`+ "version": "4.2.0",`
`4`	`4`	`"private": true,`
`5`	`5`	`"proxy": "http://localhost:3010",`
`6`	`6`	`"dependencies": {`
Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`{`
`2`	`2`	`"name": "sqlpad-project",`
`3`		`- "version": "4.1.1",`
	`3`	`+ "version": "4.2.0",`
`4`	`4`	`"private": true,`
`5`	`5`	`"devDependencies": {`
`6`	`6`	`"husky": "^4.2.3",`