We are in Beta with a windows tool: The RemSQL Library consists of standard dynamic link libraries (DLLs) that can be used in a wide variety of programming languages. Because most programming languages support calling functions exported from a DLL, the Library Edition provides the broadest compatibility with the various development tools available for the Windows platform. The Library Edition is ideal for languages such as C, Delphi, VB, FreeBasic, PowerBASIC etc . The RemSQL Library uses standard Windows DLLs just like SQLite.DLL (not COM activeX) which can be used by virtually any Windows programming language or scripting tool.
RemSQL is a high-performance, self-contained, zero-configuration, transactional library for extending SQLite to a remote server via the internet. It is built around a fast, memory efficient wrapper for the SQLite library, capable of handling large amounts of INSERT/QUERY data/from a remote (or local) SQLite database. Like SQLite, RemSQL is a small (180k) standardized interface Dll that natively provides CGI functionality, Encryption, Hashing, Very secure HTTP/TCP communication, SQLite User Defined Functions, and Supplemental operations like password verification, client software feature authorization, File transfer, remote program launching, Gathering Server metrics and any other remote user operation requiring an efficient communication framework. RemSQL is an IPC (interprocess communication) utilizing HTTP via TCP (Transmission Control Protocol) for the Windows platform. Both Client and Server must be running windows and utlize the same Dll. On the server, a simple CGI script (CGI.exe) can used to communicate between HTTP and the Dll. This allows low cost commercial windows hosting solutions to be used as a server. Alternatively an ISAPI module can also be created. In keeping with the SQLite concept, RemSQL does not need to be "installed" before it is used. There is no "setup" procedure. There is no Service that needs to be started, stopped, or configured, no Firewall "issues" to deal with and no Router port forwarding to be done. There is no need for an administrator to create accounts or assign access permissions to users, and no incompatibility issues with each new release of the database. There are no configuration files or setup utilities or installers that "might take a minute or two". Nothing needs to be done to tell the system that RemSQL is running. There is no MS-Management-Console, DCOM Config or Proxy/Interface-Creation/Registration. The user will not have to deal with a constant barrage of error messages, warnings, and popups: DNS errors, transient network outages, ASP errors, Javascript problems, missing plugins, temporary server outages, incorrect or expired certificates, problems connecting to the MySQL backend (common on any slashdotted web site), and a whole host of other issues. You will not be needing 63MB of compressed runtime modules or any external libraries. Pre-releases of the WinFX Runtime Components 3.0, the WinFX SDK, the Platform SDK, the Windows SDK, the .NET Framework redistributable, Microsoft Visual Studio, and their dependencies will not interfere with or cause anything to "fail or break functionality". There is no Base64 encoding and the associated XML bloating to 300% or more (some WMV files) Just copy RemSQL3.Dll to the target machine, and RemSQL3CGI.exe to the Server, and begin work. RemSQL is released under the Apache 2.0 license and is therefore free for commercial use and distribution. If that is what you are looking for and would like to beta test this and/or convert the headers for your language, please contact me. Derek Richard Klein <[EMAIL PROTECTED]> wrote: Federico Granata wrote: >> I was hoping there might be a client/server management tool out there. >> I would need the source code, since the server part would need to be >> ported to my embedded device. >> > Maybe you haven't yet read this http://www.sqlite.org/serverless.html > There isn't a sqlite server so you can't have a sqlite client, local or > remote. Sqlite doesn't come with a server, but some enterprising tool developer could write one, right? :-) - Richard _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users