Author: Cantu

I'm the owner of the www.Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guide to Firebird 3. Loving Firebird even before it was born!

Firebird Performance Comparer (FBPC)

Leave a comment

In my two presentations at the 20th Firebird Developers Day, I introduced firsthand the tool I created to help compare the performance between two Firebird servers (>= 2.5) in an easy and visual way.

This tool actually helped to detect a performance regression in Firebird 5 beta, which was resolved after I reported it to the core developers. The intention is to identify optimizer regressions or low performance issues in Firebird itself, or even the breaking of SQL commands due to new reserved words or syntax restrictions.

I’m making version 1.0 beta available for anyone interested. It’s a version that so far has been tested only by me, so it may and probably does have some bugs.

The FBPC runs on Windows and internally uses Firebird 5 RC1 embedded to store the tests and their results. When you run the application for the first time, it will display instructions on how to use it.

In summary, it helps you create a trace.conf to capture SQL commands executed on a Firebird server 2.5 or higher in a production environment. Then, the tool parses the file and collect the statements, allowing you to run them in a controlled environment of servers, specifying test rounds where the execution time between server1 and server2 is compared and displayed in an intuitive and visual way, enabling you to detect regressions or even commands that could not be executed due to new reserved words or syntax restrictions imposed in new versions of the DBMS.

Firebird Foundation New Officers and Committee

Leave a comment

Annual General Meeting of Firebird Foundation is finished, and the new Officers and Committee were elected and start to work:

President of Firebird Foundation: Alexey Kovyazin
Vice-President of Firebird Foundation: Pavel Cisar
Treasurer and Secretary of Firebird Foundation: Jason L. Wharton

Committee Members:

  • Jiri Cincura
  • Adriano dos Santos Fernandes
  • Magnus Johansson
  • Stephanie McColl
  • Roman Simakov
  • Dmitry Yemanov
  • Lucas Franzen
  • Matthew Nielsen
  • Fabio Codebue

Firebird 5 RC1

Leave a comment

Firebird Project announces the first Release Candidate of Firebird 5.0, the next major version of the Firebird relational database, which is now available for testing on all supported platforms (Windows, Linux, MacOS, Android).

This Release Candidate demonstrates the complete set of features and improvements developed for the new release. Release Candidates are generally considered stable enough and may be recommended for testing in “almost-production” environments. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Please read the Release Notes carefully before installing and testing this Release Candidate.

20º Firebird Developers Day

Leave a comment

Exclusive for Brazilians:

Está aberta a pré-venda para o 20º FDD, que será realizado de forma presencial no dia 21 de outubro, em Piracicaba – SP. O FDD é o maior evento de Firebird do mundo e acontece anualmente no Brasil há 20 anos!

As 100 primeiras inscrições receberão gratuitamente a versão impressa do novo Guia de Migração para o Firebird 5, produzida exclusivamente para o FDD!

Mantivemos os mesmos valores de inscrição do ano passado, sendo que na pré-venda você paga o valor mais barato. Para se inscrever, faça o login no site da FireBase! Se já estiver logado, vá direto para a página de inscrição clicando aqui.

Inscreva-se agora e garanta sua edição comemorativa impressa do novo Guia de Migração!

Firebird to CSV

Leave a comment

Firebird to CSV converter is a free program to export Firebird or Interbase databases into comma separated values (CSV) files. The program has high performance due to direct reading of the source database and writing into CSV files. Firebird to CSV converter does not use ODBC or any other middleware. Command line support allows to script, automate and schedule the conversion process.

Features:

  • All versions of Firebird and Interbase are supported
  • Fast conversion engine (100MB database – in less than 5 minutes on average modern system)
  • Option to convert individual tables
  • Option to select separator: tab, comma or semicolon
  • Option to store conversion settings into profile
  • Command line support
  • Easy-to-use wizard-style interface
  • Full install/uninstall support
  • Unlimited 24/7 support service
  • Freeware

Firebird 5.0 beta 1 is out!

Leave a comment

Firebird Project announces the first Beta release of Firebird 5.0, the next major version of the Firebird relational database, which is now available for testing.

This Beta release arrives with features and improvements already implemented by the Firebird development team, as well as with many bugfixes. Our users are appreciated giving it a try and providing feedback to the development mailing list. Apparent bugs can be reported directly to the bugtracker.

Beta releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release.

Please read the Release Notes carefully before installing and testing this Beta release.

Curso: Backups no Firebird (PT-BR)

Leave a comment

This is only for Portuguese speakers.

Está cansado de lidar com a constante preocupação de perder informações importantes do seu banco de dados Firebird? Quer ter a certeza de que seus dados estão protegidos e sempre disponíveis, mesmo em situações de emergência? Então você precisa conhecer esse curso especializado em backups de banco de dados Firebird!

Você aprenderá técnicas avançadas e muitas vezes desconhecidas para fazer backups eficientes e confiáveis. Descubra também como fazer backup/restore em um único passo, sem precisar criar arquivos intermediários, economizando tempo, espaço em disco e simplificando o processo.

Saiba também como usar o gbak gerando como resultado final um backup já compactado com o 7zip, otimizando espaço em disco! Você também aprenderá sobre backups incrementais, mais rápidos e que armazenam apenas dos dados que foram adicionados ou alterados desde o último nível de backup, deixando o processo mais eficiente e possibilitando a realização de backups mais frequentes.

Apenas durante o lançamento, até o dia 24/fevereiro, o curso estará sendo vendido de R$ 397 por R$ 250 através do link tinyurl.com/uyuupcez. Todos compradores receberão também gratuitamente meu eBook Guia de Migração para o Firebird 3!

Não perca mais tempo e garanta agora seu acesso a esse curso exclusivo! Proteja seus dados e tenha a certeza de que eles estão sempre seguros. Torne-se um expert em backups de banco de dados Firebird!

A venda e a entrega estão sendo feitas via plataforma Eduzz, e você pode pagar com cartão, pix ou boleto bancário.

Fixed IB DataPump

One comment

Probably almost everyone who have worked with Firebird and Interbase know this nice utility called IB DataPump, from CleverComponents (CC). It is a Windows GUI tool that allows data to be pumped from IB/FB or different RDBMSs to Firebird/Interbase databases.

Unfortunately, the (original old) tool had a problem that avoided pumping to Firebird 3 databases (you got a “list index out of bounds” error). CC seems to have fixed that problem but one of the most useful features is was still broken: the automatic reorder of the tables to avoid broken dependencies based on the existing Foreign Keys!

The good news is that CC open sourced this tool a while ago, and Vlad Khorsun (our fellow Firebird’s Core Developer) was able to fix that problem!

Now you can download the fixed version here.

Thanks, Vlad, for the time spent fixing this problem, and please enjoy my small donation for your work 🙂

Update 03-Nov: Vlad has now published his changes.

1 2 3 4 … 99