HQbird 2024 R2 Update 10

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

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 [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.
VSS Writer: extended database state logging (size, timestamp, gstat -h).
cloudbackup: Socket protocol file upload support added.

More details is here.

Download here.