Migrate from Supabase to local database

[sondhg]

My question is just: Should I switch from using Supabase to using a local database if the migration is possible? How can I do that?

First I need to mention I'm not a tech person at all, so I don't know how databases, servers, hosting... all those things work.

I simply use Teldrive to backup my files to Telegram because my laptop's disk space is low (100 GB), and I have lots of media data (500 GB) to keep.

I set up Teldrive by following the documentation. I chose Supabase over local database. I didn't know the difference, I just chose Supabase because the documentation said it was the recommended method.

I spent some months doing just these things:

• Run teldrive run on my laptop
• rclone copy to backup
• Ctrl+C to end teldrive run
• Delete the local files (that I just backed up to Teldrive) from my laptop to save space.
• Turn off my laptop.

I have no other complex use like VPS or media server or anything.

Recently the transfer speed has been much slower, so I checked Supabase website. I saw some warnings about limitations and exceeded usage rate. That's why I'm thinking if I should switch to a local database.

**Is there any advantage to using a local database in my case?
**

Thank you to anyone who helps! I just don't have any experience with handling databases, and I don't want to leave the how-to for this migration process to an AI since I'm really afraid of losing my media data. I'd really appreciate any help, even a link to a relevant documentation would be awesome.

[aZuiZui]

You can definitely backup and restore the db to a local instance.

Slow speed isn't always related to your db. The db plays a part in the storage of the pointers to the file.

Accessing the files could be slow because you have hit a rate limit. Have you added bots to load balance?

I think you should troubleshooting a bit before deciding to move db or not.