I'm going to try some versioned database stuff out for a project I am developing, and needed a local install of Dolt to try it out. I have a Synology unit keeping me safe from coffee-induced panic, so I thought I'd give it one more task.

I used Docker to do it, as Dolt has an easy setup guide for that, and combined it with the learning in this article.

It's pretty straight forward:

  • Use Container Manager on the Synology to download the dolthub/dolt:latest image
  • Use File Station to create a new dolt folder wherever you keep your docker data (/docker/dolt for me)
  • In Container Manager, under Containers, select Create and then go through the wizard pretty much choosing the defaults:
    • On the first tab, select "Enable auto-restart"
    • On the second tab choose local ports, and map /var/lib/dolt to your Synology dolt folder (eg /docker/dolt); also set the environment variables for MYSQL_ROOT_HOST (%) and MYSQL_ROOT_PASSWORD (whatever you like)
  • Create and run the container

Quite quickly you should be able to connect to your NAS IP/host at the port you chose, with username root and the password you chose using TablePlus or mysql_cli.