DEV Community

Cover image for Taking Nuxt to the Backend with Supabase 🚀

Taking Nuxt to the Backend with Supabase 🚀

Jakub Andrzejewski on January 08, 2024

Two months ago, I was giving a talk at Nuxt Nation which is currently my favourite online conference related to Vue.js. This time, I decided to spe...
Collapse
 
aloisseckar profile image
Alois Sečkár • Edited

Question - is there a way to manually export current Supabase contents into SQL? On free tier? I don't mind they don't offer automatic backups for free, but I would like to do a manual one from time to time. But I only found CSV exports.

Collapse
 
jacobandrewsky profile image
Jakub Andrzejewski

Heym thanks for the question. I dont have an answer yet (I asked it in the Supabase ambassadors channel) and I will get back to you when I will have it.

From my knowledge, the CSV export is the only option but I will confirm that :)

Collapse
 
jacobandrewsky profile image
Jakub Andrzejewski

I got the info back:

They could just use pg_dump, I think even the CLI officially supports this too. You can find the docs for the CLI here https://supabase.com/docs/reference/cli/supabase-db-dump, there is a --data-only tag to dump just the data and not the schema too.
Enter fullscreen mode Exit fullscreen mode
Thread Thread
 
aloisseckar profile image
Alois Sečkár

Thank you for investigating :)

Collapse
 
aloisseckar profile image
Alois Sečkár • Edited

I fully agree with Supabase being easy to use and I have it on several project. However, I am not sure about scaling it up for a real production apps.

I already hit the limits of free tier - only 2 separate organizations = databases, it allows file uploads, but only 1 GB, so for storing images I am moving to Cloudinary. And $25 monthly PER ORGANISATION sounds a bit too much for non-commercial apps.

I will eventually give $20 monthly to Netlify to host ALL my websites, but I would rather spend some time researching how to set my own PostgreSQL server somewhere in cloud.

I agree simplicity comes with a price. But for me it seems too high here. However, I find supabase great for small apps or for learning stuff.