sqlite-undo

[rcarver]

https://github.com/latentco/sqlite-undo

Just wanted to share a library we put together for undo of SQLiteData. Setup is intentionally modeled after SyncEngine

prepareDependencies {
  $0.defaultDatabase = try! appDatabase()
  $0.defaultUndoEngine = try! UndoEngine(
    for: $0.defaultDatabase,
    tables: Article.self, Author.self
  )
}

Then you simply wrap any operations you want to be undable.

try await undoable("Set Rating") {
  try await database.write { db in
    try Article.find(id).update { $0.rating = 5 }.execute(db)
  }
}

The implementation is based on the SQLite Article for undo/redo, with some tweaks to make it play nice with triggers.

We just shipped it in a Mac app using TCA, so it's in production but probably still evolving. Would love to know if it works for others.

Note: our app doesn't use sync (yet) so it hasn't been tested for those scenarios.