Am 18.10.2012 15:41, schrieb Abhinav:
Does SQL lite have an option of processes connecting to it from remote hosts
with a port number?
There's nothing directly built-in in the sqlite-library.
In case you need that for Windows (also depends on your development-
environment a bit) my SQLite-COM-wrapper supports an "AppServer-Mode",
which is able to transfer resultsets (serialized Recordsets)
from the serverside to the clientside, supporting compression
as well as encryption... (there's dedicated RPC-Listener-Classes
to easily implement the serverside with a few lines of code -
and also dedicated Client-RPC-Classes which can communicate
with the server-end over TCP/IP.
The write-direction (Inserts, Updates, Deletes) is supported
too - also based on serialized Recordsets, which are able
to serialize to only "the diff, created on the clientside in
a user-session" back to the serverside - and then these
"accumulated changes" of such an backtransported "Diff-Recordset"
can be applied in a single transaction on the server-end.
Though, as said, the wrapper is a COM-library - usable only
on Windows ... (although it is tested and known to work also
on Linux/Wine) ... so, it's usage is restricted to languages,
which can load and access COM-libs (preferrably from VB5/VB6,
or "Office-VBA" - but also from Delphi, C++, Powerbasic, etc. -
but a bit less comfortable then).
There's other "free networking-implementations" as well, which
are known to be "alive and kickin"... as e.g.
http://www.sqlitening.com/support/index.php
(also for windows, implemented in PowerBasic)
ALso check out Marco Bambinis efforts here:
http://www.sqlabs.com/blog/
(not sure, if these new products strictly require MacOS-Hosts -
the former Real-Server was SQLite-based and ran on more systems
than just MacOS AFAIK, maybe Marco can help out himself here)
There's also a page on the SQLite-wiki - but not sure which
of the listed projects is actively supported or maintained yet.
http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork
But what finally remains are of course Webserver-(http-) based
solutions, where you can transfer back and forth with e.g.
JSON-based RPCs or with XMLhttp-Requests (with http-GZ-compression
when needed, or SSL for encryption).
Olaf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
