I have implemented just such a system as an RPC. It accesses an HTTP
server using CGI and returns the table or view requested in XML. The
application parses what it wants from the XML.
The programs are simple C, compiling on Unix and Windows, and include an
XML parser based on Expat.
You are welcome to the code if it would fit in with your project.
Martin Pfeifle wrote:
Hello,
We would like to access (only reading access) a remote sqlite database via http.
On a remote computer, an http server is located and an sqlite database file
(we are not allowed to install any software on that http-server).
On a client computer, an application program wants to access the sqlite file via http.
As http supports reading ranges from files and also supports persistent connections,
it is in principal possible to write an “os_http” unit (similar to os_unix, os_win,..) which
allows to access sqlite files directly via http, i.e. we can simulate fseek, fread and fopen via http.
My question now is whether somebody has already some experience with such an “http-port”.
Best Martin
