UDF Libraries for Firebird


rFunc UDF Library Multiplatform
Polaris SoftwareOpen Source (LGPL)

The library represents a set of user (UDF) string, bit, numerical functions, and also for operations using date and time and BLOBs. And also PARSER, i.e. calculation of expressions. Supported on InterBase 4.2, 5.x, 6.0 (Windows 9x, NT, 2k) and InterBase 5.x, 6.x (Linux) or Firebird 1.x. The library include more than 130 functions and "pseudo-functions". The library is written on C++ and is delivered with source code.

Home website | SourceForge Home | On-line Documentation | Maintained Fork
FreeAdhocUDF Multiplatform
Christoph TheuringOpen Source (LGPL)

Large UDF Library of over 500+ functions.

Home Website | Download
External File UDF's Windows
David RevillFreeware

A set of external functions for Firebird/InterBase which provides basic external file handling, create, write, delete, copy, merge. Useful for the creation of external text file logs of data input, or the creation of static HTML pages from databases.

Download
Blob UDFs Linux
Ian NewbyOpen Source

A collection of udf's for blob access.

Download
fb_mhash / fb_shash Windows / Linux
Richard KotalFreeware

A UDF library containing hmac and hash algorithm support. This library implements an interface to the mhash library (libmhash) and supports hash, hmac, and key generation algorithms, such as SHA1, MD5, MCRYPT, and S2K_SALTED. It also supports blob data too.

Home
uuidUDF Windows / Linux
Ian NewbyFreeware

This library contains both the source code and compiled udf library for guid generation. The compiled versions are for Windows or Linux. The Windows dll was compiled using the gcc cross platform compiler. The functions are:

  • create_guid() creates a 36 char string guid representation.
  • create_uuid() creates a 22 char string guid, which is a compressed form where the order of the sections is reversed to allow firebirds index prefix compression to take place. All the characters used in this uuid are valid characters in urls.
  • guid_to_uuid(guid char 36) compresses and reverses a guid to make a uuid.
  • uuid_to_guid(uuid char 22) converts a uuid to a guid.

Download
FB Server Lock UDF Windows
Si CarterOpen Source (IDPL)

This UDF allows you to obtain a server wide lock outside of connection and transaction boundaries. Locks can be obtained for 1..n seconds (upto 1 day)

Download
FB Smtp UDF Windows
Si CarterOpen Source (IDPL)

A UDF library for directly sending SMTP messages via triggers and stored procedures.

It works in 2 ways:

Direct Send - Email is sent directly and the result of the send is available immediately (this could be subject to normal network delay).

Queue - The library can optionally queue messages which are then sent on a dedicated thread every 10 seconds or so.

Also includes functions to test the results of sending the emails.

Download