Do all the things like ++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatarSign Up
vane758516duse graph database then
postgres have agensgraph
@sweetnothings how to explain this without the people I work with finding me🤔
Essentially it is a configurable set of rules stored in the database which the business can create, change, and enable / disable at will without notice.
When applicable records are updated the are checked against this dynamic list of rules which the code does not have any working knowledge of the actual rules, but there is predefined criteria of when the rule would apply in different scenarios, and to only evaluate the appropriate rules and proceed or fail (there could be 0 rules or 100 rules applicable to the current state of the record)
So to save on database queries I need to generate a map of all the rules in a searchable manner, while keeping in mind this map could be used against many records at a time in different states.