News for hackers. Stuff that matters.
Re:In Praise of PostgreSQL by laurencerowe on Thursday August 05, 2021 @02:44PM (#28077825)
It's possible to run SQLite on an NFS share (with caveats: file locking must work correctly, WAL mode does not work at all). AWS EFS Elastic Filesystem specifically calls out its compatibility with SQLite. https://aws.amazon.com/about-aws/whats-new/2017/03/amazon-el...

I would definitely not try using this in a write heavy workload but could be interesting to consider in a write occasionally scenario.

Re:In Praise of PostgreSQL by slapfrog on Thursday August 05, 2021 @03:52PM (#28078719)
It's also possible to put a two-stroke engine on a mountain bike and ride it on a limited access highway. But that's really not what the bike is meant for, and would almost never be the right way of going about things.
Re:In Praise of PostgreSQL by marcosdumay on Thursday August 05, 2021 @03:45PM (#28078594)
I did once run SQLite on a Windows SMB share. It works unreasonably well.

At the time I was able to push it into something like 10 simultaneous write accesses (transparently serialized by SQLite). It was an adaptation of a MS Access file that would fail at approximately 5 people opening it at the same time (independently of their actual usage). Luckily I got access to a Postgres installation shortly afterwards so I didn't have to push SQLite any further.