10 ms·
Transferring whole sqlite databases makes sense when one side (usually the client) really uses the file as semi-persistent database for some non-trivial timespa
by dfox 9y ago
Transferring whole sqlite databases makes sense when one side (usually the client) really uses the file as semi-persistent database for some non-trivial timespan (we actually do that for most of our mobile applications, usually for long-lived read only reference data, but one of our applications actually POSTs modified sqlite files back to server as part of normal operation, which is in fact mainly a hackish way to overcome memory limitations of the hardware involved). Using it only as data format for the transfer is hugely inefficient in terms of both time and bandwidth.
- mamcx 9y agoYes. That is why a better options is to have a kind of streamable relational format (a JSON for tables ?). The problem is that using sqlite it also embed a functional query engine, when a simple data format requiere extra layers to make it work. So even better is to have a sqlite-like engine that allow partial/streamable reading/writes.