4 ms·
Web-based makes it simple. But we need to run serverside code which connects to DB. But auth & auth can be externalized. If Desktop client, it has to support ma
by the_arun 6y ago
Web-based makes it simple. But we need to run serverside code which connects to DB. But auth & auth can be externalized. If Desktop client, it has to support mac, windows & linux. And use auth & auth of DB. Another thing is, if it has to support multiple types of DB, eg MySQL, Postgres etc., it will get complex.
- vioberoi 6y agoThanks! Any ideas on handling auth details on server side?
- the_arun 6y agoServer side - we may need auth (google/github), roles and permissions - Roles - this could be as defined by DBAs. Admin, Developer, Analyst - is what I could think of at a high level. Permissions - We could define this at a table/view level. For eg. if you are developer, you could modify read/write these tables. If you are analyst - you could only read these tables. etc.,
- the_arun 6y agoBy the way thanks for asking. I guess this is turning out to be a cool project for High Schooler/Intern or anyone a pet project. Great job on the idea!