Just seeing if supabase works

by mark | 27 Aug 2022, 7:48 p.m.

This blog is hosted on Heroku as it is a django (i.e., python) app with a Postgres DB that hosts all the good stuff. Heroku wanted to charge me for the DB and I didn't want to pay (I'm OK tossing them a few bucks for hosting a web app, but $10 pcm for a tiny DB with this limited content? Come on). 

There is a thing called supabase which is just cloud databases. It was incredibly easy to set up. 

• Go to supabase and spin up a DB (this was three mouseclicks to log on with github and I had to type a database name and password in)
• Follow these instructions to move your DB data from heroku to supabase
• Unattach all databases from your heroku app (bravery required - when you unattach your DB is gone forever - make sure you test your new image on supabase before unattaching the heroku DBs)
• Point your DATABASE_URL heroku setting to the URI supabase tells you to use, buried slightly deeply in the DB settings on supabase
• You have now migrated to supabase

Took about fifteen minutes.