This allows us to import and export multiple data at the same time: dashboard (files), docs, terms, etc.

And I think it doesn't require much rewrite since we have the base table in CSV/TSV already, we just need to pack it into sqlite.

The import could support "partial" data, i.e. if docs table is there, import it, if not, just skip.

We could even export whole corpus with sqlite.

Possibilities are numerous and the format is very versatile. With sqlitebrowser or dbeaver it's also easily inspectable and editable.

https://www.sqlite.org/appfileformat.html

https://www.sqlite.org/aff_short.html