** Spoiler Alert, this site is Ghost, running on Fly.io **

Up until recently I have been hosting my blog as GitHub pages. They work well enough and it doesn't make a lot of sense to pay for something. However, recently Ghost announced that it was working on federation and this had me reconsider using it (I tired it several years ago).

It's considerably better than the previous time that I used it – enough so that I've started this site. Well, not this exact site... in my first attempt I setup the application using SQLite as suggest by a couple tutorials. Which works, isn't ideal for a production site.

When setting up Ghost you can only pick from MySQL or SQLite for database options. They don't do Postgres. Fly on the other hand, doesn't directly support MySQL.

So here are my notes on how I got it all working.

This post is for subscribers only

Sign up now to read the post and get access to the full library of posts for subscribers only.

Sign up now Already have an account? Sign in