FlameRobin Files

FlameRobin 26.8.4 Release Notes

FlameRobin v26.8.4 brings asynchronous multi-threaded data fetching for large result sets, strictly on-demand scrolling, interactive routine execution fixes, database properties diagnostics and stability enhancements, and data grid state synchronization.

Highlights & Key Improvements

1. Decoupled Asynchronous Background Fetching & Strict On-Demand Scrolling (#679, [#125])

• Decoupled Worker Thread: Offloaded large result set retrieval and full data caching from the main UI thread to a dedicated background worker thread (std::thread).
• Responsive Non-Blocking UI: Batches of 500 records are streamed safely to the UI thread (wxEVT_FRDG_BATCH_READY), keeping the main application window, menus, tabs, and all other SQL editors completely responsive without freezing or lagging.
• Strict On-Demand Fetching (Default): Fixed the preference toggle ("Automatically fetch all records in result set") so that when disabled (default), FlameRobin retrieves the initial 100 rows and strictly stops, fetching subsequent chunks only on demand when scrolling near the end of loaded records.
• Instant Cancellation: Supports instant cancellation (cancelFetchAll()) without application lag.

2. Data Grid View Refresh on Executing Selection (#687)

• State Reset & Selection Clear: Reset sort column indices (sortedColM), sorting order, filter text, column labels (originalColLabelsM), and row mappings (rowMappingM) in DataGridTable::Clear().
• View Synchronization: Automatically cleared old selection blocks, reset grid cursor to (0, 0), and triggered explicit scrollbar adjustments (AdjustScrollbars()) and viewport force-refreshes (ForceRefresh()) upon executing selected SQL statements and switching between view modes.
• Filter Bar Reset: Synchronized the real-time search filter input and record count label on query execution.

3. Database Properties Modification & Diagnostics Display Fix (#686)

• Missing Property Info Tags: Added Firebird database info tags in FbCppDatabase::getInfo() (isc_info_forced_writes, isc_info_no_reserve, isc_info_sweep_interval, isc_info_set_page_buffers, isc_info_num_buffers) to accurately read and display database properties.
• Synchronous Service Property Execution: Converted service property modifications in FbCppService to run synchronously before reloading properties and reconnecting.
• Exception Safety & Reconnection: Added comprehensive exception handling and safe database reconnect routines in DatabaseInfoHandler to prevent application termination on service errors.

4. Data Grid NULL Cell Double-Click & Column Sorting Fix (#685)

• Prevent Spurious DML: DataGridRows::setFieldValue() recognizes literal [null] values and skips execution if cell values remain unchanged.
• Clean In-Place Editor Dismissal: Safely disables active in-place cell editors before re-indexing rows on column header click.
• Robust NULL Sorting: Sorts NULL values last in ascending mode and first in descending mode without numeric conversion errors.

5. Interactive Routine Executor Window Close Fix (#680)

• Command ID Collision Fix: Fixed a command ID collision between ID_button_execute_routine (5001) and wxID_CLOSE that caused the interactive routine execution dialog to close immediately when clicking "Execute Routine".

Full Commit Log since v26.8.3

• eed653fa Release v26.8.4: Update version to 26.8.4 and add release notes
• d16298a2 Fix [#679]: Decouple full fetch to background worker thread and strictly enforce on-demand scrolling
• 086cbb1d Fix [#687]: Ensure DataGrid and viewports refresh cleanly when executing selected statements
• c57175be Fix [#686]: Fix database properties change crash, add missing info tags, and execute properties synchronously
• e91dddb9 Fix [#685]: Prevent fatal error and spurious DML when sorting after double-clicking NULL cell in data grid
• 4a1cf503 Fix [#680]: Resolve command ID collision between Execute Routine button and wxID_CLOSE