Technical Articles Archives - Page 6 of 78

Firebird x InterBase

May 24, 2017 Cantu Leave a comment

Historical overview

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.

Building Firebird 3 on MacOS

May 8, 2017 Cantu Leave a comment

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.

FB Documentation Crowdfunding campaign

April 29, 2017 Cantu Leave a comment

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.

Generating a script for FirebirdSQL from MySQLWorkbench

April 18, 2017 mariuz Leave a comment

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

How to protect Firebird databases from ransomware?

December 6, 2016 IBSurgeon News Leave a comment

Ransomware attacks became the serious problem for many companies: during the last week, we had 3 incidents from different customers which had their Firebird databases encrypted by ransomware viruses. Luckily we were able to help all of them, but the scale of the problem definitely increases.

Read new article: https://ib-aid.com/en/articles/how-to-protect-firebird-databases-from-ransomware/

« 1 … 4 5 6 7 8 … 78 »