Skip to content

v0.9.0

Choose a tag to compare

@Peter-L-SVK Peter-L-SVK released this 30 Jun 20:41
· 75 commits to main since this release
69f959f

What's New in v0.9.0

Multi-Tab SQL Editor

The single editor has been replaced with a full multi-tab editing experience:

  • Tab management: Ctrl+T opens a new tab, Ctrl+W closes the current tab. Tabs can
    be reordered by dragging within the notebook.
  • Unsaved changes: modified tabs show a bullet indicator (•) and trigger a
    confirmation dialog on window close or File > Quit.
  • Session restore: open tabs and their content are restored on next startup so your
    workspace survives application restarts.
  • SQL autocomplete: a custom popover-based autocompleter suggests keywords, table
    names, and column names as you type. Can be toggled on/off in Preferences.
  • Find and Replace: Ctrl+F reveals the search bar with case-sensitive toggle (Aa),
    whole-word toggle (ab|), previous/next navigation (Shift+F3 / F3), single replace,
    and Replace All. All search operations now respect both toggles consistently.

Schema Designer Pro

The visual schema designer received a major upgrade with professional drawing capabilities:

Drawing Engine

  • Parallel path routing: FK relationship lines are computed asynchronously across
    multiple CPU cores using the worker pool's ProcessPoolExecutor. Python's GIL is
    bypassed so the UI remains fully responsive during routing. Results stream back via
    GLib.idle_add for smooth canvas updates.
  • Line jumps + waypoints: lines intelligently route around other relationships with
    clean arc jumps where lines cross. Waypoints for each FK pair are computed concurrently.
  • Bidirectional arrows: directional arrows show relationship flow. Click any
    relationship line to toggle its direction — cardinality labels swap automatically
    (1 at source, N at target).
  • Zoom and Pan: scroll to zoom, drag to pan, with theme-aware background grid.

Interaction & Editing

  • Undo/Redo: full action stack covering table moves, FK creation/deletion, color
    changes, and column edits. Standard Ctrl+Z / Ctrl+Shift+Z shortcuts.
  • Popover color picker: right-click any table header to choose from preset color
    schemes or pick a custom color. Active table has a distinct highlight border.
  • Column editor dialog: add, remove, and modify columns directly from the canvas.

Analytics Engine & AI Tools

A new Polars-based analytics subsystem powers both AI-assisted analysis and interactive
data exploration:

  • 9 AI analyzers: schema quality scoring, index recommendation, query plan analysis,
    table growth prediction, dead tuple monitoring, and more — all running on Polars
    DataFrames for performance.

  • Right-click analytics menu: right-click any table or view in the database browser
    to run statistical analysis:

    Function Description
    Percentile Bands p10, p25, p50, p75, p90, IQR distribution summary
    Trend Forecast Linear regression with slope, R-squared, next 5 values
    Anomaly Detection IQR-based outlier detection (1.5x rule)
    Moving Average 7-period rolling mean, last 10 values
    Exponential Smoothing ETS with span=12, last 10 values
    Correlation Matrix Pearson correlation across all numeric columns

    Smart column detection automatically skips surrogate keys (id, serial, *_id) and
    prefers NUMERIC/REAL types over INTEGER. NULL values are handled gracefully across
    all functions.

SSH Tunnel

Full SSH tunnel implementation replaces the v0.8 stub. Connect to remote PostgreSQL
servers through SSH with password or key-based authentication. A single tunnel
connection is reused across queries to minimize overhead.

Built-in Terminal

A VTE-based terminal is embedded in the application with customizable colors and
fonts. Correct spawn arguments support bash, zsh, and fish shells out of the box.
The vte291-gtk4 package is now a required dependency.

New Hooks

  • Synthetic Data Generator: generates configurable test datasets with multiple
    presets (e-commerce, users, logs). Multi-CPU support for generating
    millions of rows across worker processes.
  • Keboola Normalizer: cloud integration hook that normalizes schemas for the
    Keboola data platform, handling column naming conventions and type mapping.

Code Quality & CI/CD

  • Black formatting applied project-wide for consistent code style.
  • mypy and flake8 checks passing with project configuration in pyproject.toml.
  • CI/CD pipeline with GitHub Actions: PR checks, RPM build (Fedora/RHEL),
    and DEB build (Debian/Ubuntu).

Refactoring

The codebase has been reorganized into modular packages for maintainability:

  • results.py split into src/ui/results/ with a separate themes module for
    Unicode box-drawing table formatting.
  • window.py split into src/ui/window/ with mixins for browser panel, status
    bar, and menu-building concerns.
  • Editor tabs extracted to src/ui/editor/ with separate editor_tabs.py
    container and editor_tab.py individual tab classes.
  • Schema designer extracted to src/ui/schema_designer/ with decomposed mixins
    for FK drawing, path routing, undo/redo, and interaction.

Preferences

  • confirm_close preference now wired to actual close behavior — disable to skip
    the unsaved changes dialog.
  • Autocomplete toggle added to the Preferences dialog under the Editor section.

Bug Fixes

Find and Replace

  • Whole-word toggle now respected during navigation: when whole-word matching
    was enabled, the navigation pass (F3 / Shift+F3) used GTK's built-in search
    which only filtered by case sensitivity, ignoring word boundaries entirely.
    The cursor would jump to partial matches (e.g. "ordering" when searching
    "order") while only the substring was highlighted, creating visual inconsistency.
    Navigation is now backed by the same \b<word>\b regex used for highlighting.
  • Whole-word toggle now respected during Replace All: the replacement pass
    previously substituted partial matches regardless of the toggle. It now wraps
    the pattern with \b boundaries when whole-word is active.
  • Debounce timer warnings eliminated: "Source ID was not found when attempting
    to remove it" warnings no longer appear in terminal output. The debounce ID is
    now consumed inside the timeout callback and cleared after cancellation,
    preventing attempts to remove already-fired GLib source IDs.

Database Browser

  • GTK4 popover lifecycle: eliminated "Broken accounting of active state"
    warnings and phantom input grabs by claiming event sequences via
    Gtk.EventSequenceState.CLAIMED after popup().
  • Popover dismissal: added set_autohide(True) so clicking outside the
    context menu dismisses it cleanly, and removed unparent() calls that
    corrupted GTK4's internal widget tree during teardown.
  • Lambda late-binding: replaced nested-lambda closure chain with plain
    Python button attributes to prevent wrong func_id dispatch across the
    GLib.idle_add C extension boundary.
  • psycopg2 parameter parser crash: double-escaped percent signs in
    NOT LIKE '%%\_id' so the LIKE pattern reaches PostgreSQL correctly instead
    of being misinterpreted as a parameter placeholder.
  • Gesture scoping: left-click gesture now bound to button 1 only and
    right-click gesture bound to button 3. Previously the left-click gesture
    was incorrectly firing on right-clicks as well.
  • Defensive cursor handling: guard against zero-width or None cursor rows
    before indexing, preventing IndexError on malformed query results.

Schema Designer

  • Memory leak fixed: worker pool processes are properly cleaned up after
    each routing batch instead of accumulating across redraws.
  • Crash fixes: reopening the designer after a file drop, working with
    empty canvases, and FK selection when tables overlap all no longer crash.
  • Arrowhead angles corrected for curve and orthogonal line styles so
    arrowheads always point in the visually correct direction.
  • Cardinality labels correctly placed with 1 at the FK source and N at
    the target, matching FK semantics.

Data Safety

  • Autocommit: db_connector.execute_sync now sets conn.autocommit = True
    to prevent implicit transaction blocks from holding locks.

Upgrading from v0.8.0

No database migration needed. The vte291-gtk4 and paramiko packages are new
dependencies. Settings and hook results in ~/.config/sql-schema-studio/ are
forward-compatible.

What's Changed

  • feat(schema): add visual schema designer with relationship editor by @Peter-L-SVK in #5
  • v0.4.0 — Schema Designer Import, Preferences & Persistence by @Peter-L-SVK in #6
  • v0.5.0 — Cleanup, Multi-CPU Worker Pool, Hook System & Query History by @Peter-L-SVK in #8
  • v0.6.0 — AI Index Advisor, Hook Execution & Query Categorization by @Peter-L-SVK in #10
  • docs: add WSL2 installation instructions for Windows by @Peter-L-SVK in #11
  • v0.7.0 — Data Import/Export, Schema Designer Enhancements & File Operations by @Peter-L-SVK in #13
  • Feat/v0.8.0 by @Peter-L-SVK in #14
  • v0.8.0 — Hooks, Optimization & AI/ML Foundation by @Peter-L-SVK in #15
  • docs: add screenshots up to date by @Peter-L-SVK in #16
  • docs: roadmap: v1.0.0 feats adition by @Peter-L-SVK in #17
  • feat: SQL Schema Studio v0.9.0 - Multi-tab Editor, Hooks, Schema Designer Pro by @Peter-L-SVK in #18
  • Revert "feat: SQL Schema Studio v0.9.0 - Multi-tab Editor, Hooks, Schema Designer Pro" by @Peter-L-SVK in #19
  • feat: SQL Schema Studio v0.9.0 - Multi-tab Editor, Hooks, Schema Designer Pro by @Peter-L-SVK in #21
  • Feat: SQL Schema Studio v0.9.0 - Multi-tab Editor, Hooks, Schema Designer Pro by @Peter-L-SVK in #22
  • feat: v0.9.0 — Multi-tab editor, schema designer pro, analytics engine, and SSH tunnel by @Peter-L-SVK in #23
  • fix(ci): add contents:write permission to RPM and DEB release workflows by @Peter-L-SVK in #25
  • fix(ci): install pyproject.toml runtime dependencies before packaging by @Peter-L-SVK in #27
  • fix(ci): clean up dependencies by @Peter-L-SVK in #29
  • fix(packaging): resolve RPM installation and module import issues by @Peter-L-SVK in #30

Full Changelog: v0.8.0...v0.9.0i