Just an starting point , we have to do more research on postgresql,
sqlite , mysql and compare them with our own api

I wish firebird was more simpler to use similar to dbi api for example
(that i use in perl world)

You can see more about it in the bacula manual
http://www.bacula.org/manuals/en/concepts/concepts/New_Features.html#SECTION005140000000000000000

The according to libdbi (http://libdbi.sourceforge.net/) project:
libdbi implements a database-independent abstraction layer in C,
similar to the DBI/DBD layer in Perl. Writing one generic set of code,
programmers can leverage the power of multiple databases and multiple
simultaneous database connections by using this framework.

http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld005.htm

Here is how the libdbi driver is implemented and you can see the api fight
http://libdbi-drivers.cvs.sourceforge.net/viewvc/libdbi-drivers/libdbi-drivers/drivers/firebird/dbd_firebird.c?view=markup


Another proposal is to use an jdbc/odbc like api something similar
with mysql connector++
http://forge.mysql.com/wiki/Connector_C%2B%2B
or export the ibpp api like Milan said at the conference



Another idea is to support an REST api that i proposed in Firebird-Architect

An interesting api for firebird would be an REST api where with an
simple browser and javascript
you can access the databases and results can be returned in json format

http://wiki.apache.org/couchdb/HttpRestApi

Here is how Paul responded to me

"I would take a little non-
blocking http server and modify it to maintain a pool of FB
connections at its back-end (much like "popen" does in the PHP
driver). Code to take requests, generate the appropiate SQL and
convert the result set into a json string would be new, but seems
straightforward."

Basically I would connect to firebird from javascript/php using HTTP
like api without using any driver , just GET/POST/DELETE



--
developer flamerobin.org