FlameRobin Release 26.7.7 - Milestone Release 🎉

FlameRobin 26.7.7 marks the 100% completion of the entire FlameRobin Development Roadmap, delivering native Firebird 6.0 (ODS 14) support, SQL:2023 compliance, enhanced MCP monitoring, and advanced IDE developer productivity features.

Highlights & Key Features in v26.7.7

1. Firebird 6.0 (ODS 14) & SQL:2023 Features

• SQL Schemas Metadata Support: Added a first-class Schemas metadata tree container under Database nodes. Automatically loads database schemas from RDB$SCHEMAS on Firebird 6.0+ engines with visitor pattern and DDL support.
• Tablespaces (Firebird 6.0): Table and Index properties now read and display RDB$TABLESPACE_NAME assignments. Exposed Tablespace selection in Create Index and Create Table dialogs for Firebird 6.0+.
• Collation as Data Type Property (SQL:2023): Enhanced column DDL generation and field properties editing to support direct inline COLLATE clause definitions on string data types. Added {%columninfo:collation%} metadata template property tag.
• Optional String Max Lengths (SQL:2023): Formatted DDL templates for VARCHAR and CHAR data types to handle implicit-length syntax cleanly without unnecessary empty parentheses.
• Underscores in Numeric Literals (SQL:2023): Updated the SQL editor tokenizer to parse numeric literals with underscores (e.g. 1_000_000), as well as non-decimal integer literals (0x1F_4A, 0b1010_1100, 0o755_000, and x'1F4A').
• SQL-Standard ROW Data Type: Added native engine and DAL support for the SQL-standard ROW data type across type utilities and PSQL parsing.

2. Monitoring, Security & Session Diagnostics

• Compiled Statement Cache Visibility: Added a dedicated Compiled Statement Cache tab (MON$COMPILED_STATEMENTS) in the Session Monitor Frame displaying statement ID, cache hits, misses, hit ratio %, and statement text.
• Wire Encryption & Security Status: Integrated DatabaseSecurityStatus into database properties and statusbar badges, displaying MON$WIRE_CRYPT wire encryption status on Firebird 4.0+ connections.
• Interactive Parameterized Routine Executor: Built an interactive ExecuteRoutineDialog with parameter input controls, NULL checkboxes, execution engine, and structured result grid output.
• Expanded Model Context Protocol (MCP) Tools: Extended the built-in MCP server with new tools including list_active_sessions, cancel_statement, and recalculate_index_stats.
• Version Detection Refactoring: Replaced scattered hard-coded ODS version numbers with named constants (fr::ODSVersion) and connected per-version keyword sets for syntax highlighting.

Verification

• Built cleanly with Ninja/CMake and 19/19 CTest unit tests passed (100%).