Is it possible to distribute a database publicly?

1 points by mad_dev 10y ago ↗ HN

As a pastime project, I have decided to work on practical way to verify the authenticity of digital data (derived from https://www.anf.es/pdf/Haber_Stornetta.pdf). I have decided to use git(http://blog.sysbase.org/the-blockchain-question/) as a mean for keeping all records up to date. However, I still have doubts about git's feasibility.

Is there a way to distribute an SQL database--for example--publicly and yet keep all versions up to date(asynchronously), similar to blockchain yet different?

I am aware of the existence of mirroring and replication, but it will require authorization. That wont do it, especially if my goal is to give access to anyone who wants it.

3 comments

[ 3.0 ms ] story [ 19.2 ms ] thread

pwg 10y ago ↗

Look into SQLite (https://www.sqlite.org/). It is an SQL database in a single file.

The single file is easy to distribute publicly.

You will, however, have to layer your own method of keeping all copies up to date on top of SQLite. It does not have that capability built in.

mad_dev 10y ago ↗

Thanks, I'll look into it.

detaro 10y ago ↗

You probably could publish the logs used to make all changes, then anybody could download them and apply them to their copy of the database. Combine this with regular published snapshots (so that people that start new only have to apply all logs that came later).