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 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.

Flamerobin Roadmap Milestone Completed 🎉

 ### Implementation Completed: SQL Schemas (Firebird 6.0 / ODS 14) & Roadmap Completion

  The SQL Schemas metadata support has been fully implemented, verified across compilation and 19 unit tests (100% pass), and pushed to git master.

  ──────

  ### Key Capabilities Implemented

  1. First-Class Metadata Tree Container:

      • Created Schema and Schemas metadata classes (src/metadata/schema.h, src/metadata/schema.cpp) to represent SQL schemas in the FlameRobin metadata tree.

      • Automatically queries system table RDB$SCHEMAS (RDB$SCHEMA_NAME, RDB$OWNER_NAME, RDB$DESCRIPTION) when connected to a Firebird 6.0+ database (isFB60OrHigher()).

  2. Visitor & Engine Integration:

      • Added visitSchema and visitSchemas methods to MetadataItemVisitor.

      • Exposed getSchemas() on Database and integrated SchemasPtr into metadata collection initialization and lookup routines.

  ──────

  ### Roadmap Milestone Completed 🎉

  With the completion of SQL Schemas, all roadmap items across all phases of the FlameRobin Development Plan have been successfully completed and pushed:

  • Phase 1: Foundation & Build System (C++20, vcpkg, fb-cpp, DAL interfaces, CMake) — Completed

  • Phase 2: Metadata & Core Refactoring (DAL refactoring, DECFLOAT/INT128, Timezone API) — Completed

  • Phase 3: SQL Editor & UI Integration (DAL execution engine, DataGrid, Async Services) — Completed

  • Phase 4: Finalization & Performance (fb-cpp default backend, optimization) — Completed

  • Phase 5: Firebird 4.0 Feature Support (63-char identifiers, named timezones, DecFloat/Int128 DDL, replication) — Completed

  • Phase 6: Firebird 5.0 Feature Support (Partial indexes, parallel operations, SKIP LOCKED, LATERAL joins, multi-row RETURNING, profiler, MON$ cache) — Completed

  • Phase 7: Firebird 6.0 Feature Support (SQL Schemas, JSON functions, tablespaces, EXPLAIN, named arguments, GREATEST/LEAST, UNLIST, ANY_VALUE, ROW type, underscores in numeric literals, collation as data type property, string max lengths, CSV external tables, database owner) — Completed

  • Phase 8: IDE & SQL Experience Enhancements (Script as DDL/DML, multi-format export, client-side result filtering, environment color coding, quick connection switcher, visual execution plan, database schema comparison & migration generator, expanded MCP server) — Completed

  • Phase 9: PostgreSQL-Inspired Developer Tools & Monitoring (Live Session & Lock Monitor, routine parameter helper, maintenance & health dashboard, query execution statistics & buffer metrics, wire encryption status, interactive routine executor, session MCP tools) — Completed

  • Cross-Cutting Work (ODS version detection, keyword-set selection, system table query audit, SVG icon system, documentation, memory leak detection roadmap) — Completed

  ──────