Re: [sqlite] accessing sqlite files directly via http

2006-06-17 Thread John Stanton
I don't completely. It is very difficult to totally safeguard such an interface, but I do use an approach which applies a security layer which will stop fairly unsophisticated attacks, but which is still vulnerable to a real-time man-in-the-middle. I do not send SQL, instead have the RPC be a

Re: [sqlite] accessing sqlite files directly via http

2006-06-16 Thread Jay Sprenkle
On 6/15/06, John Stanton <[EMAIL PROTECTED]> wrote: 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. How do you ensure non malicious code is sent to RPC? -- SqliteImporter and SqliteReplicator: Command line u

Re: [sqlite] accessing sqlite files directly via http

2006-06-15 Thread John Stanton
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 a

[sqlite] accessing sqlite files directly via http

2006-06-15 Thread Martin Pfeifle
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 sq