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
