Projects

Flamerobin

FlameRobin is an administration and management GUI tool for the Firebird DBMS written in C++ using wxWidgets and IBPP libraries. The goal of the project is to build a lightweight, cross-platform application which doesn't have any closed-source dependency for either building or running.

IBPP, a C++ API for Firebird Server

IBPP is a C++ client class library for Firebird Server (and Interbase(R))

fbsql

FBSQL Project Goalsfbsql aims at easing the use of Firebird and Interbase databases by providing clean client-libraries for different languages. The raw Firebird/Interbase-API is very awkward and hard to work with, while fbsql is easy and straight-forward like for example the sqlite- and mysql-APIs ... [More] are. Currently C and Lisp are supported. fbsql uses IBPP, a C++ Interbase/Firebird API for it's implementation. It's basically just a thin wrapper around IBPP to make it accessible in C, and therefore in any other language. Supported PlatformsCurrent Linux with GCC, Windows with mingw and Windows with Microsoft Visual Studio 2005 are tested. The code is rather portable, so I believe on every platform where the firebird client-library and IBPP are accessible, fbsql will work, too. As for the Lisp-library, I've only tested it with CLISP on Linux, yet. Again, this should be rather portable to most Lisp-implementations and platforms, too. Example CodeHere's an example C-code which connects to a database and selects the IDs of the table "test": #include "fbsql.h" #include #include int main() { struct fbsql_database *db; struct fbsql_transaction *tr; struct fbsql_statement *st; int id; db = fbsql_database_new("localhost","/pub/firebird/Test1.fdb","sysdba","5735","","iso8859_1",""); fbsql_database_connect(db); tr = fbsql_transaction_new_with_defaults(db); fbsql_transaction_start(tr); st = fbsql_statement_new(db,tr); fbsql_statement_prepare(st,"select id from test"); fbsql_statement_execute(st); while(fbsql_statement_fetch(st)) { if( fbsql_statement_get_integer(st, 1, &id) ) printf("ID: NULL\n"); else printf("ID: %d\n",id); } fbsql_statement_close(st); fbsql_statement_delete(st); fbsql_transaction_rollback(tr); fbsql_transaction_delete(tr); fbsql_database_disconnect(db); fbsql_database_delete(db); return 0; }DownloadI've added a "Sneak-Preview" download today, that's the base of what will be the first release. It should already be pretty usable, basic tests all worked out. Check it out at the download-page! [Less]

qtfirebirdibppsqldriver

Qt SQL driver for Firebird with IBPP library Note: from version 0.14 default charset is "NONE" The format of the options string is a semicolon separated list of option=value pairs. CHARSET - character set ROLE - role name // QFIREBIRD connection ... [More] db.setConnectOptions("CHARSET=WIN1251;ROLE=ROOT");Last changes: Version 0.17.1 - change conversions between Firebird and Qt "ASCII" = "ISO 8859-1" "BIG_5" = "Big5" "CYRL" = "IBM 866" "DOS850" = "IBM 850" "DOS866" = "IBM 866" "KOI8-R" = "KOI8-R" "KOI8-U" = "KOI8-U" "EUCJ_0208" = "JIS X 0208" "GB_2312" = "GB18030-0" "ISO8859 (1-9, 13)" = "ISO 8859-(1-9, 13)" "KSC_5601" = "Big5-HKSCS" "SJIS_0208" = "JIS X 0208" "UNICODE_FSS" = "UTF-8" "UTF8" = "UTF-8" "WIN125(0-8)" = "Windows-125(1-8)" else use QTextCodec::codecForLocale() Version 0.17 + "make install" will copy driver to QT_INSTALL_PLUGINS/sqldrivers - fixed: character sets exception ( Issue 8 ) Conversions between Firebird and Qt "ASCII" = "IBM 866" "BIG_5" = "Big5" "CYRL" = "KOI8-R" "DOS850" = "IBM 850" "DOS866" = "IBM 866" "EUCJ_0208" = "JIS X 0208" "GB_2312" = "GB18030-0" "ISO8859 (1-9, 13)" = "ISO 8859-(1-9, 13)" "KSC_5601" = "Big5-HKSCS" "SJIS_0208" = "JIS X 0208" "UNICODE_FSS" = "UTF-32" "UTF8" = "UTF-8" "WIN125(0-8)" = "Windows-125(1-8)" else use QTextCodec::codecForLocale() Version 0.16 - fixed: NUMERIC and DECIMAL fields with small length return wrong value ( Issue 7 ) Version 0.15 - fixed: Produce different targets depengind on config (Debug Release) ( Issue 6 ) + license under LGPL version 2.1 + license under GPL version 3.0 Version 0.14 - fixed: ASSERTION in qsqlcachedresult when calling stored procedure ( Issue 1 ) - fixed: bug when blob contains '\0' char ( Issue 2 ) + Add support of firebird ROLE ( Issue 3 ) + change in IbppDriver.pro for support debug and release builds ( Issue 4 ) - fixed bug when only "NONE" and "WIN1251" charset is set ( Issue 5 ) - compile warnings [Less]