[simonw]

In case anyone else is interested in seeing the schema I ran a few example commands through this and the dumped my ~/.task/taskchampion.sqlite3 database out to SQL: https://gist.github.com/simonw/ab208b18b6c3ab31ea3feb70f6502...

It's mainly JSON data stored in some simple tables, with full historic change tracking modeled as JSON too.

Here's that example loaded into Datasette Lite: https://lite.datasette.io/?sql=https://gist.github.com/simon...

[oever]

That format could sync well to local-first PWA using indexeddb.