6 ms·
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 s
by hilti 4y ago
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.
- honzajde 4y agoHow would you handle "db-notifications" with sqlite - to my knowledge this is a reason why you would need postgresql with its' (pg) NOTIFY
- b3morales 4y agoSQLite calls this an "update hook": https://www.sqlite.org/c3ref/update_hook.html https://www.sqlite.org/c3ref/update_hook.html
- rockwotj 4y agoSQLDelight had neat built in support for this https://cashapp.github.io/sqldelight/ https://cashapp.github.io/sqldelight/
- hilti 4y agoExactly! Or in some cases I create a view - for example a highscore list - that is queried by a simple server-side script and sends the data as JSON to the client.
- marviel 4y agoYou should check out supabase -- it takes this pattern (with a Postgres backend instead) and packages it up in an open source, cloud hosted but also self-hostable model