Skip to content

v0.5.0

Choose a tag to compare

@Peter-L-SVK Peter-L-SVK released this 28 May 14:33
· 277 commits to main since this release
Immutable release. Only release title and notes can be modified.

What's New in v0.5.0

SQL Import Overhaul

  • Replaced regex-based SQL parsing with proper sqlparse-based parser
  • New SchemaParser class handles CREATE TABLE, ALTER TABLE FK, and inline REFERENCES
  • Handles quoted identifiers correctly (no more broken imports)

Multi-CPU Worker Pool

  • ProcessPoolExecutor infrastructure for parallel CPU processing
  • Bypasses Python GIL — true multi-core analytics ready
  • Global singleton with lazy initialization
  • N-1 cores used to keep the UI responsive

Hook System

  • Hook manager dialog shows all installed Python and Perl hooks
  • Enable/disable toggle per hook
  • Sample hooks included: Auto-Vacuum Advisor, Schema Anomaly Detector (Python)
  • PostgreSQL Log Analyzer (Perl)
  • Plugin registry auto-discovers hooks in src/hooks/python_hooks/ and src/hooks/perl_hooks/

Query History

  • Every executed query saved to local SQLite database
  • Tracks execution time, row count, and success/failure
  • Search and filter through history
  • Load any previous query back to the editor with one click
  • Clear history option

Code Cleanup

  • Removed dead code from preferences dialog
  • Fixed duplicate condition check
  • Cleaned up unused imports across the codebase
  • Version headers bumped to 0.5.0

Upgrading from v0.4.0

Query history uses a new SQLite database. It will be created automatically on first query execution:

ls ~/.config/sql-schema-studio/query_history.db