4 ms·
It's also a really nice combo for simple automation lambdas that need some state and you want an ergonomic DB without paying for full RDS. Go + Lambda + EFS +
by cube2222 4y ago
It's also a really nice combo for simple automation lambdas that need some state and you want an ergonomic DB without paying for full RDS.
Go + Lambda + EFS + SQLite work great for that.
- davidjfelix 4y agoDo you limit concurrency to 1 with this setup?
- cube2222 4y agoYou can, though then you get errors when invoking the Lambda too much at the same time. Just letting it block on SQLite db opening should be good enough.
- davidjfelix 4y agothere aren't any issues with having multiple lambdas opening the same sqlite file?
- markusw 4y agoSQLite is designed for concurrent access to the same db from multiple processes. All relevant locking happens in the DB file itself.
- davidjfelix 4y agoMy concern is mostly around EFS consistency. SQLite concurrency locking is only as good as EFS file consistency. I wasn't sure if you had to work around any oddities of NFS. https://twitter.com/benbjohnson/status/1360592483969810443?lang=en https://twitter.com/benbjohnson/status/1360592483969810443?l...
- lormayna 4y agoIt's not relational, but MongoDB has a generous free tier. Or maybe you can use Aurora Serverless, it's in the free tier as well (but it's designed for different use cases).
- emadda 4y agoDo SQLite write locks work properly over EFS with many concurrent instances? https://www.sqlite.org/useovernet.html https://www.sqlite.org/useovernet.html
- cube2222 4y agoYes, since 2017: https://aws.amazon.com/about-aws/whats-new/2017/03/amazon-elastic-file-system-amazon-efs-now-supports-nfsv4-lock-upgrading-and-downgrading/ https://aws.amazon.com/about-aws/whats-new/2017/03/amazon-el...