2 ms·
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
by simonw 2y ago
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/ab208b18b6c3ab31ea3feb70f6502681 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/simonw/ab208b18b6c3ab31ea3feb70f6502681#/data/tasks https://lite.datasette.io/?sql=https://gist.github.com/simon...
- oever 2y agoThat format could sync well to local-first PWA using indexeddb.