4 ms·

Why would you do that? There is significant cost and no obvious benefit in fragmenting data into minuscule database files.

• formerly_proven 6y ago
  Each tenant having a physically separate database makes it much easier to reliably implement cross-tenant data-safety and access controls.
  • yread 6y ago
    Exactly. I know a SaaS that does this with MySQL.
    • attilakun 6y ago
      Do you have a link? I'm considering trying this with SQLite but I'm a bit worried about maintenance.
      • leesalminen 6y ago
        I did this at my former SaaS company with MySQL. I just wrote some scripts to help manage them. We had a script to implement schema changes, one to query across all the schemas and aggregate results, one to move schemas between database clusters, and one to delete a schema. I was satisfied with our capabilities and enjoyed the peace of mind that it would be impossible for a tired developer (me) to write a user-facing query that could expose other customer data.