cra-express-sqlite-fly

Local dev

# using node 16
git clone git@github.com:facutk/cra-express-sqlite-fly.git
cd cra-express-sqlite-fly/api
npm start

# in other terminal
cd cra-express-sqlite-fly/api
npm start

flyctl auth login

get fly token

flyctl auth token

add fly secret

flyctl secrets set SENDINBLUE_USERNAME=<your-email>
flyctl secrets set SENDINBLUE_PASSWORD=<your-password>

Configure fly.io secret at https://github.com/facutk/cra-express-sqlite-fly/settings/secrets/actions

test github actions locally

brew install act

then run

act --secret-file .env

volumes

Make sure you have a volume

flyctl volumes list

If no volume is listed, check your region

flyctl regions list

And then create your volume

flyctl volumes create data --region scl --size 1

Preview

https://morning-surf-1780.fly.dev/

sqlite

https://sqlitebrowser.org/dl/ https://sqlite.org/fiddle/index.html