Hacker News new | ask | show | jobs
by mitgraduate 2719 days ago
Can you please explain how we can access sqlite database hosted by s3 in lambda?

I 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.

1 comments

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.