News for hackers. Stuff that matters.

A comment on Consider SQLite. Parent comment

Re:Consider SQLite by rmbyrro on Wednesday December 29, 2021 @02:58PM (#29729264)
You can run it on AWS Lambda and store the SQLite file(s) on EBS [1].

[1] https://aws.amazon.com/blogs/compute/using-amazon-efs-for-aw...

[ Parent | on HN ]
Re:Consider SQLite by otterley on Wednesday December 29, 2021 @05:34PM (#29730987)
That's EFS, not EBS. EFS is file-level storage (i.e., NFS); EBS is block-level storage (SAN). AWS Lambda only supports EFS.
[ Parent | on HN ]
Re:Consider SQLite by rmbyrro on Thursday December 30, 2021 @06:11PM (#29742676)
Correct, I mispelled. The link points to the correct service.
[ Parent | on HN ]
Re:Consider SQLite by metaltyphoon on Thursday December 30, 2021 @03:03AM (#29734703)
I wouldn’t use a SQLite file over NFS. It has caused me locking problems when used by multiple clients.
[ Parent | on HN ]
Re:Consider SQLite by rmbyrro on Thursday December 30, 2021 @06:15PM (#29742719)
NFS does have a relatively low limit in terms of lock. For some use cases it can handle it fine.

Having clients running on read-only mode, when possible, can help.

Also partitioning the database can help, but then it's too much trouble already.

[ Parent | on HN ]