News for hackers. Stuff that matters.
Re:Show HN: I made an app that consolidated 18 apps (doc, sh... by winrid on Sunday January 07, 2024 @02:54PM (#38904557)
He's most likely using SQLite per account, because that's the easiest way to have an offline DB and sync it, which will most likely scale perfectly fine with appropriate indexes as long as you are careful about the feature set.
Re:Show HN: I made an app that consolidated 18 apps (doc, sh... by sgarland on Sunday January 07, 2024 @03:01PM (#38904618)
That introduces a new problem when it syncs to others in the same workspace, if it’s large.
Re:Show HN: I made an app that consolidated 18 apps (doc, sh... by Mertax on Monday January 08, 2024 @08:59AM (#38911968)
Nice thing about SQLite is you can “clone” the repository by copying a single file. And in cases where you need incremental sync, you can use an SQLite of diff’s as a single packfile (similar to git).

Things like cr-SQLite also have a lot of potential to make single SQLite per client a lot more viable. But I’m interested to see what you think the problems are? Have you found a solution or alternative?