Yeah what you're talking about with memcached spilling to the SSD for an extended cache is sort of what I was thinking about.
Bit surprised that isn't already much more common of a pattern.
And yeah, I'm a fan of sqlite whenever it can be used, then postgresql when you need some beefier.
A frightening about of Amazon ran on pre-chewed-up BDBs that were pushed out to every server that needed them (originally to literally every webserver, then pushed out to every server in a microservice cluster), effectively as caches in front of SQL databases. Using sqlite these days should be much better than that since BDBs were buggy and awful.
Bit surprised that isn't already much more common of a pattern.
And yeah, I'm a fan of sqlite whenever it can be used, then postgresql when you need some beefier.
A frightening about of Amazon ran on pre-chewed-up BDBs that were pushed out to every server that needed them (originally to literally every webserver, then pushed out to every server in a microservice cluster), effectively as caches in front of SQL databases. Using sqlite these days should be much better than that since BDBs were buggy and awful.