The decision behind every SaaS DB: MT or MI? Do you host everything in one large database or do you split apart your users and give each their own database?
Advantages of MI (one db per account)
Advantages of MT (single database)
- Ease of maintenance and setup
Requirements of Sealas
- Encrypted data, thus no data updates possible
- Autonomous updates from client side, whenever the client wants to update
- Client-side backups before updates
- ~ Complete separation of data between clients
When thinking about the architecture of your software project, always begin with assessing the requirements.