What if I have a table of 'nodes' - and, in my Postgres db, want to also store a 'graph representation' of these nodes, to be used mainly on the client side (and using a specification like https://github.com/jsongraph/json-graph-specification).
I realize nodes could be deleted, and the JSON could still reference them, but couldn't that be sorted out on the client side (if they don't exist, remove from JSON and sync back).
It allows me to use existing infrastructure to then allow users to create a mindmap of nodes, without having to go through the headache of using some other (perhaps graph) database (the nodes in my case represent something important within the application).
I classify myself as a novice, so if anyone would like to advise me on this, it'd be much appreciated.