Note to self on setting up Ghost with SQLite3 in production (Ghost only officially recommends and supports MySQL in production, so figuring this out was a bit of an effort).
Environment Setup
- Install the latest required NodeJS version (see https://ghost.org/docs/faq/node-versions/)
- Install nginx:
sudo apt install nginx -y
(apt, assuming a Debian-based Linux distribution) - Install ghost-cli:
sudo npm install ghost-cli@latest -g
Setup Commands
$ mkdir /var/www/my-site
$ sudo chown <user>:<user> /var/www/my-site
$ sudo chmod 755 /var/www/my-site
$ cd /var/www/my-site
$ ghost install --db sqlite3
Other helpful ghost commands
$ ghost config [get | set] <key>
$ ghost backup
$ ghost restart