When migrating from file databases or from MS SQL and ORACLE to Firebird, many developers often inquire about temporary tables. They are accustomed to using them while writing stored procedures. Though Firebird lacks temporary tables, a number of its mechanisms successfully emulate them. Below you will read about three methods of such emulation.

InterBase World - Emulation of temporary tables in Firebird

The magic required for working with date, time and timestamp: Finding the right date takes a little time.

The Code Project, Mainsoft, and IBM sponsored the competition to encourage developers to try their hand at porting .Net applications to run on Linux. Mainsoft also used the contest to highlight its Grasshopper Visual Studio plugin, which allows developers to convert .Net applications to Java bytecode.

The contest called for developers to port .Net applications to run on Linux, using whatever development tools the developers were comfortable with. So long as the ported applications replicated the behavior of the .Net version while running on Linux, any tool was fair game. The Code Project judged the entries, which were tested on IBM eServer xSeries running SUSE Linux 9.

Juan Ignacio de Paula was the first to submit a correct port of the Reports Kit, using Mono. He said it took "about 10 hours" to port the Reports Starter Kit to Linux using Mono and the Firebird database, including the time it took to migrate the database, deploy and test the application, and write the instructions. "I think only 20% of the time was dedicated to ASP.Net or C# programming."

This is a really good time...

NewsForge | Race to Linux winners announced

Firebird ADO.NET Provider 1.7.1 RC2 is available:

• Download
• Release Notes