datahike 2022-01-31 | Slack Archive

what’s the best way to find orphan entities, i.e. entities without existing `db.type/ref` relationships?

You can query for them. 🙂 Something like:

:where
[?e _ ?possible-ref]
(not [?possible-ref])

(Did it on the go. Maybe this is not entirely correct, but I guess it's close enough)

Hm.. No. My query above would query for entities, that do not have a ref to other entities.

:where
(not [_ _ ?your-entity])

That would do it.

2022-01-31