Hi Bubble Community,
Day 5 Bubble user here, and I have a few questions about database structuring. I am building an accounting dashboard where companies can upload data and visualize it on their dashboard. I wanted to reach out for some advice on how to structure the database(s), and also as a side note, (apologies for the adjacent forum topic), I wanted to see if it was possible to allow my users to import large amounts of data.
Questions 1: Should each user/company import their data into the same database or should I create a new database for each company. We are expecting each company to be able to import a new dataset every few months and it would be great to be able to visualize historic data.
Questions 2: If you have any suggestions about structuring the relational databases I would be very appreciative, still wrapping my head around how they connect to one another and the different types (data types, fields and options sets). Overall I believe it is relatively simple as I only have users and their data.
Question 3: Are there any privacy concerns I should be aware of? The data will be confidential; is Bubble a secure enough platform to host this type of app?
Question 4: Is there a way to allow users to import data? If you are familiar with the Hubspot data import, it would be fantastic to allow users to import data and show them an error count or even a similar way to visualize data errors as the current bubble data upload.