2 ms·
I see a lot of this kind of stuff but does anybody know what the actual DBA/SA story is for some big SQLite cluster? What if you have a non-trivial amount of d
by VWWHFSfQ 4y ago
I see a lot of this kind of stuff but does anybody know what the actual DBA/SA story is for some big SQLite cluster? What if you have a non-trivial amount of data and you actually care about it? Do you just have a bunch of 800 gigabyte db.sqlite files sitting around?
- bastawhiz 4y agoI mean, nobody thinks of Postgres and MySQL as 800gb of files of tuples and btree data sitting around. Traditional DBMS software handles the replication and coordination of all those files. SQLite doesn't do that, and there's some bespoke external software that handles that. If you're a DBA/SA working with one of those systems, you're going to need to be an expert not just at SQLite, but at the software that does the work that SQLite isn't doing on its own. That'll be special skills.
- jasonwatkinspdx 4y agoI'm working on something in this area so I'd like to flip back the question to you. If you had a clustering system that managed an arbitrary number of sqlite databases for you across a pool of servers, what would be your desired features or priorities?