Or, and apparently this is crazy these days - I can just use a file that’s in a format appropriate to what I’m trying to do, compatible with the simpler offline app it was made for, and then just use a more general purpose syncing method whether online or sneakernet if I need to do some kind of data transfer - as opposed to accumulating an ever expanding collection of server stacks that are just redundantly doing the same kind of thing anyway while needlessly adding an insane amount of attack surface.
SQLite allows for more efficient querying of data than doing it by hand, can enforce constraints on the data, and I can query it from my shell.
Of course it’s not going to replace a commonly-used format for a domain. If no such format exists, it’s a perfectly acceptable data format for data that’s tabular in nature. And it can by sync’d/backed up the same as any other file.
An sqlite database is a perfectly fine portable data format.
Or, and apparently this is crazy these days - I can just use a file that’s in a format appropriate to what I’m trying to do, compatible with the simpler offline app it was made for, and then just use a more general purpose syncing method whether online or sneakernet if I need to do some kind of data transfer - as opposed to accumulating an ever expanding collection of server stacks that are just redundantly doing the same kind of thing anyway while needlessly adding an insane amount of attack surface.
SQLite allows for more efficient querying of data than doing it by hand, can enforce constraints on the data, and I can query it from my shell.
Of course it’s not going to replace a commonly-used format for a domain. If no such format exists, it’s a perfectly acceptable data format for data that’s tabular in nature. And it can by sync’d/backed up the same as any other file.