alt Hacker NewsSure, if you're working on a small homelab with minimal to no processing volume.
The second you approach any kind of scale, this falls apart and/or you end up with a more expensive and worse version of Kafka.
Replies
raverbashing • yesterday at 4:17 PM
"Any kind of scale" No, there's a long way of better and more straightforward solutions than the simple SELECT
(SELECT * from EVENTS where TIMESTAMP > LAST_TS LIMIT 50) for example
I think there is a wide spectrum between small-homelab and google scale.
I was surprised how far sqlite goes with some sharding on modern SSDs for those in-between scale services/saas