Hacker News Reader

You exchange network access against filesystem access, but what if your filesystem is a network device?

SQLite recommends not using network storage:

> You are advised to avoid using SQLite on a network filesystem in the first place, since performance will be slow

https://sqlite.org/atomiccommit.html#_broken_locking_impleme...

That's a serious limitation since many VMs in datacenters have block devices attached over network.

I think this is true for any RDBMS, though. If your block device has high latency, you will see bad perf when the DB tries to fsync.

But the block device latency is usually a order of magnitude lower (microseconds) than the network latency between the database and its clients (milliseconds), except when all clients are located in the same datacenters.

”Network filesystems” means stuff like NFS. Networked block devices should generellt be fine AFAIK.

You exchange network+filesystem access against only filesystem acess.

The server needs to store your DB somehow too.

Reply on news.ycombinator.com