Re: [Freesql-discuss] Ping?

[Clark F. <cl...@ph...>]

Hmmm.

So you want to port FreeSQL to JavaScript, so that the JavaScript "apps"
can use Freenet as storage?

Well, I suppose it's possible--instead of calling Freenet commands on the
local mahine, the way FreeSQL does in the perl version, you would make
XML-RPC calls from within the JavaScript to some Freenet node. Assuming JS
and Freenet support that, I don't see why not.

One problem I see is that one of the advantages of FreeSQL is performance
boosting using local caching. If you can't use local files, you are out of
luck on that one.

The other problem, or question really, is Why do you want to do this in
JavaScript of all languages? I generally try avoid JavaScript whenever I
can.

Another suggestion: Why don't you just use one of the many security holes
in various JavaScript implementations to gain access to the local file
system and store the files that way? Just kidding. :)

As to your question about indexing and table joins, from a quick look at
the FreeSQL code, it does do indexing but it doesn't appear to support
joins as yet.

eries wrote the code so I don't know much more than you about its
inner workings.

Hope that helps, at least a little.

Clark

On Tue, 10 Dec 2002, Gordan Bobic wrote:

> Well, that's one other person, at least. :-)
>
> I don't suppose you are familliar with the innards of the FreeSQL source
> code?  I'm assesing it's concept for one of my projects, but I am
> concerned about potential performance issues, indexing and table joins.
>
> What I am essentially trying to do is design a distributed client-server
> architecture. The applications would be written in JavaScript, and would
> run as much as possible in the client browser (full DOM compliance
> required). It would make the web browser itself an application platform.
> Obviously, this would not be suitable for all applications, but for most
> office type use (word processing, email), it would be perfectly
> adequate. I have the development of this under way already.
>
> Obviously, there is a problem - there is no way to store or access data
> on the local machine through JavaScript. The solution I am working with
> at the moment is XML-RPC calls to the server "half" of the system, which
> would allow for operations that cannot be performed on the client. This
> can be somewhat limited at times, though, as the user is locked into
> using the services of someone running the server. What I am trying to do
> is use FreeNet as the data storage medium. This would mean that the user
> could securely use the applications through public FreeNet nodes,
> without needing to use the server half of the system.
>
> Obviously, a proper server is still useful for some tasks, but the idea
> of using FreeNet is looking very attractive at the moment. What is
> required for this to happen is a fully JavaScript implementation of
> FreeSQL that would provide an API for using FreeSQL on a public FreeNet
> node as an SQL database server.
>
> Any comments/ideas/suggestions?
>
> I am not afraid of doing the implementation of this myself, but some
> input from other people while I'm looking through the FreeSQL source
> code would be appreciated.
>
> Regards.
>
> Gordan