The pattern here involves database replicas, not clones.
It's not for a single-shot test, but for continued use with data synchronization.
It's not for a single-shot test, but for continued use with data synchronization.
>A cloned database view is some representation of your database that has been post-processed to only contain data that the user is allowed to see. This representation would typically be in the form of a separate user-specific sqlite database file. Because the cloned database only contains data that is theirs, a user may issue any query against it, and there is no risk to data security. And if a malicious user was able to issue a DDL statement, it would only affect their cloned database.
Maybe there is a better word than "cloned database view." Replica doesn't feel quite right though.