1. Technology
Send to a Friend via Email

Interbase / Firebird with Delphi

Programming with Delphi - articles, tutorials, whitepapers. Focus on Interbase and Firebird databases.

Interbase / Firebird Managers
Looking for an Interbase / Firebird manager kind of tool. Look no more! The list has some of the greatest IB database supporting tools on the Net.

Optimizing InterBase Applications
Learn how to design and optimize InterBase client applications. We discuss good design, patterns for common tasks, and when and how to optimize

Borland Interbase Home Page
Feature Matrix, Features & Benefits, Datasheet (PDF), Technical Specification, Open Source, White Papers, Articles, Documentation, Case Studies

Conceptual Architecture for InterBase/Firebird
In this paper, we investigate the conceptual architecture for the InterBase/Firebird database. We identify the major components of the database system and their interactions.

Extending InterBase with User Defined Functions
An overview of UDF's - User Defined Functions

How to insert an InterBase BLOB in Delphi
Example uses Delphi LoadFromFile method

How to retrieve an InterBase BLOB in Delphi
Simple example using SavetoFile. While this example is designed for InterBase, it may be applied easily to any database

Writing Clean and Safe UDFs In Delphi
This article makes some assumptions about the reader’s knowledge of Delphi. The reader should understand Delphi well enough to know how to create a DLL – We will demonstrate how to create UDFs, not DLLs. That being said, much of the article depends heavily on the study of FreeUDFLib

Implementing a Soundex Function
"This is all achieved by utilising the SOUNDEX method of indexing, encapsulating it in a DLL, using that as an Interbase UDF and modifying our Interbase table to use this key. "

An Introduction To InterBase
This paper is not a "how to use" Interbase document. It is geared toward making new Interbase users aware of some of the important things to pay attention to.

Introduction to InterBase SQL
There is a lot of information in this paper, and if you're new to SQL you may find it helpful to try out each section as you go.

Known Causes of Corruption in InterBase Databases
InterBase is, in general, a very stable database server and corruption is rare. When corruption does occur, then, it is important to determine the cause of the corruption. This article describes circumstances that can cause corruption

Upsizing From dBASE to InterBase
This article is mostly about the theory behind client/server computing and the features of InterBase. There is no easier way, less expensive way to get your client/server feet wet than with the wonderful InterBase database server engine.

Upsizing Paradox Databases to InterBase
With forward planning and building on your database experience, you can move a relatively complex desktop database to the league of SQL database servers.

Using InterBase Data Types
"When one comes to InterBase for the first time in appears that some important data types are missing or difficult to implement. Not so. It is just a matter of knowing what to do."

Why You Can't Pass a List to an InterBase SQL Param
When writing a WHERE clause in your InterBase SQL, it would sometimes be convenient to write WHERE FOO IN (:SomeParam) and pass a list of values to SomeParam. You can't do that; here's why.

©2014 About.com. All rights reserved.