2 ms·
> I have started looking at tying together clusters of business apps that each have independent SQLite datastores using an application-level protocol for replic
by hn_throwaway_99 6y ago
> I have started looking at tying together clusters of business apps that each have independent SQLite datastores using an application-level protocol for replication & persistence (over public HTTPS). This allows for really flexible schemes which can vary based upon the entity being transacted. With hosted SQL offerings, you are typically stuck with a fairly chunky grain for replication & transactions. If you DIY, you can control everything down to the most specific detail.
Ugh, I'm totally going to sympathize with whoever eventually joins your company after you've left who has to own this.
- bob1029 6y agoI don't think I have provided enough contextual details in order for this type of conclusion to be reached. I'd be happy to offer a hypothetical if you are interested in debating the merits of my approach.