How to configure SQLite for

Using a simple INT with Unix millisecond timestamps is the best for performance.
COUNT is slow, so it can be useful to keep track of them in a separate table.

Distributed SQLite databases can be achieved the same way as PostgresSQL: one writer and multiple replicated readers.

Great insights too :)