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.

Collapse
 
honza_kadlec profile image
Honza Kadlec

You can self host and use coolify.io.

Collapse
 
bytefroze profile image
Putra Fajar Hasanuddin

Hi, how about migrations?

Collapse
 
realbuddy profile image
DanielL

@jacobandrewsky it looks like getQuery doesn't work on Vercel
Locally everything is working just fine
Am I missing something?

Collapse
 
jacobandrewsky profile image
Jakub Andrzejewski

Hey, that is strange. getQuery is a built in feature of Nuxt so it is not related to the project I have built. Could you check in the Nuxt repository for similar issues?

Collapse
 
realbuddy profile image
DanielL

Thank you
It was because of ISR
For some reason query params don't work on vercel with ISR