> Firebase offer subscription models to database changes, but falls short when dealing with complex queries involving joins or group-bys.
Firebase is the only tool here I'm familiar with, and this makes sense to me. It's real time data "for dummies", where you don't have to worry about the internals.
They can guarantee that simple gets return events quickly, but if you're asking for complex queries, you actually have to engineer the tradeoffs.
Like, what happens if you are frequently writing to 2 tables, and are subscribed to a view that joins both?
Firebase is the only tool here I'm familiar with, and this makes sense to me. It's real time data "for dummies", where you don't have to worry about the internals.
They can guarantee that simple gets return events quickly, but if you're asking for complex queries, you actually have to engineer the tradeoffs.
Like, what happens if you are frequently writing to 2 tables, and are subscribed to a view that joins both?