4 ms·
Duplicating complete database not so helpful if need to grant access to specific subset of data in database (note: database incorporates multiple tables).
by sargstuff 3y ago
Duplicating complete database not so helpful if need to grant access to specific subset of data in database (note: database incorporates multiple tables).
- 1659447091 3y agoIf I understand correctly, Datomic has filters[1] for that; to remove some data from the db before returning it for use. [1] https://docs.datomic.com/pro/time/filters.html#filtering-for-security https://docs.datomic.com/pro/time/filters.html#filtering-for...
- sargstuff 3y agoSaner alternative to copy/exec[0], if not as portable. [0] : https://medium.com/r3d-buck3t/command-execution-with-postgresql-copy-command-a79aef9c2767 https://medium.com/r3d-buck3t/command-execution-with-postgre...
- ilikehurdles 3y agoThere's no duplication involved. It's an immutable database with an eavt (entity, attribute, value, time) index model. Pick a point in time to filter entities existing only at that point. It's effectively a read-only pointer to the full db created for free after every transaction.