FBLib Firebird Library

Open Source Library No Data Aware for direct access to Firebird Relational Database from Borland Delphi/Kylix, Freepascal and Lazarus

TFBLDatabase TFBLTransaction TFBLDsql TFBLMetadata TFBLScript TFBLService TFBLEvent TFBLParamDsql

Last fblib update: 2006-11-18 (0.85)

fenixsql(win32/linux) 2006-11-18

Current Features

Direct Access to Firebird 1.0.x 1.5.x 2.0 Classic or SuperServer
Multiplatform (Win32,Gnu/Linux,FreeBSD)
Compatible with Delphi PE ,Kylix OE , Freepascal 2.0.2 or above and TurboDelphi (1)
Automatic select client library 'fbclient' or 'gds32'
in kylix no visualclx/freeclx required (only rtl)
Query with params
Support SQL Dialect 1/3
LGPL License agreement
Extract Metadata
Simple Script Parser
Only 100-150 KB added into final EXE
Support BLOB Fields
Export Data to HTML SQL Script
Service manager (backup,restore,gfix...)
Events Alerter
Documentation
Thread safe (2)
Compatible with firebird 2.0
New component TFBLDataset (readonly,unidirectional) New !

(1) You cannot integrate components in Turbodelphi Explorer IDE
but You can use fblib as class library , see turbodelphi examples

(2) components thread safe are TFBLDatabase,TFBLTransaction,TFBLDsql
for default FbLib is NOT thread safe for enable this feature activate compiler directive
"FBL_THREADSAFE" in file fbl.inc.

Documentation can be generated from source code with pasdoc tool http://pasdoc.sourceforge.net
for more information how to create documentation see readme.txt in fblib source code
get documentation in WinHtmlHelp from download section Downloads

fenixsql

simple admin tool for Firebird developed with Firebird Library and released under GPL License
fenixsql is multiplatform version of fenisql is producted with lazarus.

fenixsql screeshot

Downloads

Description Filename Platform Version Date

fblib source code
source,docs,examples fblib.zip (356Kb) Win32/Linux/FreeBSD 0.85 2006-11-18

fenixsql source fenixsql-src.zip (264Kb) Win32/Linux 0.42 alpha 2006-11-18

fenixsql binary fenixsql-bin.zip (986Kb) Win32 0.42 alpha 2006-11-18

Description	Filename	Platform	Version	Date
fblib source code source,docs,examples	fblib.zip (356Kb)	Win32/Linux/FreeBSD	0.85	2006-11-18
fenixsql source	fenixsql-src.zip (264Kb)	Win32/Linux	0.42 alpha	2006-11-18
fenixsql binary	fenixsql-bin.zip (986Kb)	Win32	0.42 alpha	2006-11-18

Software and documents downloadable here is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. If you live or are intended to use this software in countries where this is not applicable ("AS IS" basis), DO NOT.

Author

Alessandro Batisti
email: Alessandro Batisti

History

Date Version Description

2006-11-18 0.85
New component TFBLDataset it's a TDataset descentant (unidirectional,readonly).

Property TFBLDatabase.Connected is now published read/write.

Bugs fix in TFBLDsql.

2006-09-26 0.84
rewrite class TFBLEventThread

various internal modification and bugs fix

fpc and lazarus compile with directive {$mode objfpc}{$H+}

support for TurboDelphi explorer

tested on firebird 2.0

2005-12-08 0.83
correct bugs in class TFBLScript (90% code are new)

correct bug in class TFBLDatabase (access violation when value of "username" or "password" is an empty string)

updated Lazarus package (fblib.lpk)

2005-10-20 0.82
New component TFBLParamDsql (thanks to Uwe Willmann) it's a direct TFBLDSQL descendant supporting named parameters instead of "?" placeholders, like IBX and IBObjects.

lazarus package (fblib.lpk) now works with version 0.9.10 of lazarus ide.

2005-09-02 0.81
FBLDSql.pas : correct bug in method ParamAsString when insert an empty string

Add unit 'FBLSimple.pas'

2005-06-21 0.80
class TFBLDatabase,TFBLTransction,TFBLDsql are now Thread-safe

(for default these class are not thread-safe for enable this feature activate compiler directive FBL_THREADSAFE in fbl.inc)

Documentation can be created with pasdoc http://pasdoc.sourceforge.net

2005-04-09 0.77
various internal modification and bugs fix

2005-03-20 0.76
FBLService.pas : add event OnConnect

FBLService.pas : add event OnDisconnect

FBLService: add GFix functions for set properties and repair database

Various internal modifications

2005-02-20 0.75
FreeBSD Compatibility with Freepascal 1.9.6

2004-11-01 0.74
Add package for Lazarus Ide (fblib.lpk)

2004-10-21 0.73
Fixed Bugs with freepascal compiler >= 1.9.4

FBLDsql.pas : add function 'TFBLDsql.FieldByNameIsNull(const AFieldNAme: string): Boolean;

2004-06-26 0.72
FBLService.pas : add property 'TFBLService.Version: Integer'

FBLService.pas : add property 'TFBLService.ServerVersion: string'

FBLService.pas : add property 'TFBLService.ServerImplementation: string'

FBLService.pas : add property 'TFBLService.ServerPath: string'

FBLService.pas : add property 'TFBLService.ServerLockPath: string'

FBLService.pas : add property 'TFBLService.ServerMsgPath: string'

FBLService.pas : add property 'TFBLService.UserDbPath: string'

FBLService.pas : add property 'TFBLService.NumOfAttachments: Integer'

FBLService.pas : add property 'TFBLService.NumOfDatabases: Integer'

FBLService.pas : add property 'TFBLService.DatabaseNames: TStringList'

FBLService.pas : Corrected bugs with Firebird 1.5 Classic server

2004-06-19 0.71
FBLTransaction.pas : add property 'TFBLTransaction.ReservationReadTables: TStrings'

FBLTransaction.pas : add property 'TFBLTransaction.ReservationWriteTables: TStrings'

FBLTransaction.pas : add property 'TFBLTransaction.TableReservationMode'

FBLDatabase.pas : add property 'TFBLDatabase.UserNames'

2004-06-03 0.70
Add Feature: Events Alerter class 'TFBLEvent' unit FBLEvents.pas

Various internal modifications

2004-05-30 0.53a
Fixed bug in FBLMetadata.pas property 'TFBLMetadata.Tables','TFBLMetadata.Views'

Fixed bug in FBLTransaction.pas method 'TFBLTransaction.StartTransaction'

2004-05-08 0.53
FBLDatabase.pas : Add property 'TFBLDatabase.CharacterSet'

2004-04-08 0.52
FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobFieldSaveToStream'

FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobParamLoadFromStream'

FBLDsql.pas : Change blob functions 'TFBLDsql.BlobFieldAsString'

FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobParamAsString'

FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobFieldSaveToFile'

FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobFieldByNameSaveToFile'

FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobParamLoadFromFile'

FBLService.pas : Change procedure 'TFBLService.GetUsers'

2004-03-24 0.51
Add feature: Service manager TFBLService

Backup Restore Database

Security manager: AddUser, ModifyUser, DeleteUser, DisplayUser

Database report statistics

View LogFile

Change license agreement from GPL to LGPL

Various internal modifications

2004-03-02 0.38
Some bugs fix

2003-12-14 0.37
TFBLDsql: Fixed Bugs in query with params

2003-11-29 0.36
TFBLDatabase: add properties ClientVersion,ClientMajorversion,ClientMinorVersion (only Firebird 1.5)

2003-11-16 0.35
Support Freepascal compiler 1.9.0 or above

2003-11-08 0.35
Fixes bug in TFBLExportToHtml

2003-11-03 0.35
First public realase

Date	Version	Description
2006-11-18	0.85	New component TFBLDataset it's a TDataset descentant (unidirectional,readonly). Property TFBLDatabase.Connected is now published read/write. Bugs fix in TFBLDsql.
2006-09-26	0.84	rewrite class TFBLEventThread various internal modification and bugs fix fpc and lazarus compile with directive {$mode objfpc}{$H+} support for TurboDelphi explorer tested on firebird 2.0
2005-12-08	0.83	correct bugs in class TFBLScript (90% code are new) correct bug in class TFBLDatabase (access violation when value of "username" or "password" is an empty string) updated Lazarus package (fblib.lpk)
2005-10-20	0.82	New component TFBLParamDsql (thanks to Uwe Willmann) it's a direct TFBLDSQL descendant supporting named parameters instead of "?" placeholders, like IBX and IBObjects. lazarus package (fblib.lpk) now works with version 0.9.10 of lazarus ide.
2005-09-02	0.81	FBLDSql.pas : correct bug in method ParamAsString when insert an empty string Add unit 'FBLSimple.pas'
2005-06-21	0.80	class TFBLDatabase,TFBLTransction,TFBLDsql are now Thread-safe (for default these class are not thread-safe for enable this feature activate compiler directive FBL_THREADSAFE in fbl.inc) Documentation can be created with pasdoc http://pasdoc.sourceforge.net
2005-04-09	0.77	various internal modification and bugs fix
2005-03-20	0.76	FBLService.pas : add event OnConnect FBLService.pas : add event OnDisconnect FBLService: add GFix functions for set properties and repair database Various internal modifications
2005-02-20	0.75	FreeBSD Compatibility with Freepascal 1.9.6
2004-11-01	0.74	Add package for Lazarus Ide (fblib.lpk)
2004-10-21	0.73	Fixed Bugs with freepascal compiler >= 1.9.4 FBLDsql.pas : add function 'TFBLDsql.FieldByNameIsNull(const AFieldNAme: string): Boolean;
2004-06-26	0.72	FBLService.pas : add property 'TFBLService.Version: Integer' FBLService.pas : add property 'TFBLService.ServerVersion: string' FBLService.pas : add property 'TFBLService.ServerImplementation: string' FBLService.pas : add property 'TFBLService.ServerPath: string' FBLService.pas : add property 'TFBLService.ServerLockPath: string' FBLService.pas : add property 'TFBLService.ServerMsgPath: string' FBLService.pas : add property 'TFBLService.UserDbPath: string' FBLService.pas : add property 'TFBLService.NumOfAttachments: Integer' FBLService.pas : add property 'TFBLService.NumOfDatabases: Integer' FBLService.pas : add property 'TFBLService.DatabaseNames: TStringList' FBLService.pas : Corrected bugs with Firebird 1.5 Classic server
2004-06-19	0.71	FBLTransaction.pas : add property 'TFBLTransaction.ReservationReadTables: TStrings' FBLTransaction.pas : add property 'TFBLTransaction.ReservationWriteTables: TStrings' FBLTransaction.pas : add property 'TFBLTransaction.TableReservationMode' FBLDatabase.pas : add property 'TFBLDatabase.UserNames'
2004-06-03	0.70	Add Feature: Events Alerter class 'TFBLEvent' unit FBLEvents.pas Various internal modifications
2004-05-30	0.53a	Fixed bug in FBLMetadata.pas property 'TFBLMetadata.Tables','TFBLMetadata.Views' Fixed bug in FBLTransaction.pas method 'TFBLTransaction.StartTransaction'
2004-05-08	0.53	FBLDatabase.pas : Add property 'TFBLDatabase.CharacterSet'
2004-04-08	0.52	FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobFieldSaveToStream' FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobParamLoadFromStream' FBLDsql.pas : Change blob functions 'TFBLDsql.BlobFieldAsString' FBLDsql.pas : Change blob procedure 'TFBLDsql.BlobParamAsString' FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobFieldSaveToFile' FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobFieldByNameSaveToFile' FBLDsql.pas : Add blob procedure 'TFBLDsql.BlobParamLoadFromFile' FBLService.pas : Change procedure 'TFBLService.GetUsers'
2004-03-24	0.51	Add feature: Service manager TFBLService Backup Restore Database Security manager: AddUser, ModifyUser, DeleteUser, DisplayUser Database report statistics View LogFile Change license agreement from GPL to LGPL Various internal modifications
2004-03-02	0.38	Some bugs fix
2003-12-14	0.37	TFBLDsql: Fixed Bugs in query with params
2003-11-29	0.36	TFBLDatabase: add properties ClientVersion,ClientMajorversion,ClientMinorVersion (only Firebird 1.5)
2003-11-16	0.35	Support Freepascal compiler 1.9.0 or above
2003-11-08	0.35	Fixes bug in TFBLExportToHtml
2003-11-03	0.35	First public realase