Hey folks, I'm new to Supabase and have a high-level question: how would you store arbitrarily large strings? (In this case, assume they are potentially large text files, e.g. text from chapters in a book.) I'm thinking these should probably be stored as external asset files using Supabase Storage (bucket) rather than within the realtime (Postgres) database. Is that what you would do?

Hello @appurist! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

I think that all depends on what you will do with the data. I think a book is 2M or so, so chapters 200K or less. The database can easily handle that if you need to access quickly, search text, organize, etc. in a pure text format. If it is easier for your app to deal with fetching with urls and processing files then storage is the way to go. The tradeoff is if you have a lot of "books" then the cost of storing that data is 6x of putting on storage. Download cost is the same. The $25 plan includes 8G of database before extra charges, so alot of books. https://supabase.com/pricing

appurist (2022-04-17)