FlameRobin Files

FlameRobin 26.10.0 introduces the Performance Benchmark & Diagnosis tool for measuring and diagnosing Firebird database performance bottlenecks, fixes connectivity with legacy Firebird 1.5 and 2.0 databases, and includes important security, UI contrast, and compatibility enhancements.

Highlights

1. Performance Benchmark & Diagnosis Engine (#641, [#734], [#737], [#738], [#740])

• Comprehensive Performance Measurement: Added a built-in diagnostic and benchmarking suite (Database -> Performance Benchmark & Diagnosis) designed to evaluate Firebird performance and pinpoint why a server or configuration might be performing slower than expected. • Extensive Test Matrix:

• CPU & Computation: In-engine PSQL execution under single and parallel workloads.
• Disk & Cache: Commit latency, bulk inserts, 50-page minimal cache reads/writes (simulating memory-constrained scenarios), memory-cached reads, and sort performance with temporary disk files.
• Network & Latency: Round-trip latency, data transfer throughput, single-row insert latency, name resolution, and remote auxiliary port event delivery.
• Concurrency & Workload: Multi-user concurrent simulation ranging from 1 to 32 connections (optionally scalable up to 250 users). • Non-Invasive Diagnostic Inspection: Inspects host environmental metrics across Windows, Linux, and macOS (SMBIOS, CPU cache sizes, memory modules, disk health, active power profiles, background antivirus scanning, listening ports, firewall rules, and network hop topology). • Comparative Reports & Privacy Sanitization:
• Generates interactive, styled HTML reports and compact Markdown summaries.
• Differential comparison compares current benchmarks against historical runs or external reports, scoring parts out of 1000 and detailing concrete configuration or hardware differences.
• Built-in anonymization / privacy filter strips out sensitive hostnames, IP addresses, and user credentials for public sharing. • Enhanced UX & Fallback:
• Available from database, server, and root context menus, as well as the main Database menu even when no database is currently connected.
• Features an "Open in browser" option, proper authentication prompt handling when registrations lack saved credentials, and clean MSHTML/Internet Explorer fallback compatibility.

2. Firebird 1.5 & 2.0 Database Connection Compatibility (#732)

• Fixed an issue where connecting to legacy Firebird 1.5 (ODS 10.1) and Firebird 2.0 (ODS 11.0) databases failed with Dynamic SQL Error SQL error code = -206 Column unknown RDB$RELATION_TYPE. • Guarded RDB$RELATION_TYPE queries to only run on ODS >= 11.1 (introduced alongside Global Temporary Tables in Firebird 2.1), restoring smooth connectivity to older databases.

3. Security: Master Password Caching & Cancellation Fixes (#735)

• Aborts database connections cleanly when the master password prompt is cancelled, preventing accidental connection attempts with an empty password. • Automatically resets unverified or failed master password caches on connection error so users are prompted again on their next connection attempt without needing to restart FlameRobin. • Added a "Clear cached master password" action under the View menu. • Added automated unit test suite (master_password_test) covering encryption, cancellation, incorrect password rejection, and cache invalidation.

4. UI & Usability Improvements

• Code Generation Templates: SELECT, INSERT, and UPDATE code generation dialogs now feature an editable table alias with default focus, allowing quicker query building (#731). • Table Header & Link Contrast in Light Mode: Fixed an issue where table headers rendered white text on light gray backgrounds and links had poor contrast in light theme mode (#736). • SVG Icons on Windows without Edge: Embedded SVG icons directly as base64 data URIs with X-UA-Compatible: IE=edge to ensure metadata property icons render properly on stripped Windows environments using MSHTML (#730).

Installing & Upgrading

Linux

One-line installer for current user (no root required):

:::bash
curl -fsSL https://raw.githubusercontent.com/mariuz/flamerobin/master/install.sh | bash

Debian / Ubuntu (.deb on Ubuntu 24.04+ / Debian 13+):

:::bash
curl -fLO "$(curl -fsSL https://api.github.com/repos/mariuz/flamerobin/releases/latest | grep -o 'https://[^"]*/flamerobin-[0-9.]*\.deb' | head -n 1)"
sudo apt install ./flamerobin-*.deb

Windows & macOS

Download the Windows installer (MSI / portable zip) or macOS package from the release assets below once CI artifact builds complete.

Full Commit Log since v26.9.8

• b263f965 Release v26.10.0: Performance Benchmark & Diagnosis, Firebird 1.5/2.0 fix, and security & UI improvements (#641, [#730], [#731], [#732], [#734], [#735], [#736], [#737], [#738], [#740])
• 7ae19563 Fix SVG icons not showing in Table properties on Windows without Edge (Fixes [#730])
• 402e1ab8 Merge pull request [#740] from nLeonardt95/fix/benchmark-report-webview
• 9da1fbc9 Merge pull request [#738] from nLeonardt95/fix/benchmark-ask-for-login
• ba93057d Merge pull request [#737] from nLeonardt95/fix/benchmark-menu-without-database
• f988c163 Add editable table alias with default focus in code generation templates (Fixes [#731])
• e1322750 Hide private information in the whole benchmark report
• 18b264cc Show the benchmark report with Edge, or in its own page in Internet Explorer
• 1707415c Add "Open in browser" to the benchmark dialog
• 77ffa449 Keep the benchmark HTML report readable in Internet Explorer
• 162d1502 Close the parenthesis in the trusted user label of the login dialog
• 1c670337 Ask for the login when the benchmark's registration has none saved
• 9c40a71f Add the login decision for a benchmark of the registration's server
• df80c0f6 Add the benchmark to the server and root context menus
• 0cf1525e Keep the benchmark entry in the Database menu when the menu is rebuilt
• f11ed91a Fix opening Firebird 1.5/2.0 databases by checking ODS for rdb (Fixes [#732])
• eaa48e12 Fix table header text and link colors in light mode (Fixes [#736])
• e0739334 Fix wrong master password caching and cancellation handling (Fixes [#735])
• d4615d96 Add Performance Benchmark & Diagnosis: measure a Firebird system and find out why it is slower (#641) (#734)