Please i need some expert feedback on that.
i am planning to build a set of tools for project management within one container in our case it is (Pages).
i really see the Pages are promising for my project but i am really confused about its data limits.
i am planning to have different Clients owns different projects, the inventory module can consume almost 20k row per Client, and Inspection module will consume from 25k to 50k row per project and so on for budgeting module and project specifications and drawing module.
Logically, the data for each owner MUST NOT expose to other Clients, so each client has his own data and also each project data will not be exposed to the same client’s project except for the top management. which they will require reports and overall.
Kindly advise on the best structure to accommodate that scenario of my next project to fit with Glide.
i may split the entire project tools to be a copy of the same (Pages or app) for every different client, but that will be a real headache to manage many apps of the same identical structure for each client.
i am using google sheets for the time being just to construct the base and functionality, but i may shift to Mysql platform when growing as planned.
is it easy to shift from glide based on google sheet to Glide based on Mysql ?
actually, it is many questions, sorry for that.
However, your advise will help me to procced and plan the overall structure.