Skip to content

SQLShelf v1.0.10

Choose a tag to compare

View all tags
@github-actions github-actions released this 15 Sep 17:23
· 55 commits to main since this release
v1.0.10
e68396c

Changelog

[1.0.10] - 2026-09-15

Fixed

  • Table names in the query list — aliases and T-SQL @variables were being indexed and shown where table names belong; UPDATE t SET ... FROM MyTable t listed t, and EXEC @rv = dbo.MyProc listed rv. Across a 192-file library this removed every bogus name
  • Modification date losing its first digit — the date column rendered 4/09/2026 18:56 instead of 14/09/2026 18:56, because the column was measured with the wrong font metrics and then elided
  • Search dying on a quote — typing " built an unterminated FTS5 expression; the error was swallowed and the box returned nothing, so search looked dead until the text was cleared. Quotes are now escaped
  • Search silently losing whole folders — an UPDATE on an indexed row, including a modification-time-only touch from a cloud-sync client, erased table and column names from the full-text row, so table: and col: searches stopped matching. The FTS row is now written by the indexer, which is the only code that has the names

Performance

  • Interface no longer freezes during indexing — reads and writes use separate SQLite connections, so navigating and searching no longer queue behind a reindex. Opening a 59-file folder stalls the interface for 212 ms instead of 713 ms, and searching during a full reindex of 109 files stays under 10 ms
  • Faster text search — dropped the per-row snippet generation that accounted for 87 of the 92 ms a text search took on a 109-file folder, for a string the interface never displayed

Internal

  • Project is now type-checked with mypy and formatted with black, both wired into pyproject.toml, with the development tools recorded in requirements-dev.txt

Tests

  • Regression coverage for alias and variable extraction, special characters in search, and full-text consistency after reindexing — 174 tests

[1.0.9] - 2026-08-12

Changed

  • Default query ordering — query lists now open with the most recently modified files first in every navigation view
  • Large-file rendering — scripts above 1,000 lines remain fully viewable and editable while expensive whole-document syntax and occurrence highlighting are suspended

Fixed

  • Navigation freezes — switching among folders, Favorites, Recent, tags and global navigation no longer blocks the interface on file reads or SQLite index locks
  • Redundant query reloads — refreshing or reordering a result list preserves the selected query without reopening the same file
  • Alias extraction cache — table aliases are now persisted in index schema v4, avoiding repeated sqlglot parsing during navigation
  • Stale query display — the previous SQL body is cleared while a newly selected file loads asynchronously, preventing actions from targeting old content

Tests

  • Added UI regression coverage for large files, selection preservation, cross-folder result identity and default modification-date ordering

[1.0.8] - 2026-08-03

Added

  • Access log & Reports dialog — SQLShelf now records when a query is opened, copied, or opened in SSMS; Help → Reports shows the most-accessed queries and tags across all loaded folders
  • Modification date column — the query list now shows each file's last-modified date/time (dd/mm/aaaa HH:MM) alongside the table name

Fixed

  • Large .sql file performance — opening, editing and navigating large SQL files (1000+ lines) no longer freezes the UI: object extraction (sqlglot) now runs off the UI thread with debouncing and caching, occurrence highlighting is capped and debounced, and the syntax highlighter's keyword patterns were merged into a single regex for faster re-scans

[1.0.7] - 2026-06-23

Added

  • System tray — closing the main window now minimizes SQLShelf to the Windows system tray; double-click the tray icon or Restore to bring it back
  • Windows autostart — new toggle in Preferences (Edit → Preferences) to launch SQLShelf automatically on Windows login via the registry
  • Quit action — File → Quit exits the application immediately without minimizing to the tray
  • Status bar result count — the status bar shows how many queries match the current search in real time
  • Statistics dialog — Help → Statistics shows a summary of the open project: total queries, tags, tables, columns and index size
  • Version in About dialog — Help → About now displays the current application version

Changed

  • Preferences moved to Edit menu — Preferences action relocated to Edit → Preferences for better discoverability
  • Open in SSMS removed — View → Open in SSMS action removed; use the clickable file path chip in the metadata panel to open a file externally

Fixed

  • Tray exit — QApplication.quit() is now called on the tray Quit action, ensuring the event loop exits cleanly when the main window is hidden

Docs

  • Added comprehensive database schema reference (docs/database-schema.md) covering every table, column, trigger, index and search operator

[1.0.6] - 2026-06-22

Added

  • Force reindex progress modal — clicking Forçar Indexação now runs the scan in a background thread and shows a progress dialog with a progress bar, instead of blocking the UI silently

[1.0.5] - 2026-06-22

Added

  • Alias chips — table aliases extracted from the SQL body (e.g. FROM Orders AS o → chip o) are displayed as a dedicated ALIASES section in the metadata panel; clicking navigates to the first occurrence in the editor
  • Select All / Copy buttons — two buttons added to the editor toolbar in view mode: Select All selects the full SQL body; Copy copies it to the clipboard without selecting

Fixed

  • Ctrl+N shortcut — removed a duplicate QShortcut("Ctrl+N") that caused the Ambiguous shortcut overload: Ctrl+N warning in the terminal; the shortcut on the menu action is sufficient

Changed

  • Occurrence highlighting — placing the cursor on a word (or selecting text) highlights all other occurrences in the SQL editor with a distinct background + foreground color, preserving readability over syntax-highlighted tokens
  • Metadata chip navigation — left-clicking a table, column or alias chip now jumps to the first occurrence of that token in the current SQL editor (whole-word, case-insensitive); right-click shows a context menu with Go to occurrence, Search in all queries and Copy name
  • File path chip — right-click now shows a context menu: Copy absolute path, Copy folder path, Reveal in Explorer

[1.0.4] - 2026-06-16

Added

  • Check for Updates — new menu item under Help; queries the GitHub Releases API in a background thread and shows a dialog with the result; if a newer version is found, offers a direct "Download Update" button (downloads and launches the Windows installer) or "Open Release Page" (browser); a silent check also runs 5 s after startup and displays a status-bar notification if an update is available
  • Sort button (⇅) in query list — dropdown with four options: Name A→Z, Name Z→A, Modified newest, Modified oldest; active option shows a checkmark; sort persists across searches; translated in English, Portuguese (PT-BR) and Spanish
  • Portable distribution — Windows and Linux releases now include a portable .zip alongside the installer/AppImage; extract and run with no installation required

Fixed

  • Query list panel minimum width — a second setMinimumWidth(200) call was silently overriding the 360 px set earlier, causing the panel to shrink on smaller screens; both calls are now 360 px
  • Query list panel resizing — panel now uses setMinimumWidth instead of setFixedWidth so it never shrinks below 360 px but can still grow when the splitter is dragged or the window is maximized

Changed

  • Tables/columns chip sections — wrapped in a scroll area (max 52 px height) so queries with many tables or columns no longer push the SQL editor off screen
  • Search bar — removed the help (?) button; search operator tooltip moved to the search field itself, visible on hover
  • Quick Search rename — "Command Palette" renamed to "Quick Search" across all locales (EN, PT-BR, ES) to better reflect its purpose; hint and placeholder text now fully localized

[1.0.3] - 2026-06-15

Added

  • Tag autocomplete — typing in the tag field (query editor and New Query dialog) now suggests existing tags from the index
  • Sort by modification date — query list is sorted by file modification time (newest first) by default across all views (All queries, folder, search results)
  • Modification date in metadata panel — file's last modification date is shown as a dedicated section below the file path
  • date: search filter — search bar and command palette (Ctrl+P) now support date:DD/MM/YYYY to filter queries modified on a specific day; can be combined with other operators (e.g. date:15/06/2026 tag:report)

[1.0.2] - 2025-06-14

Fixed

  • About dialog links now display in the app's accent green color (#0ADE99)

[1.0.1] - 2025-06-14

Fixed

  • UI labels showing translation keys (e.g. SIDEBAR.OPEN_FOLDER) instead of text — locales/ directory was missing from the PyInstaller bundle

[1.0.0] - 2025-06-14

First public release of SQLShelf — open-source desktop SQL query manager built with Python + PySide6.

Features

Core

  • Open and index any folder of .sql files with automatic frontmatter YAML detection
  • Multi-folder explorer with persistent project selection and global "All queries" view
  • Full-text search (FTS5) with table:, col:, and tag: prefix filters
  • Debounced async search with green search bar styling
  • File watcher (watchdog) with ~500ms debounce — index stays in sync without manual refresh
  • SQLite index is fully regeneratable; .sql files on disk are the source of truth

Editor

  • SQL syntax highlighting via QSyntaxHighlighter
  • Line numbers and current-line highlight
  • Metadata panel with read/edit mode (title, description, tags, favorite, author)
  • Tag chips with inline editor
  • Clickable absolute file path in metadata panel
  • Copy frontmatter template to clipboard (Edit menu)

UI

  • Light and dark themes via Settings → Theme (live switching)
  • Language toggle EN/PT-BR via Settings → Language (i18n system)
  • Two-line query list delegate with title, description and tag summary
  • Sidebar with priority nav (Favorites, Recent) and collapsible Browse section
  • Command palette button in toolbar
  • Logo swaps on theme toggle

Indexing

  • Progress dialog during initial indexing
  • Deindex (remove stale entries) on project close
  • Startup status feedback

Platform

Platform Artifact
Windows 10/11 x64 SQLShelf-1.0.1-windows-x64-setup.exe (Inno Setup installer)
Linux x86_64 SQLShelf-1.0.1-linux-x86_64.AppImage

Requirements (if running from source)

  • Python 3.12+
  • pip install -r requirements.txt
  • python main.py
Assets 6
Loading