Tommy van der Vorst

This prevents issues with grants being assigned to the wrong database. Is SQLite case sensitive?

Provide a desktop application

1

Small mac app wrapper that starts up and shows the web client (should be separate project). There are issues with using SPM together with XCode in Mac apps... perhaps wait...

This needs an index of transactions probably (or some kind of efficient heuristic, like a bloom filter?)

See e.g. https://github.com/portier/portier-broker/blob/master/Dockerfile. One image for building, then one for running.

Support column aliases ('AS' syntax)

1

Allow renaming of columns: ```` SELECT expr AS foo; ```` This should work properly with column name verification (#88). It should also not be possible to create duplicate column names.

Currently we just translate all parameters to string. This needs to be a bit more sophisticated. See https://github.com/pixelspark/catena/blob/8fc47a647f2eb0ce45f7a70888cf99b085cfaa1a/Sources/PostgresWireServer/QueryConnection.swift#L218

Could make depending on CommonCrypto unnecessary... https://github.com/coruus/keccak-tiny

Checkpoints

2

Rollup = current state of database serialized in some canonical format (note, take care of undefined stuff, such as row ordering, sorting specifics, etc.). * Mark every N'th block as...

Forget blocks/transactions but keep the data

1

We are currently essentially storing any data twice: once in the transaction that created it, and once in the database itself. Transactions/blocks need to be kept around because other nodes...

NAT Traversal

1

Options to investigate: * STUN * TURN * ICE * uPnP * NAT-PMP * TCP/UDP hole punching?