# vfs systems

Sep 13, 2022
• sqlite3vfshttp
• https://github.com/psanford/donutdb
• dynamodb as a backing store for sqlite via VFS. Very neat!
• https://github.com/litements/s3sqlite
• This VFS enables reading databases from S3 using s3fs. This only supports reading operations, any operation that tries to modify the DB file is ignored.
• Inspired by sqlite-s3vfs and sqlite-s3-query.
• https://pkg.go.dev/go.gazette.dev/core@v0.89.0/consumer/store-sqlite
• The central strategy of this package is to provide a SQLite VFS implementation (https://www.sqlite.org/vfs.html) with "hooks" to record mutations of these files made by the database, as they occur, into a recovery log. Recovering a database consists of restoring the on-disk representation of the main database and associated transaction logs.
• I can't say I understand this one exactly - it mentions that it implements the consumer.Store interface, but... not what that is
• The commenter on the news.yc article says:
• Here's a particularly crazy one which offers synchronous, low-latency (millis) replication of a SQLite database to a distributed recovery log. It does this by instrumenting the file operations SQLite is making and recording their effects into the log.