3 ms·

Isn’t this what datomic does? It’s incredibly useful to be able to reference the full state of the database as of some fixed point in time.

• 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 ago
    If 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 ago
      Saner 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 ago
    There'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.