News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by fnord123 on Thursday April 15, 2021 @12:19PM (#26822453)
Large directory sizes suck on NFS and parallel file systems like Panasas, Lustre, GPFS, and the like. Python and Rust's Cargo also suck on networked file systems and would be greatly improved by pushing things into a sqlite file.
Re:SQLite the only database you will ever need in most cases by deckard1 on Thursday April 15, 2021 @05:28PM (#26826340)
most things suck on networked file systems. I still have trauma from having to use NFS more than a decade ago, on systems that would freeze on boot because the network couldn't be reached or the NFS server was down.

I'd also never put sqlite on NFS. Locking is often broken on NFS. Unless you can guarantee a heterogeneous environment. I can imagine some Excel guy in marketing is going to launch his SQLite UI on Windows and completely hose it all.

Re:SQLite the only database you will ever need in most cases by fnord123 on Thursday April 15, 2021 @05:42PM (#26826495)
Nfs locking broken.. excel? Sqlite ui on Windows? Are you sure you're not confusing SMB with nfs? I've had SMB cache files that ducks everything up. Not nfs.