I have a bubble app that I used during last year where I make use of a large database that I upload via CSV upload. This, as you all know, can take a lot of time and it’s not optimal if you need to update the database regularly.
I’m now planning to scale up my app, so I will need to manage more and more lines on the database (~10million lines) and this would take a lot of time.
In addition to that, I have to perform some actions on my DB before uploading it to bubble so that it resembles the various ‘Types’ of my bubble database (kind of making it relational creating different files for every type).
I was thinking about moving my DB to MySQL and to make calls directly from bubble, this making it easier and faster to upload and update my DB. I will have to run queries with no more than 30 results but I will need to read and write quite often from the DB.
I am, by the way, a bit scared that this will bring performance issues to my app.
What do you think about it?
How is the MySQL api working?
Do you have any other suggestion?
Thanks a lot,