Anzacathon, PostgreSQL and IPFS

From: Daniel Pocock <daniel(at)pocock(dot)pro>
To: pgsql-general(at)postgresql(dot)org
Subject: Anzacathon, PostgreSQL and IPFS
Date: 2020-04-19 14:47:06
Message-ID: e4c9a6e1-5bef-51bd-0d87-a44c48b35c8a@pocock.pro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

I've started putting together a hackathon, the Anzacathon[1], for Anzac
Day. It revolves around data.

I decided to distribute raw data for participants using SQLite files in
the peer-to-peer IPFS filesystem.

Then I put together this nice little recipe for importing the SQLite
directly from IPFS to PostgreSQL using fuse and pgloader:

https://gitlab.com/anzacathon/postgresql

The script could be adapted for any similar activity.

I also thought about designing a script that automatically discovers the
IPFS sources, without listing them one by one. That will come later.

Instead of SQLite, it is also possible to distribute CSV and pg_dump
files through IPFS like this.

Regards,

Daniel

1. https://anzacathon.com

Browse pgsql-general by date

  From Date Subject
Next Message Saurav Sarkar 2020-04-20 14:52:23 Usage reporting of Cloud provided PostgreSQL service
Previous Message Adrian Klaver 2020-04-18 16:24:32 Re: Replication issue