Hello bubblers,
I’m looking for a way to get a sense of which database is using up my allocated space. Bubble seems to give me the total space used by my application but it is growing faster than I would like.
So I’d like to make a page that reports the size of each database (and potentially the sum size of each “thing” inside that database.
Any thoughts on the matter would be appreciated.
I assume from your question that you’re talking about database size (rather than file storage), i.e. the number of entries in your database… in which case this should be very simple…
Just set up an admin page, then use database searches and counts to show how many entries you have in each datatype in your app’s database…
You can sum the total number of entries across all your datatypes to see how many total database entries your app currently has (obviously, as you add or remove datatypes, you’ll need to manually update this page accordingly)…
I’m not sure what you mean by 'the sum size of each ‘thing’ inside it… Bubble only puts a limit on the actual number of things in your database (not the size of the data), and only on the free plan (there are no data limits on paid plans, at least not currently).
Thanks for the reply!
Actually I am looking for the storage space that each database uses, since that is the current limitation in my plan.
While each DB record does use some amount of hard drive space, I’m assuming the largest part of this is file storage and I’m looking into using another storage solution (like uploadcare) to store the files. But since files are stored in a lot of places, it would help to find a report showing what files use the most amount of space and slowly work to store those files elsewhere.
Bubble only tells me the total App size, but no details of how that total is broken down into.
Your database doesn’t use any storage…
Your file storage is a completely separate thing from your database, and (currently at least) there is no data limit on your database size…
So, you’re asking about your file storage limits (nothing to do with your database)…
The only real way to check your file storage is in the Bubble file manager… (unless that is you’ve created a datatype already to save info about every upload, but I’m guessing you haven’t done that)…
So the best you can really do is just check your file manager…
If you want to set up some way on an admin page to find all the files from your storage that are referred to in your database, that shouldn’t be too difficult (but I don’t think you can access the file size unless you’ve specifically stored that in your database somewhere)…
Aha, got it. Thank you for the clarification. Nope, did not save the file size info since I figured in the beginning that would be something available through metadata or something.
File manager does not allow very sophisticated searches so does not satisfy my needs.
I’ll keep searching, thanks.
