Now that Bubble has so many database integration options (Blockspring + Google Sheets, Database plugin, etc.), I’m having a hard time deciding what to use
Does anyone have any opinions or positive/negative experiences to share?
The use-case is a simple data visualization:
I have a data viz of health and demographic data (so it’s not small by any means, but I don’t need to scale it). The dataset doesn’t need to be modified, but I’d like users to be able to play with different filters.
For now, I’ve stored the table on my Bubble app and have been using “Search for…” in Bubble’s frontend to filter the data. However, when I try to do slightly more complicated calculations (ie, find the largest number in the set and divide all other numbers by it, to resize the bar chart’s bars [not using the Data Charts plugin for aesthetic reasons] ) it really slows down the website, since I manually had to create a workflow that compares all the numbers one by one and arrives at the largest (yeah, so clunky, but I was foolishly trying to arrive at a quick fix).
Doing these calculations at the query stage will make it faster, I’m sure …
Are there any opinions out there about which solution (of all the ones available to Bubble users) is the least workflow-intensive and cheap (ideally, free?)