Tommy van der Vorst

- [ ] COALESCE(x, y): returns `y` when `x` is NULL, `x` otherwise - [ ] LEAST(x, y, ...): returns the lowest argument - [ ] GREATEST(x, y, ...): returns...

Add a quota system

2

Currency system for database privileges, e.g. grants with a quotum on the maximum number of times they are used, and/or the number of bytes stored, etc.

Make Node IDs public keys

1

This allows to implement encryption and authentication between nodes in the future.

Database should contain a table that holds feature flags (e.g. which signing/key algorithms are used). The table should be created in block 1.

Triggers

1

Perhaps with a `triggers` table that has `on`, `condition` (see also #11) and `statement` columns (and perhaps also a way to run the trigger as the invoker or as the...

Like Ethereum; allow emitting events with a statement (“EMIT ‘somethingHappened’ (1,2,3);”). Events end up in a stream that can be listened to over websocket (after subscribing?). Event emission is to...

This alleviates memory pressure and helps when syncing is interrupted.

Specify (and check) SQL edge cases

1

- [x] What happens when selecting a column that does not exist? (SQLite: interpret the column name as string??). Suggestion: disallow completely. - [ ] How are `bare` columns dealt...

This should increase performance when large blobs are saved (eg in the Block archive).

Add support for outgoing peer connections on Linux

1

Needs a proper Linux WebSocket Client (Starscream relies on CFNetwork and that is not available on Linux)