2 ms·
Is there a benefit over the existing S3 VFS sqlite3-s3vfs,which also uses APSW?
by remram 4y ago
Is there a benefit over the existing S3 VFS sqlite3-s3vfs,which also uses APSW?
- 8organicbits 4y agoSee: https://github.com/litements/s3sqlite#alternatives https://github.com/litements/s3sqlite#alternatives
- polyrand 4y agoAuthor 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!