3 ms·
| Databases that are built into the application by default are the future. I'm not sold on client side, but a lot of great work is being done on putting the db
by emseetech 2y ago
| Databases that are built into the application by default are the future.
I'm not sold on client side, but a lot of great work is being done on putting the db and application on the same server, between SQLite replication and other approaches like SpacetimeDB. I'm interested to see where it goes.
- vlovich123 2y agoSQLite underpins nearly every on-disk storage mechanism at Apple and Google as the OS level. You may not be sold but systems programmers elsewhere are.
- emseetech 2y agoWhat works for Apple and Google is rarely the best approach for the rest of us. My concern is over-reliance on client side storage and the complexity it adds to have records of state on both client and server.
- vsuperpower2021 2y agoSqlite isn't something that works for only apple or google. Point is it's sufficient for them, simple, and more than sufficient for you. He's explaining to you that this is something that has already happened as you're unaware.
- emseetech 2y agoI use SQLite all the time, I said in another comment it's my go-to for server-side green field projects. But there's a lot of push to create data solutions that are fully bidirectional between client and server, or to even make them client-driven in an awkward peer-to-peer model, and I'm not sold on either pattern.
- lupusreal 2y agoSqlite is at it's best in "pure client" situations where there is no server and there are no P2P things going on. Just the application, the user, and their data on their own drive with sqlite.