Change Log

All notable changes to this project will be documented in this file.

[1.0.1] - 2024-12-14

• Bug fix in trino connector for viewing Hive table details
• Refactored connectors to optimize code management
• Code/comments cleanup

[1.0.0] - 2024-11-16

• MAJOR RELEASE
• Bug fix in UI for websocket pagination
• See roadmap for future plans.

[0.9.7] - 2024-10-03 -- v1.0-pre

• Bug fix in UI drag-n-drop
• Improvements in page text user-selection

[0.9.6] - 2024-09-26

• Updated Trino connector to print more descriptive error messages
• Updated documentation on installation options

[0.9.5] - 2024-09-19

• Bug fix in viewing sessions and locks in MySQL 8.0+ vs MariaDB 10.11+ (requires performance_schema variable)
• Bug fix in viewing sessions and locks in Oracle when missing default schema (Note: Sessions and Locks in oracle require permission to v$ tables)

[0.9.4] - 2024-09-18

• Bug fix in autocommit for PostgreSQL and Redshift connectors
• Bug fix in viewing sessions and locks due to "Invalid Schema" error for PostgreSQL and Redshift connectors
• Added initial support for Trino/PrestoSQL and updated documentation

[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

[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.

[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

[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

[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

[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)

[0.7.1] - 2024-08-25

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

[0.7.0] - 2024-08-24

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

[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

[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

[0.6.0] - 2024-08-19

• BREAKING: Library change for PostgreSQL connections

  • Dropped support for psycopg(2/3) due to static linking limitation in lambda
  • Added support for pg8000 and updated docs

• Updated logging for better error trapping in lambda

• Added cache breakers to ajax calls

NOTICE: Future releases will call out breaking changes like the library change here explicitly.

[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

[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

[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

[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

[0.5.0] - 2024-08-14

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

[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

[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

[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

[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

[0.3.1] - 2024-08-08

• Bug fix for multiple roles
• Removed role chooser

[0.3.0] - 2024-08-06

MILESTONE: All core databases that will be part of v1.0 are now supported!

• AWS Redshift Database Support (and related docs)
• Updated docs for successful Oracle connection

[0.2.1] - 2024-08-05

• Bug fix for Oracle Partitions and Subpartitions

[0.2.0] - 2024-08-04

• Oracle Database Support (and related docs)
• New environment variable to move settings.yml to user-specified folder

[0.1.0] - 2024-08-03

• AWS Secrets Manager Integration for Connections Management
• Updated global settings to support AWS authentication options
• Bug fix for MySQL connector on DML statements not taking to output screen
• Bug fix for MySQL explain plan generation/viewing
• Updated versioning pattern
  [Milestone ~ Major Features ~ Bug fixes/Minor Changes/Routine Builds]

[0.0.3] - 2024-08-02

• Active Directory Authentication via LDAP/LDAPS
• Redis Session Token Storage (and related docs)
• MySQL/MariaDB Database Support (and related docs)

[0.0.2] - 2024-08-01

• DynamoDB Session Token Storage (and related docs)

[0.0.1] - 2024-07-31

• All prior code from all forms for all historic years of experimentation coalesced into single branch
• Includes basic operators rewritten in Python (from C# and PHP)
• Lays out all basic code structure, connector interfaces, and UI/UX
• Added a direct export for result exports through browser (no round-trip required)
• Authentication Types: local, openldap
• Session Management Options: local
• Databases Supported: postgresql