HQbird: Advanced FirebirdSQL

HQbird 2024 R2 Update 9

IBSurgeon releases version HQbird 2024 R2 Update 10. In addition to fixes from vanilla versions relases, HQbird has the following

Materialized Views (New Feature) in 5.0

• New persistent view type: defined like a view, stored like a table. Supports indices; DML and triggers not allowed.
• Syntax: CREATE / ALTER / RECREATE MATERIALIZED VIEW ... AS <query> [WITH [NO] DATA]. Drop via regular DROP VIEW.
• Convert between types: ALTER ... TO NOT MATERIALIZED and ALTER VIEW ... TO MATERIALIZED.
• REFRESH MATERIALIZED VIEW — four modes:
  • Default: full exclusive reload (fastest for many changes).
  • CONCURRENTLY: merge-based update, no exclusive lock, requires unique index.
  • DROP DATA: clears all data and indices to free space.
  • CASCADE: refreshes all dependent MVs in correct dependency order.
• gbak restore automatically refreshes all MVs. Use -NO_MATVIEWS switch to skip. Backup containing MVs requires MV-capable Firebird to restore.

Backup & Recovery

• Verification backup: revolving pre-compression deletion; disk space coefficients now configurable.
• Backup-Restore-Replace task: configurable backup directory and filename template (e.g. brr_{0,date,yyyyMMdd_HH-mm-ss}.fbk); directory auto-created if missing.
• nBackup: journal rename changed to atomic rename with retry.

Trace & Monitoring

• New connection_id field in trace configuration dialog.
• Trace report: case-insensitive process name grouping and filtering; progress percentage during report generation.

Web Interface & Configuration

• Web console localization improvements; new labeled divider element for form grouping.
• Cache-busting updated to prevent stale JS/CSS after upgrades.
• Default file transfer settings unified: port 8722, user socketuser, strong password.
• KA license registration: HTTP/HTTPS prefix no longer required in host field.

Bug Fixes

• False critical alert when all database tasks are temporarily disabled — fixed.
• Trace session list error for SYSDBA users without trace list permissions — fixed.
• UTF-8 paths in decryption component causing mon/trace errors — fixed on DG side.
• Replication config: empty-value keys no longer retained after removal.
• journal_archive_command handling for Firebird 4+ corrected (FB PR #8381).

Installer & Build

• Windows installer updated; client library binaries and OpenSSL updated.
• Separate Maven build profiles for HQbird/FBSQLPlus with auto-substitution of version, product name, and license text.
• VSS Writer: extended database state logging (size, timestamp, gstat -h).
• cloudbackup: Socket protocol file upload support added.