Skip to content

v0.6.0

Choose a tag to compare

@Peter-L-SVK Peter-L-SVK released this 31 May 19:15
· 265 commits to main since this release
Immutable release. Only release title and notes can be modified.

What's New in v0.6.0

AI Index Advisor

  • Analyzes database tables and recommends missing indexes
  • Checks foreign key columns, date columns, and categorical columns
  • Three priority levels: HIGH (foreign keys), MEDIUM (date/*_id), LOW (status/type)
  • Generates CREATE INDEX statements ready for review and execution
  • Accessible from Tools > AI Index Advisor

Hook System Execution

  • Hooks can now be executed directly from the Hook Manager
  • "Run Selected" button executes Python and Perl plugins
  • Results displayed immediately in a dialog
  • Proper error handling with descriptive messages
  • Sample hooks included: Auto-Vacuum Advisor, Schema Anomaly Detector, Log Analyzer

Query History Categorization

  • Each query automatically categorized by type
  • Categories: SELECT, INSERT, UPDATE, DELETE, DDL, OTHER
  • New Type column in Query History dialog
  • Filter and search through categorized history

UI Improvements

  • Delete key removes selected table in Schema Designer
  • Press Enter in password field to connect
  • Application icon in window title bar and about dialog
  • SQLite Consortium and KDE Plasma Team added to credits
  • pycairo dependency added for Kubuntu compatibility

Documentation

  • Updated screenshots for all major features
  • Simplified architecture section in README
  • Planned features roadmap updated

Upgrading from v0.5.0

Query history database will be automatically upgraded with the new category column. No manual migration needed.