I‘ve been using Firebase and Firestore extensively in past projects, because I was attracted by it‘s simplicity on first sight.
Then there’s the day you need some relational queries. It‘s somehow possible, but you need to rethink your data structure.
Then you figure out, that the realtime part of Firebase is CPU intense and slows down your browser.
Call me nuts, crazy or whatever - I‘ve replaced most of these applications with SQLite (WAL enabled) and use either server-side-events (SSE) for almost realtime notification or the HTTP streaming API.
It works perfectly for my needs and is pretty simple to deploy.
Then there’s the day you need some relational queries. It‘s somehow possible, but you need to rethink your data structure.
Then you figure out, that the realtime part of Firebase is CPU intense and slows down your browser.
Call me nuts, crazy or whatever - I‘ve replaced most of these applications with SQLite (WAL enabled) and use either server-side-events (SSE) for almost realtime notification or the HTTP streaming API.
It works perfectly for my needs and is pretty simple to deploy.