3 ms·
Author here! I would say the main advantage is that this just needs uploading a single file to S3. `sqlite-s3vfs` will split the database in pages and upload th
by polyrand 4y ago
Author here! I would say the main advantage is that this just needs uploading a single file to S3. `sqlite-s3vfs` will split the database in pages and upload the pages separately to a bucket prefix.
Having just a single file has some advantages, like making use of object versioning in the bucket[0]. I also think that relying on s3fs[1] makes the VFS more flexible[2] than calling `boto3` as `sqlite3-s3vfs` does.
[0]: https://s3fs.readthedocs.io/en/latest/index.html?highlight=version#bucket-version-awareness https://s3fs.readthedocs.io/en/latest/index.html?highlight=v...
[1]: https://s3fs.readthedocs.io/en/latest/index.html https://s3fs.readthedocs.io/en/latest/index.html
[2]: https://s3fs.readthedocs.io/en/latest/index.html#s3-compatible-storage https://s3fs.readthedocs.io/en/latest/index.html#s3-compatib...
- remram 4y agoI see. The drawback of course is that you don't support writing. So there are for completely different use cases, thanks!