Hi there, I am evaluating Bubble for the replacement of an old Flash-based app I wrote 10 years ago. I’m trying to understand its database situation and whether or not Bubble will work with what I need to do. I’m currently connecting with a mySQL database.
I have 250 clients. These clients are photographers/videographers. In its most simple form, each client has a unique login credential. When they log in, they keep track of the personal details of each person they ever photographed… basic stuff like Name, Address, Birthdate, etc. They’ll create new records, update, delete, etc.
If I started building this in Bubble, I would need to make sure that these clients’ user credentials are already in place, and when they log in they can only see their own personal records. In mySQL I have a database for each client, and each database has about 10 tables. They are all the same in structure, but each client accesses their own personal database to manage their information.
How should I link this information into Bubble? Build it brand new in Bubble and manually import all of the records? Or is Firebase a better solution in order to get that real time data updating across all platforms. If so, how do I create 250 unique databases that are all identical yet when a client logs in with their credentials they are directed to THEIR own personal DB?
I’m just trying to get some advice on how to start something as I describe. I would love to talk to an Bubble sales/tech person if need be. If I can get a grip on the best approach I would to begin working on this.