HQbird: Advanced FirebirdSQL for Big Databases

IBSurgeon HQbird is an advanced distribution of Firebird, with the following features: high availability and replication, backups automation, optimized configurations, database health monitoring, transactions and queries monitoring (TraceAPI, MON$, and FBScanner), database structure analysis, recovery toolset, and database development GUI.

Firebird Encryption Plugin Framework

IBSurgeon provides the encryption plugin framework for Firebird:
  • Strong AES256 encryption
  • Pre-built binaries for Windows and Linux, and full sources
  • Gbak.exe with encryption of databases and backups
  • Unlimited license for the redistribution and implementation support

Emergency database recovery

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.
From $199


HQbird 2020 is released. Now it is simply the fastest Firebird

Veja a versão em Português abaixo.

IBSurgeon is glad to announce the general availability of HQbird 2020. HQbird 2020 is the new release of the advanced FirebirdSQL distribution with a lot of new features:

  • Multi-thread Sweep, Backup, Restore (in Firebird 2.5 and 3.0, HQbird Enterprise only)
    • Sweep – up to 6x faster
    • Backup – up to 5x faster
    • Restore – up to 2x faster
    • Please note: to enable multi-thread features set in firebird.conf parameter MaxParallelWorkers=64 and restart Firebird
  • Speed-up heavy reports (up to 5x times) (Firebird 3.0, HQbird Enterprise only)
    • Queries with many fields in SELECT and large sorting (GROUP BY, ORDER BY, etc) can automatically use REFETCH plan to gain up to 5x performance
    • New parameter in firebird.conf to manage sort behavior
    • No changes in applications' sources/SQLs required
  • Encryption Plugin (3.0, HQbird Enterprise only)
    • AES256 strong encryption, for Windows and Linux, low penalty on performance
    • gbak with encryption support, decrypt low-level tool (for recovery)
    • Examples of sources for Delphi, NET, PHP, Java
    • Support of encrypted databases in HQbird
  • Authentication plugin for transparent Execute Statement On External (3.0, HQbird Enterprise only)
    • allows establishing trusted authentication of ESOE without password
  • RSA-UDR: sign documents (strings and BLOBs) (3.0, HQbird Enterprise only)
    • Public/Private Keys generation
    • SQL functions to calculate digest, sign documents and verify the signature
  • Enhanced performance monitoring reports (2.5, 3.0)
    • Low penalty on performance, easy to schedule
    • Top queries reports: time-consuming, frequent, CPU-consuming, disk, etc
  • Enhanced silent installation and registration – on Windows
  • Automatic upgrades of HQbird: checking and download
  • Control Center For Firebird (2.5, 3.0, for subscription customers only)
    • Review status of many Firebird servers on the same page
    • Notifications about successful backups and critical problems

The detailed description of HQbird 2020 features is available in HQbird User Guide https://ib-aid.com/download/docs/hqbirduserguide2020.pdf


The existing subscription customers and customers with active maintenance will receive HQbird 2020 automatically in the next few days.

The customers with very recent purchases and customers from Firebird Developers Day 2019 (Brazil) also will receive HQbird 2020.


You can upgrade from any old version of HQbird to HQbird 2020: https://ib-aid.com/en/upgrades-ibsurgeon/

em Portuguese

Lançamento do HQbird 2020: Firebird Turbinado

O IBSurgeon tem o prazer de anunciar a disponibilidade geral do HQbird 2020. O HQbird 2020 é o novo lançamento da avançada distribuição do FirebirdSQL com muitos recursos novos:
  • Multi-thread sweep, backup, restauração (no Firebird 2.5 e 3.0, apenas no HQbird Enterprise)
    • Sweep - até 6x mais rápido
    • Backup - até 5x mais rápido
    • Restaurar - até 2x mais rápido
    • Para ativar os recursos multi-thread configurados no parâmetro firebird.conf MaxParallelWorkers = 64 e reiniciar o Firebird
  • Acelere relatórios pesados ​​(até 5x vezes) (Firebird 3.0, apenas HQbird Enterprise)
    • As consultas com muitos campos em SELECT e a classificação grande (GROUP BY, ORDER BY, etc) podem usar automaticamente o plano REFETCH para obter desempenho de até 5x
    • Novo parâmetro no firebird.conf para gerenciar o comportamento de classificação
    • Não são necessárias alterações nas origens / SQL dos aplicativos
  • Plug-in de criptografia (3.0, apenas HQbird Enterprise)
    • Criptografia forte AES256, para Windows e Linux, baixa penalidade no desempenho
    • gbak com suporte à criptografia, descriptografar ferramenta de baixo nível (para recuperação)
    • Exemplos de fontes para Delphi, NET, PHP, Java
    • Suporte de bancos de dados criptografados no HQbird
  • Plug-in de autenticação para declaração de execução transparente no externo (3.0, apenas HQbird Enterprise)
    • permite estabelecer autenticação confiável do ESOE sem senha
  • RSA-UDR: assinar documentos (strings e BLOBs) (3.0, apenas HQbird Enterprise)
  • Geração de chaves públicas / privadas
    • Funções SQL para calcular resumo, assinar documentos e verificar a assinatura
  • Relatórios aprimorados de monitoramento de desempenho (2.5, 3.0)
    • Baixa penalidade no desempenho, fácil de agendar
    • Top SQL queries: demorado, frequente, CPU, disco, etc.
  • Instalação e registro silenciosos aprimorados - no Windows
  • Atualizações automáticas do HQbird: verificação e download
  • Centro de Controle para Firebird (2.5, 3.0, apenas para clientes de assinatura)
    • Revise o status de muitos servidores Firebird na mesma página
    • Notificações sobre backups bem-sucedidos e problemas críticos

A descrição detalhada dos recursos do HQbird 2020 está disponível no Guia do Usuário do HQbird (em Ingles) https://ib-aid.com/download/docs/hqbirduserguide2020.pdf


Os clientes de assinatura existentes e os clientes com manutenção ativa receberão o HQbird 2020 automaticamente nos próximos dias.

Os clientes com compras muito recentes e clientes do Firebird Developers Day 2019 (Brasil) também receberão o HQbird 2020.


Você pode atualizar de qualquer versão antiga do HQbird para o HQbird 2020: https://ib-aid.com/en/upgrades-ibsurgeon/

04 October 2019

HQbird 2020 is released. Now it is simply the fastest Firebird

The new release of HQbird 2020 delivers significant performance improvements.

08 May 2019

How to track deadlocks in Firebird

The practical guide on how to track update conflicts in Firebird

09 April 2019

Transactions in Firebird

The article "Transactions in Firebird" is the introduction to the basics of Firebird transactions: ACID, isolation levels, updates conflicts and "true deadlock".

04 April 2019

New article: Fast conversion from Firebird 2.5 to 3.0 with streamed backup-restore

The new article describes how to convert Firebird 2.5 database into Firebird 3.0 with the stream backup-restore.

26 February 2019

HQbird 2018R4 is released

Read more news