Fighting Petya: our experience with retrieving data from the Firebird database files encrypted by ransomware crypto-viruses
As you know, recently several crypto viruses have attacked many companies – most well-known are Wannacry and Petya. Usually, as reported by many companies, it is necessary to pay a ransom, or, in the case of Petya, all encrypted files will be lost.
InterBase was created in 1985: it was the first commercial multi-versioning database. In the end of 1999, Borland decided to close InterBase development and published its source codes under InterBase Public License. This code was copied (it is permitted by the license), and Firebird was born – from the version 1.0 Firebird is a production-ready database, based on previous decades of InterBase development.
At the end of 2000, Borland turned back to the closed source and commercial licenses (exactly as it was earlier) with InterBase and started development of 6.5.
Firebird 1.0 was released in 2002, with many bugfixes and extensions of DDL and DML. The active Firebird development continued after 1.0, and in 2004 the second major version of Firebird (v.1.5) was released. Borland at that time also has introduced new versions (7.0 and 7.1). Firebird 1.5 and InterBase 7.0 was incompatible both by database format (ODS) and core functionality. The migration from InterBase to Firebird and back with backup/restore is impossible since Firebird 2.0 and InterBase 7.0.
Since then, the difference between Firebird and InterBase became bigger.
Check the full article from IBSurgeon, and see the currently diferences between Interbase and Firebird.
Disponível também em Português.
Firebird 3 was released almost a year ago and it has already got two minor releases. But there is still no official packages for MacOS. So this post is about my humble attempt to build it on MacOs from source code. Most of the instructions are taken from Paul Beach’s Firebird Devel list post or from his blog.
Read full article here.
Goal: Translate & Publish Firebird Developer Guide
During 2015-2016 IBSurgeon and the Moscow Exchange sponsored the authoring, in Russian, of step-by-step examples for newbie Firebird developers, with databases in 2.5 and 3.0 format. The work included full source code and parallel examples in Delphi, .Net desktop, .Net MVC, PHP (based on Laravel) and Java (Jaybird 2.x). The main work was done by Denis Simonov, who previously edited the Russian version of the Firebird 2.5 Language Reference that was translated into English and published last year.
The Firebird Project’s 2017 project is to translate this work into English, edit and review it and publish it as the Firebird Developer Guide in the project’s documentation library. For this project, as ever, we need funding. This is your opportunity to make it happen, by contributing whatever you can to our crowdfunding campaign.
To donate, go to here and click the donate button.
MySQLWorkbench allows to design database model easily and also provides an option to generate the SQL script. By default script is generated for MySQL, but, what if you need to generate a SQL script for FirebirdSQL?
Here is the solution via python plugin