Is it possible to distribute a database publicly?

#1

Post by mad_dev » Wed, Nov 25, 2015, 3:04 PM UTC

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.

Re: Is it possible to distribute a database publicly?

#2

Post by pwg » Wed, Nov 25, 2015, 3:07 PM UTC

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.

Re: Is it possible to distribute a database publicly?

#3

Post by mad_dev » Wed, Nov 25, 2015, 3:22 PM UTC

pwg wrote: post #2

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.

Thanks, I'll look into it.

Re: Is it possible to distribute a database publicly?

#4

Post by detaro » Wed, Nov 25, 2015, 3:47 PM UTC

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).