query-commander

This is an important security update for AWS Lambda users. Please upgrade to v0.9.1 or later.

[0.9.3] - 2024-09-12

• Bug fix in message box overlay not setting scroll window properly.
• Bug fix in logging to remove unnecessary debug code
• Bug fix in meta tag for mobile web app definition
• Security hardening for login debug code to log only reason for failure and return generic response to caller

This version has been extensively tested and is considered to be stable with the following configurations:

• Local and Lambda Installations
• OpenLDAP Authenticator
• Local and DynamodB Session Manager
• Local and SecretsManager Connection Manager
• Local and S3 Profile Managers
• PostgreSQL and MySQL database connectors

Read the Documentation

This is an important security update for AWS Lambda users. Please upgrade to v0.9.1 or later.

[0.9.2] - 2024-09-03

• Bug fix in database picker process not allowing database to be changed
• Bug fix in recordset processing for queries not returning records (insert/update/delete/create)
• Bug fix in properly displaying results for queries with or without results.

Read the Documentation

This is an important security update for AWS Lambda users. Please upgrade to v0.9.1 or later.

[0.9.1] - 2024-09-02

• (Security) Bug fix with Lambda caching results across browser sessions
• Added connector option for limiting which databases (or schemas) to display in metadata sidebar

Read the Documentation

This release adds significant improvements to connection handling and tab management.

[0.9.0] - 2024-09-01

Breaking Changes

• New default feature requires meta additions for database-list and schema-list
• New default feature requires previously saved tab connection updates
• Updated CodeMirror enable/disable option to be consistent with other settings

Other Updates

• Added ability to update tab connection details
• Added default schema for execution context to improve user experience
• Bug fix related to codemirror in saving profiles
• Bug fix in session update for extension
• Bug fix in Redshift connector for displaying returned records
• Bug fix in Redshift connector documentation
• Improved handling of semicolons for oracle connector
• Aligned Redshift object tree with PostgreSQL where possible
• Aligned Oracle object tree with logical segments from other DBs
• Smoothed out page handling of various login/logout/refresh calls
• Added better visual notification of on screen actions

This release adds syntax highlighting along with several bug fixes.

[0.8.0] - 2024-08-29

• Added CodeMirror support (use settings/disable_codemirror = true to disable)
• Bug fix in session cookie management for unexpected timeout on Lambda calls
• Bug fix to include integrity checks for all CDN libraries
• Bug fix for sessions, locks, and detail pages

Read the Documentation

This release adds branding options and a major bug fix for Postgres and Redshift.

[0.7.2] - 2024-08-27

• Bug fix in explain plans for postgres failing to display
• Button adjustments to provide more natural feedback
• Added overrides for images/logos for branding customizations
• Documentation cleanup (Network diagram)

Read the Documentation

This release adds websocket connections for longer running queries when running through AWS Lambda.

[0.7.1] - 2024-08-25

• Enabled environment variable overrides for most common settings
• Documentation updates

Read the Documentation

This release adds websocket connections for longer running queries when running through AWS Lambda.

[0.7.0] - 2024-08-24

• Added websockets for long running queries through AWS Lambda
• Added autoconfigure websocket API URL
• Documentation updates and corrections

Read the Documentation

This release optimizes the profile changes, adjusts HTTP headers, and optimizes dynamodb interactions.

[0.6.2] - 2024-08-22

• Bug fix for new script button not firing
• Optimized profile pull to reduce round-trips
• Added configuration option for disabling profiles
• Adjusted HTTP headers for cache breaking
• Documentation cleanup and updates
• Improved logging messages

Read the Documentation

This release swaps out psycopg with pg8000 for better lambda support.

[0.6.1] - 2024-08-20

• Added AWS Lambda Layer zip inclusion
• Bug fix for lambda cookies not being set properly
• Bug fix for session update after logout
• Bug fix for PostgreSQL Sequence DDL export
• Bug fix for weirdness in Lambda holding connection names that don't exist
• Bug fix for MySQL "no database selected" error
• Cleaned HTML code for client-side filters
• Added traps in connectors for non-fatal errors to avoid unforced errors
• Added "New SQL Script..." link to context menu for databases
• Updated cache breakers for all API calls
• Improved handling of keyboard shortcuts

Read the Documentation

This release swaps out psycopg with pg8000 for better lambda support.

[0.6.0] - 2024-08-19

• Dropped support for psycopg(2/3) due to static linking limitation
• Added support for pg8000 and updated docs
• Updated logging for better error trapping in lambda
• Added cache breakers to ajax calls

Read the Documentation

This release focuses on Lambda updates and AWS documentation.

[0.5.4] - 2024-08-18

• Added tab selector for reordering multiple tabs
• Updated tab names to allow for connections to be different than tab name
• Added simple client-side record filtering

Read the Documentation

This release focuses on Lambda updates and AWS documentation.

[0.5.3] - 2024-08-17

• Added S3 Profile storage option
• Added "lambda" install subdivision for pip installer
• Updated installation docs for AWS API Gateway/Lambda install
• Logging cleanup

Read the Documentation

This release launches the PyPi package for easier installations and allows for configurable CDNs (in case you want to host everything locally rather than using a public CDN).

[0.5.2] - 2024-08-16

• Bug fix in module inheritance from pypi package
• Redesigned page start using start.as_cgi() or start.as_lambda(event, context)
• Added log_level setting
• Centralized version number management
• Improved log divisions

Read the Documentation

This release launches the PyPi package for easier installations and allows for configurable CDNs (in case you want to host everything locally rather than using a public CDN).

[0.5.1] - 2024-08-15

• PyPi module launch
• CDN configuration options for overriding default sources
• Additional general documentation cleanup/updates for 5.x version
• Simplified installation process

Read the Documentation

This release takes a big step to reformatting the repository in prep for converting to a pypi module to simplify installation.

[0.5.0] - 2024-08-14

• Major change for configuration (working toward python module install)
• Reworked Apache documentation, testing Lambda configuration

Read the Documentation

This release includes the initial lambda handler and reorganizes the rest of the code to enable its use along with minor UI additions.

[0.4.3] - 2024-08-13

• Added active sessions view to sidebar context
• Added active locks view to sidebar context
• Updated output process for AWS Lambda compatibility
• Initial lambda_function.lambda_handler

Read the Documentation

This release primarily contains token and rate limit updates primarily for performance and responsiveness.

[0.4.2] - 2024-08-12

• Migrated Token storage to allow one active login per user
• Migrated rate limits to token from profile
• Added visual confirmation on save
• Bug Fixes:
  • Auto-load results on scroll failing to load next segment

Read the Documentation

Bug fix release.

[0.4.1] - 2024-08-11

• Added feature for records over time limits
• Updated token format for storage
• Bug Fixes:
  • Session time extension not being properly updated on validation
  • API: save-profile trapped errors now return valid error response

Read the Documentation

Bug fix release.

[0.4.0] - 2024-08-10

• Local User Profile Manager
• DynamoDB User Profile Manager
• Bug fixes in role handling
• Changed connections type option from local to config to avoid confusion
• Split out connections processing into separate connections module
• Added valid connections to token processing (now possible with recent role changes) for streamlined operations
• Connections: SecretsManager
  • Optimization to streamline calls to get secrets
  • Added filtering mechanism for AWS-supported filtering criteria
  • Switched to use secret name for connection name

Read the Documentation