When storing a tree in Postgres, should I use a recursive query to find all parents and children, or store...
up vote
0
down vote
favorite
I'm storing a tree of small strings in Postgres. It looks like this: "Languages" | |--- "French" | |--- "Verbs" |--- "Pronunciation" |--- "German" | |--- "Pronunciation" |--- "Cuisine" "Music" | |--- "Guitar" |--- "Voice" | |--- "Breathing Exercises" "Reminders" "Vehicles" | |--- "Car" | |--- "Road Rules" | |--- "Fines" |--- "Highways" |--- "Bike" | |--- "Repair Guide&