Here's what I've been working on the past couple days: https://gitlab.com/soapbox-pub/ditto/-/merge_requests/5

- got kysely query builder working with Deno + SQLite

- created an sqlite event store

- index some tags under certain conditions

- implement NIP-01 relay filters (it's almost a relay)

- add functions for querying events and users

A user can be a member of multiple Ditto servers at the same time. Imagine you could have one account and log into both Gleasonator and Poast with it. That's the future.