Hi there, I am evaluating Adalo 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 Adalo 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 log in 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 Adalo, 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 Adalo? Build it brand new in Adalo and manually import all of the records? 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 Adalo sales/tech person if need be.