Ben Johnson
Ben Johnson
## Overview Key translation currently supports the mapping of string keys to an autoincrementing integer value that allows us to map onto Roaring bitmaps. The basic functionality works well but...
Posted from the Discussions page: I just tried restoring a database from S3 and ran into an interesting error message: ``` cannot find max wal index for restore: missing initial...
Previously, a reconnecting replica would reset its position's "offset" to the beginning of a given WAL file in an effort to be more conservative about what was replayed. However, the...
Litestream v0.4.0 adds low-latency, live read replication via an HTTP endpoint. However, it could also be useful for users to have higher latency replication via cold storage (e.g. S3) when...
Per discussion with Keoni Gandall, it could be useful to distribute incremental updates for large public SQLite databases over torrent. This needs investigation to see whether this is actually a...
Litestream doesn't currently use timestamps in its log messages because timestamps are usually attached by the supervisor (e.g. `systemd`). Adding a flag to enable timestamps would be helpful for some...
The default `time.ParseDuration()` doesn't allow for units of days or weeks. Litestream should reimplement the function but add support for these units.
While SQLite recommends against NFS usage because of broken lock implementations, it seems that locking has improved in NFS v4 & v4.1. If SQLite can work on recent NFS versions,...
Currently, the `file` replica only supports snapshots with a stream of WAL files. This works well but can cause longer restore times because all WAL files must be replayed. Instead,...
While Litestream performs physical replication of WAL frames, it would be useful to derive logical changesets from those physical pages. This could be done by using the [Ptrmap pages](https://www.sqlite.org/fileformat.html#pointer_map_or_ptrmap_pages) to...