Hacker News new | ask | show | jobs
by zzo38computer 2768 days ago
There is no webpage, but the client and protocol documentation is included in the ZIP file at: http://zzo38computer.org/sql/sqlext.zip (sqlext_remote.c is the client implementation, and sqlext_remote.doc is client documentation and protocol documentation (it is a plain text file))

Currently there is no server (other than an internal testing program), although you are free to make some if you want to do so.
1 comments
Ws32ok 2768 days ago
How does this compare to just using Postgres?

Is this a networked version of sqlite?

link
zzo38computer 2768 days ago
No. The remote data can use any kind of SQL database (SQLite or otherwise), or does not need to use SQL at all (and even if it does use SQL, the view does not necessarily have to resemble at all the actual schema that the server uses to store the data). It does not even have to be stored data; it can generate the data on demand if needed. It is not direct database access! You have public access to the data, as the server implements it.

A few examples may be possible to specify. I mentioned above movie showtimes and weather; even if they come from different services, you can make a joined query on the client side, such as to find all movies playing within ten miles in places that are not raining, or whatever. Another use is you might hvae some set ofdata that occasionally gets updated (e.g. Magic: the Gathering cards Oracle texts), and you might make a local backup with incremental updates (which will be efficient if there is a last updated column, and the server can use such a constraint in the WHERE clause (if the server doesn't support the constraint, the client will interpret it and download all data and filter it), so that you need not download the data that you already have). Another example is remote databases that many people can help to add the data to (it can be writable too and need not be read only).

It isn't another version of SQLite; you can still use it with the ordinary SQLite (or implement the protocol even outside of SQLite; this protocol does not use any SQL codes, so it does not need to be used only with SQL, although it is designed mainly for use with SQL).

link