3 ms·
The pattern here involves database replicas, not clones. It's not for a single-shot test, but for continued use with data synchronization.
by rmbyrro 3y ago
The pattern here involves database replicas, not clones.
It's not for a single-shot test, but for continued use with data synchronization.
- Supply5411 3y agoFrom the post: >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.
- rmbyrro 3y agoI think your use of database clone looks fine in the context you write about. I don't think it applies to the context fly.io is writing about. Your post is about something that seems like a different pattern, I think.