Skip to content

v0.4.0

Choose a tag to compare

@Peter-L-SVK Peter-L-SVK released this 27 May 12:50
· 285 commits to main since this release
Immutable release. Only release title and notes can be modified.

What's New in v0.4.0

Schema Designer Import

  • Drag tables from database browser onto the designer canvas
  • Columns load automatically from live database
  • Import .sql files with CREATE TABLE and ALTER TABLE FK parsing
  • Visual FK lines with 1:N notation between tables
  • Right-click specific columns to create FK relationships
  • Select and delete tables with automatic relationship cleanup
  • Generate SQL with quoted identifiers and FK constraints

Preferences

  • Editor settings dialog (Edit → Preferences)
  • System font picker for the SQL editor
  • Color scheme selector with all installed GtkSourceView themes
  • Tab width, spaces/tabs, line numbers, highlight line options
  • Settings stored in ~/.config/sql-schema-studio/settings.json
  • Preferences apply immediately to the live editor

Window State Persistence

  • Window size and position saved on close
  • Browser panel width persisted across sessions
  • Settings restored on startup

Fixes

  • FK direction corrected — constraint now added to the referencing table
  • SQL import handles quoted table names from pg_dump exports
  • libadwaita removed from pip requirements (system package only)
  • Debug output replaced with proper logging
  • Code cleanup — unused imports and variables removed

Upgrading from v0.3.0

Delete your old settings file to get the new defaults:

rm ~/.config/sql-schema-studio/settings.json