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