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 released here
1. Firebird 6.0 (ODS 14) & SQL:2023 FeaturesSQL 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 DiagnosticsCompiled 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.
