Eventual Consistency isn’t for Streaming
Almost every distributed system (including "simple" client-server systems) is eventually consistent. And all systems are distributed.It's great that your DB is ACID and anyone who queries it gets the latest greatest but in reality you also have out of date caches, ORM models that haven't been persisted, apps where users modifying data that hasn't been pushed back to the server and a million other examples.I'm sure it's possible to create a consistent system but I'm also sure it's not practical. No one does it.Instead of constantly fighting eventual consistency just learn to embrace it and its shortcomings. Design systems and write code that are resilient to splits in HEAD and provide easy methods to merge back to a single truth.