- ResultsPanel: _RowNumberProxy keeps vertical header numbers sequential
in visual order (sort-stable); both views get a 48 px wide row-number header
- MainWindow: _PingWorker pings each active connection every 30 s via
test_connection(); status dot (green/red) shown in status bar with tooltip
- TableViewer: 📌 toggle freezes first column using dual-view overlay
(_frozen_view child widget) with synced scroll, row heights, and resize
event-filter; column 0 is hidden in the main view while frozen
- RowDialog: OK set as default button; first field focused on open
- ConnectionDialog: OK set as default; Enter in password field submits
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
- ResultsPanel rewritten: single queries show one result as before;
scripts with multiple statements show each result in a named sub-tab
(e.g. "Result 2 (1,234)") with the tab bar auto-shown/hidden
- EditorTab._on_script_done now calls show_script_results() instead of
overwriting the panel on each statement
- ColumnStatsDialog: right-click any column header in TableViewer to see
total rows, null count, distinct values, min, max, and avg (async,
gracefully skips avg for non-numeric columns)
- TableViewer header context menu also adds "Resize to fit" shortcuts
- Ctrl+W closes the current workspace tab (View menu)
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
- PreferencesDialog (Tools → Preferences, Ctrl+,): font family/size,
word wrap, default page size, query timeout, max history, auto-commit;
font changes apply live to all open editors via apply_settings() cascade
- CodeEditor and TableViewer now read initial values from settings singleton
- SQL formatter (≡ Format button): uses sqlparse to reindent and uppercase
keywords; gracefully prompts to install sqlparse if missing
- Table viewer context menu: "Filter by this value" (populates WHERE and
reloads), "Copy row as SQL INSERT" (ready-to-paste INSERT statements),
renamed "Copy row" → "Copy row as TSV" for clarity
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
- ShortcutsDialog: grouped tree of all keyboard shortcuts (Help menu)
- Workspace tab context menu: Rename, Close, Close Others, Close to Right
- SQL query tab context menu: Rename, Duplicate, Close, Close Others
- Smart status bar: right-side connection indicator + selected cell preview
- File → Open SQL File (Ctrl+O), Save (Ctrl+S), Save As, Open Recent
- Recent files persisted to ~/.dbclient/recent_files.json (last 10)
- TableViewer.cell_selected signal wired to status bar cell preview
- EditorTab._filepath tracks the file associated with each query tab
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
SSL was wired through the UI and ConnectionProfile but never actually
applied in any driver or passed from the connection builder.
- main_window: pass ssl/ssl_ca/ssl_cert/ssl_key from profile into
the driver config dict so drivers can act on them
- MySQL: add ssl={ca,cert,key} to pymysql connect kwargs when enabled
- PostgreSQL: set sslmode=verify-ca (with CA) or require, plus
sslrootcert/sslcert/sslkey when provided
- MSSQL: switch Encrypt=yes + TrustServerCertificate=no when SSL is
on; Encrypt=no + TrustServerCertificate=yes otherwise
- SQLite: no change needed (local file, no network layer)
WHERE filter: add tooltip explicitly labelling the input as raw SQL
so users understand arbitrary expressions are executed directly.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
nngoandClaude Sonnet 4.6