Say, I have an Article and Comments in a relational database. A Comment can be approaved or not approaved. To query a list of approaved Comments I can do a query
select * from comments where status = 'approaved'
select * from comments where status = 'not_approaved'
I don't store
not_approaved separately in 2 different tables as I can always request them dynamically.
In Holochain on the other hand, as far as I understand, I'd have to store Comments
not_approaved separately using "link_entries"
1) Is this correct? Is this the only correct and recommended way?
2) How would I do it exactly?
3) How then would I move/updated a Comment from
not_approaved and vise versa?