5 ms·
"...has orders of magnitude less latency than..." [citation needed]. Local network access shouldn't be much different than local IPC.
by sedatk 2y ago
"...has orders of magnitude less latency than..."
[citation needed]. Local network access shouldn't be much different than local IPC.
- deleted 2y ago[deleted]
- bob1029 2y ago> Local network access In what production scenarios do MySQL, Postgres, DB2, Oracle, et. al., live on the same machine as the application that uses them? I am pretty sure most of these vendors would offer strict guidance to not do that.
- chatmasta 2y agoIt’s not a stretch to imagine that a scenario where you’re willing to run SQLite locally is also one where it’s acceptable to run Postgres locally. You’ve presumably already got the sharding problem solved, so why not? It’s less esoteric of an architecture than multiwriter SQLite.
- TylerE 2y agoLike 95% of websites that aren’t Amazon or google? Ton of sites that run in a single small vm. Postgres scales down quite nicely and will happily run in say, 512MB.
- crazygringo 2y ago> I am pretty sure most of these vendors would offer strict guidance to not do that. Then you'd be wrong. Running Postgres or MySQL on the same host where Apache is running is an extremely common scenario for sites starting out. They run together on 512 MB instances just fine. And on an SSD, that can often handle a surprising amount of traffic. As popularity grows, the next step is to separate out the database on its own server, but mostly as a side effect of the fact that you now need multiple web servers, but still a single source of truth for data. Databases are lighter-weight than you seem to think.
- immibis 2y agoIn the scenario where you were choosing between it and SQLite...
- deleted 2y ago[deleted]
- bobmcnamara 2y agoContext switches plus mmap accesses are often slower than mmap accesses.
- _1tem 2y agoI’ve tested this before and Postgres is measurably faster over Unix socket than over local network.
- badmintonbaseba 2y agoYou don't have IPC for sqlite, do you?
- nolist_policy 2y agoYou do of you access the same database from miltiple processes.
- badmintonbaseba 2y agoWhat IPC mechanisms exist between sqlite processes accessing the same database, other than file locking and some atomic IO operations ensured by the OS.