Repository navigation
v0.9.1
What's New in v0.9.1 hotfix
Worker Pool Stability (Critical Fix)
Synthetic data generator worker crashes no longer poison the entire process pool.
Previously, unhandled exceptions in _generate_chunk (connection failures, faker
import errors, bad presets) would kill the spawned worker, making
ProcessPoolExecutor refuse all further work with "A child process terminated
abruptly, the process pool is not usable anymore."
- Wrapped
_generate_chunkbody in try/except — returns 0 on error instead of
crashing the worker - Added
_reset_pool()to worker_pool.py to recreate a broken pool - Multi-CPU path now catches
BrokenProcessPooland retries once with a fresh pool
Packaging Overhaul
RPM and DEB packages are now more robust and user-friendly:
Single Source of Truth — All Python dependencies are managed exclusively
through pyproject.toml. No more duplicate requirements in packaging scripts
or generated requirements.txt files.
Smart Dependency Installer — New sql-schema-studio-install-deps helper
script guides users through installing Python dependencies with their preferred
method:
pipx(recommended — isolated environment)pip --user(user-only installation)- System-wide with appropriate flags (Ubuntu 24.04+ PEP 668 support)
Auto-Detection — Launcher now checks for missing packages and provides clear
installation instructions instead of failing with cryptic import errors.
Package→Import Mapping — Properly handles packages with different import names
(PyGObject → gi, pycairo → cairo, scikit-learn → sklearn).
Robust File Installation — Icon and desktop file installation with fallback
SVG placeholders. Fixed ModuleNotFoundError by properly setting PYTHONPATH.
Documentation
README updated with simplified installation workflow:
- Unified pattern for both RPM and DEB packages
sql-schema-studio-install-depsintegrated into post-install workflow- Removed scattered pip install commands
- Updated troubleshooting section for new workflow
Upgrading from v0.9.0
-
Remove old version:
# RPM sudo dnf reinstall ./sql-schema-studio-0.9* # DEB sudo dpkg -r sql-schema-studio
-
Install v0.9.1 using the instructions in README
-
Install Python dependencies:
sql-schema-studio-install-deps
-
Launch:
sql-schema-studio
No database migration needed.
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
- docs(roadmap, readme): correction of files to reflect current state of app by @Peter-L-SVK in #31
- hotfix(hooks): prevent worker crashes from poisoning the process pool by @Peter-L-SVK in #32
Full Changelog: v0.9.0i...v0.9.1