FlameRobin Release 26.7.7 - Milestone Release
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
Schemasmetadata tree container under Database nodes. Automatically loads database schemas fromRDB$SCHEMASon Firebird 6.0+ engines with visitor pattern and DDL support. - Tablespaces (Firebird 6.0): Table and Index properties now read and display
RDB$TABLESPACE_NAMEassignments. 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
COLLATEclause definitions on string data types. Added{%columninfo:collation%}metadata template property tag. - Optional String Max Lengths (SQL:2023): Formatted DDL templates for
VARCHARandCHARdata 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, andx'1F4A'). - SQL-Standard ROW Data Type: Added native engine and DAL support for the SQL-standard
ROWdata 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
DatabaseSecurityStatusinto database properties and statusbar badges, displayingMON$WIRE_CRYPTwire encryption status on Firebird 4.0+ connections. - Interactive Parameterized Routine Executor: Built an interactive
ExecuteRoutineDialogwith 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, andrecalculate_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%).