On Fri, Jun 20, 2008 at 10:56 PM, paulruizendaal <pnr@...> wrote:

> --- 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.

yes i think i can do this in a few days wih php create an rest-ful api

>
> Paul
>
>

--
developer flamerobin.org