Really Useful
Firebird default head
Sourceforge CCA Awards 2009
Really Useful

A page of files or links containing tips, tricks, techniques, practices and 'gotchas' that Firebird users found 'Really Useful'.

If you have something like this, that you want to share on this page, please email it to helebor AT iinet DOT net DOT au with REALLY USEFUL in the Subject header.

Article Index

Converting Data to Firebird by Writing "Native" External Files
Henrique Netzka describes a technique he has developed to convert data from another DBMS to Firebird.
Writing UDF's in Delphi for Interbase/Firebird
Gerhardus Geldenhuis documents how to write a UDF in Delphi using techniques he learned from using resources around the IB/FB community web sites.
Some Stored Procs to Massage Dates
Markus Ostenried shares some time and date routines that he has converted to Stored Procedures from RxLib and the Jedi Code Library.
Instant GBAK & Restore on Win2K
Markus Ostenried offers a .REG file for Win2K that creates a new entry in the Windows Explorer's context menu for *.gdb and *.gbk files.
Autostart Shell script for IB/FB on Linux
Jorge Alvarez shares the trick for getting ibserver to load and run when you boot up your Linux server machine.
Claudio Valderrama's Writings
Claudio is a famous contributor to IB lists, newsgroups and beta groups. These pages of original articles document his experiences as an often critical and rigorous user, tester and mentor of IB/Firebird over many years.
Link :: Click here :: from :: Claudio Valderrama
Ivan Prenosil's Articles
Ivan has been working with IB for five years and has contributed about 1000 messages to IB lists and newsgroups. He tests everything he posts about and his answers to questions are reliable. On these pages, he has begun putting together some of the topics into essays to help others. Link :: Click here :: from :: Ivan Prenosil
Some notes on Linux and Unix installs
Link :: Click here :: from :: various sources
HOW-TOs for InterBase and Java
Joe Shevland's collates instructions and examples for using Interbase® with the Java 2® platform and JDBC. (Under construction at 8 November 2000).
Link :: Click here :: from :: Joe Shevland
HOW-TO Install IB 6 on Linux Red Hat 6.2 ( + RH 7.0)
It's easy - quick HOW-TO for getting IB 6 up-and-running on your RH 6.2 box. With RH 7.0 notes added.
Link :: Click here :: from :: C R Zamana
WRITING UDFs (User-defined Functions) FOR INTERBASE
Transcript of Gregory Deatz' presentation at Borcon 2000, San Diego.
It's not the "definitive guide", according to Greg, but enough to demonstrate the basic guidelines and gotchas. InterBase R & D folk, past and present, are cordially invited to augment Greg's material in any way they consider useful, to help throw more light on this attractive IB feature.
Link :: Click here :: from :: Gregory Deatz
CONNECTING TO INTERBASE WITH DELPHI AND C++BUILDER
A digest of features of two data access component suites - InterBaseXpress and IB Objects - for connecting your application to the InterBase API.
Link :: Click here :: from :: various contributors
SOME SOLUTIONS TO OLD PROBLEMS
Dalton Calford shares his solutions to some implementation problems that might affect you - collected from postings to the IB-Architecture list.
Approaching 24 X 7 Service, Hardware Configuration, Server Configuration, Methods for Backing up your Data, Roll-Forward Logging, Replication, Reversing User Actions.
Link :: Click here :: from :: the IB-Architect list
This BAT file (renamed as .txt for downloading purposes), is for doing a nightly backup and restore of a database on an NT platform only. It does the restore to a copy of the production database. My apps accept a parameter pointing to the database. I usually put up a production and training icon on each user's desktop pointing to the respective databases. So I backup nightly, check the backup by restoring to a database and have a fresh, up to date, training database each day.

The file should be generalized (drive and path names, etc) but I find I usually work it through each time adding whatever else I've come across.

The BAT file is really derived from input from several other people whose names I have lost. I apologize in advance to them and acknowledge my debt.

File :: Nightly Backup (4K) :: from :: Bill Surowiec

A while ago I read some articles written by Bill Todd about Interbase's MGA and record versioning in general that were published in Delphi Informant. I wrote to Bill to ask him if could put the articles up on his web site, which he has kindly done.

Link :: Bill Todd's Articles :: from :: Daniel Work

Get Firebird at SourceForge.net. Fast, secure and Free Open Source software downloads This site and the pages contained within are Copyright © 2000-2009, Firebird Project.
Firebird® is a registered trademark of Firebird Foundation Incorporated.