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.
en
br
IBSurgeon provides the encryption plugin framework for Firebird:
To recover corrupted Firebird (or InterBase) databases you can use IBSurgeon FirstAID - the best recovery tool for Firebird and InterBase. FirstAID can automatically fix the vast majority of Firebird database corruptions. For big database (more than 65Gb in size) please contact our support, most likely it will require manual recovery service.