Anzacathon, PostgreSQL and IPFS

[Daniel Pocock]

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

Re: Migration to PGLister - After

[Daniel Pocock]

On 20/11/17 18:32, John R Pierce wrote:
> On 11/20/2017 6:45 AM, Stephen Frost wrote:
>> The changes which we expect to be most significant to users can be found
>> on the wiki here:https://wiki.postgresql.org/wiki/PGLister_Announce  the
>> current version of which is also included below.
> 
> 
> A peeve on this new configuration:    if someone does a reply-all and
> sends both direct and list responses, the direct response ends up in my
> regular inbox because it doesn't have the List-ID... Previously, the
> direct reply would still have the Subject: [listname] that I filtered
> on, so it too would end up in my 'postgres' folder, where I want it.
> 
> I realize why this was done, and yada yada, what a mess.
> 
> 


People shouldn't do "Reply All" unless they really want you to see the
reply.

Comparing old and new:

List-ID: 

has become:

List-Id: 


Notice the case changes (from 'ID' -> 'Id') and 'lists' is inserted in
the middle.  Were both of those changes intentional?  Mail headers are
not case sensitive so good filtering software shouldn't notice the
former but everybody will be annoyed by the latter.

Regards,

Daniel