Re:How the SQLite virtual machine works
by rrdharan on Wednesday September 07, 2022 @08:10PM
(#32759171)
Uber, on Google Cloud Spanner, seems to be in this ballpark though they aren’t quite explicit about it:
https://www.uber.com/blog/building-ubers-fulfillment-platfor...
Re:How the SQLite virtual machine works
by kasey_junk on Wednesday September 07, 2022 @09:56PM
(#32760070)
Spanner is explicitly sharded. Sort of famously so.
Re:How the SQLite virtual machine works
by rrdharan on Thursday September 08, 2022 @12:50AM
(#32761311)
All scale out databases use some form of sharding, tautologically.
The parent asked about use cases where there wasn’t an _external_ (which I interpret to mean “handled explicitly by the app, not the database”) sharding / caching layer.
Spanner internally handles splits based on load / size.
That having been said, more careful reading of the Uber post shows that they still do employ additional app-level explicit sharding to resolve hot-spots, so it’s probably a fair point that this doesn’t qualify as an example the parent was looking for.
Re:How the SQLite virtual machine works
by endisneigh on Wednesday September 07, 2022 @08:56PM
(#32759611)
A few vendors doing time series data. Even if you lowered it a couple orders of magnitude. I haven’t seen any app doing even 5K concurrent writes backed by SQLite.
Re:How the SQLite virtual machine works
by kasey_junk on Wednesday September 07, 2022 @09:55PM
(#32760061)
What time series vendor is offering high write throughput consistent sql?
Legitimately interested as this is something I have more than a little professional interest.
That said, “show me an app doing 5k concurrent writes with SQLite” seems like a much more reasonable standard.
I don’t think your example is a good fit for SQLite as it’s not a good fit for any sql store that I know of.