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