Hacker News Reader

How does it deal with big tables (8B+ rows)? Does it split the table onto multiple shards or each shard only gets full tables?

Completely up to the user. Neki doesnt automatically shard, its all controlled by the data topology (https://planetscale.com/blog/what-is-a-data-topology).

That page doesn't mention how joins between tables using different split keys work, or how indexes work.