I think in the past it was more obvious. Rails switched to SQLite as the default somewhat recently

Yeah, that's the one prominent example but, like you said, also just rather recently. Since "the network is slow, duh" has always been true, I wonder why.