is an attempt to build a SQL layer for Freenet, so that you can
use Freenet as the storage component for SQL-based applications.
Implemented (for now) in perl, it strives for total SQL compliance,
that any SQL-based app can be ported to Freenet
would you want to port SQL apps to Freenet?
SQL-based web apps require you to own and operate your own, private,
database application, and then share that information with others
web site. With FreeSQL, you can write apps that use a global "communal"
database built into the fabric of Freenet. Keep in mind that "communal"
doesn't have to mean "world-writable" (although it can).
Freenet's secure SSKs, you can make your database "world-readable"
can also run multiple instances of the same app on the same data
even if those apps are running on different machines. Imagine
sites running on two different
web sites, but sharing the same pool of stories/comments/moderation.
such a scheme, there is no possiblity for censorship of any kind.
because anyone can put up a mirror just by downloading the Slash
and pointing it at the right database, the load is effectively
it surely is. However, with efficient caching, FreeSQL can get
good results if you leave it running for a while. You can even
local data to a Berkeley DBM file, effectively running a local
your distributed database. The point is that these local caches
blown away at will, without affecting anything other than speed.
short: FreeSQL let's you trade performance for anonymity and
distrubuted access. For some apps, that's a good deal.
this mean that my financial transaction database won't work with
Yes. FreeSQL is not a replacement for Oracle. Not even postgres.
apps don't use the full feature set of SQL, so most apps can be
FreeSQL. If your app runs on MySQL, it will almost surely run
slated to be ported to FreeSQL?
now, we are working on ports of the <a
PHPLIB, and at least one Slash-like app.
Please join our mailing list, or just email us your ideas.
FreeSQL just vaporware? Is it just an idea?
There is real live code for FreeSQL. No, it's not Oracle, but
does manage to mimic the command-line tool "mysql" pretty
much SQL compatibility do you have so far?
the 0.3 release notes:
FreeSQL is coming along nicely. The interactive SQL parser is
improved, and we can now support SELECT, INSERT, UPDATE, CREATE,
DELETE commands. The DB schema is stored in Freenet. We can also
primary and secondary keys (indexes) and, most importantly, we
parse the output from mysqldump. That's right, you can dump your
database to a file, and then read it in to FreeSQL. Hopefully,
that porting apps from MySQL to FreeSQL should be only a little
Feature requests that we could use some help with: DBD/DBI interface,
mimicking mysqldump and mysql, porting to a non-perl implementation,
efficient XML-RPC support.
Surf on over to <a href="http://freenet.sourceforge.net">their
to find out</a>. In short: Freenet is a fully distributed,
secure P2P file sharing architecture. It's not your mama's P2P