--- In Firebird-Architect@yahoogroups.com, "marius popa" <mapopa@...>
wrote:

>
> 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
>
> you don't need no driver or configuration
>
> --
> developer flamerobin.org
>

Marius,

The issue with this api is that the connections are very shortlived
(the spec closes the connection after every step). Building up TCP
connections has a considerable cost by itself. Even worse, like most
other databases Firebird has a even far higher connection
establishment cost.

You could alleviate this by trying to modify the protocol to use keep-
alive connections, but this would require knowing the size of the
responses before transmission starts and if overdone kills the
RESTfulness.

If I were to build this (and I am not :^) 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.

If someone really wants it bad, it takes only a few weeks to build.
Just my 2cts worth.

Paul