3 ms·
The whole point of SQLite for me is to get the application code as close as possible to the block storage device without getting my hands too messy in the proce
by bob1029 3y ago
The whole point of SQLite for me is to get the application code as close as possible to the block storage device without getting my hands too messy in the process. Latency is a major reason you'd consider using SQLite. Simplicity is right up there too.
Putting the storage in the cloud is completely orthogonal to this ideology. Both latency & simplicity will suffer dramatically. I don't think I'd ever use this feature over something like Postgres, SQL Server or MySQL.
- mcculley 3y agoI have some workflows where a SQLite database is built from data sets and then used read-only by multiple processes. I currently implement this by putting the SQLite file into S3 and copying it to the machines that need it. This will save the copy step.
- codethief 3y ago> Putting the storage in the cloud is completely orthogonal to this ideology. Both latency & simplicity will suffer dramatically. I'm confused by your usage of the term "orthogonal". In my experience, it is used to express that something is independent of something else, similarly to how in mathematics orthogonal vectors are linearly independent and thus form a basis of their linear span. Here, however, it seems you mean to say that "putting storage in the cloud runs counter to this ideology"?
- caseyohara 3y agoI see "orthogonal" used quite frequently on HN. I remember reading a comment here that explained it something like: > Ironically, the meaning of "orthogonal" has become orthogonal to the real meaning because now it can mean both "perpendicular" and "parallel", both "at odds" and "unrelated" Edit: found it https://news.ycombinator.com/item?id=1997093 https://news.ycombinator.com/item?id=1997093 (my memory was pretty close)