Hi,
Is there a way to take download of full DB of our apps? I am looking to take full dump of the DB and upload it to some data visualisation tools for analysing the data.
I find it cumbersome to export Bubble DB. I have many tables. And Bubble’s default views do not show columns, so we need to create views. And then export each data type one by one.
Is that the way to do it or is there a better method? I couldn’t find anything on searching in forum.
PS: Also, if I need to take an incremental dump of the DB, is it possible? i.e. Only the changes (or at least just the additional rows) since a particular date?
Because otherwise we need to see a new field gets added in between then we need to remember to add that field, change dates in all the data types and take dump one by one, which is bit slow too.
Expose all your data types via data API and scrape all of them using custom code… but the time taken setting that up will be more than the time it takes to download them all manually!
@lindsay_knowcode may support it with PlanB backups
2 Likes
Thanks.
Not much of a coder though.
Setting up the DB in the visualisation tools itself is seeming like a big task at the moment.
Try a free trial of planbbackups.io
- does a data visualisation. - mermaid, db scheme export
- backs up you bubble application export
- backs up all the data
- 1-click export to Supabase of you want to use proper BI tools (I do a lot of this, works well)
You can do it all on a free trial.
Thanks @lindsay_knowcode .
Interesting. I’ll check it out.
I need to set up Data APIs for this? Will backups taken like this be more expensive in WUs than just an excel export?
Using the Data API costs WU. No way around that. There are strategies to manage that - either only getting recently changed rows - or authenticating with a Username and password so that you can use Privacy rules to filter the data exposed in the Data API and thereby reduce the content to just what you want to be backed up.
I’d be surprised if exporting the CSV files from the Editor didn’t cost WU also. If it was a one-off export you want - perfectly viable to just go and click export on every table in the editor and then save all the exported files. TBH that’s what made me create PlanB - I had a project where it needed daily complete extracts from lots of tables.
Regard incremental exports -these are the options
Also for visualization - look at @rico.trevisan cool thing https://forum.bubble.io/t/beta-give-me-a-url-and-ill-visualize-your-entire-database/288597
2 Likes