3 ms·

There are ways to use a hosted SQL, or from a cloud application. I personally haven't used it. What I am curious about is if "Many Small Queries Are Efficient

There are ways to use a hosted SQL, or from a cloud application. I personally haven't used it. What I am curious about is if "Many Small Queries Are Efficient in SQLite" when using the various hosted flavors of SQLite.

claytongulick 2y ago
Nope. You get back to the roundtrip problem.
- infamia 2y ago
  The SQLite db can easily live on the same machine as the app server.
  - deleted 2y ago
    [deleted]
  - danielheath 2y ago
    > using the various hosted flavors of SQLite
    - closeparen 2y ago
      I think the "hosted flavors of SQLite" would be doing the type of trick Litestream does: streaming the WAL to other copies of the database. The copy you interact with is still local.