Or just use SQLite backed by S3. Most latency is to the data center. No need for DynamoDB billing overhead. Cache 5mb or so of most frequent static data in the Lambda.
SQLite is just a flat file database format. You can use stock Rust, Python, C++ SQLite client. Probably want to shard the SQLite files to prevent hot spots on write locks. Use a quadtree for geospatial sharding.
6 comments
[ 4.1 ms ] story [ 35.1 ms ] threadI googled it but it seems s3 is only for hosting static files and it will not be possible to directly query Sqlite DB on s3.
Only issue is transactional writes, but those can wait for S3 write confirmation in the lock.
For example bank statement, ok to read from S3 SQLite file. Actual credit/debit you must use locking.