Some random follow up thoughts on todays discussion with @jo_liss, @terzicigor and @dgeb
After more thoughts it seems to me that on the backend it’s almost unavoidable to have commits built in to the database, or at last to have some kind of a persistence layer on top of the database. Basically if someone or something changes the database and do not update "commits table", the system will become inconsistent. So are we trying to invent a new database?
On most backend apis there is a serialization/presentation layer on top of the database, which means api objects != database objects. It means what we were describing today, is not a drop in replacement for REST apis in the form they exists today. Firebase is a “dumb store”, this is why they can be smart about synchronization.
We had only little talk about multiuser scenarios. Or even anonymous users. Seems like a lot to think about here. There should be a way to subscribe to some subsets of data with the right authorizations. What happens if authorizations c