To build a web app that lets users (car owners) check their car license plate to see if they qualify for a holiday incentive. If their car is on the list, they sign up and answer a few questions to validate incentive entitlement. (no, this is not a scam)
Access a database of a few hundred thousand lines (will start with a sample db of 100 records first) so that car ownership details can be verified via the web app. The app will need to support users who wish to update contact details without overwriting existing records. Keep safe.
The above probably sounds pretty easy, and maybe it is, if you know what you are doing… But I am a non-coder and new to Bubble and need to figure it out. I am assuming Bubble can handle this. Please correct me if I am wrong.
(1) Excel —> CSV
At the moment, I don’t have a database, I just have the Excel spreadsheet. I know how to export it to a CSV file, so that much is okay, but I don’t know how to prepare it for Bubble after that step.
(2) Create MySQL database
Should I create a MySQL database on my Mac and upload it? Or should I create one on the hosted service I use for my Wordpress site? There is a facility to use the cPanel to create a MySQL database. Would that be a good plan?
(3) Point to database
Once the database is created, how do I point Bubble/Blockspring to it so that it can be accessed?
(4) Do I need to subscribe/pay Blockspring for this part?
I have a clean slate, there is nothing done yet, so what is the simplest way to get the db ready so that Bubble can use it? I hope I don’t need to engage a consultant for this step, so all tips appreciated. As stated above, I am a non-coder and brand new to Bubble — but feeling optimistic I can tame this beast