Small stand alone application for periodially grist backups (sqlite, xlsx, csv)

Showcase
#1

I’ve build a small stand alone application that downloads/exports
your Grist documents for periodically backups.
It works with hosted and self hosted grist.

The reason i build it is, that we need to do “tamperproof periodically snapshots” of our documents,
to be archived for 10+/30+ years (gene modified organisms database), so this tool can download the documents in all three formats, to hopefully be still readable in these 30+ years.

11 Likes
What is the best way to backup Grist data?
January 2023 Newsletter - Grist en Français, Español, Português und Deutsch! Plus expanding widgets and access rules improvements
#2

Thank you for this! Very cool.

#3

Looks great, need to try it out!
Thanks very much for sharing!

#4

that’s super cool :+1:,
what’s this part of the config file does , is it the name of tables in Grist we wanna download ?

[csvtables]
Table1
Table2
#5

In contrast to sqlite and xlsx, csv only downloads one specific table.
So in the [csvtable] section you tell the tool which tables you want to download as csv.

1 Like
#6

I’ve created a new release:

  • v0.3.0
    • Added logging
    • Do not create files in case of an error.
    • create config.ini in case its missing
    • In case of an error the application quits with an return code of “1”.
    • Added linux builds
      • amd64
      • arm
      • arm-linux-gnueabi
      • arm-linux-gnueabihf