Re: [sqlite] Some questions on hierarchical data (nested set model)

Jef Driesen wrote: I want to store a tree in an sqlite database. My first choice was the adjacency list model: CREATE TABLE tree ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, parent_id INTEGER ); But this method requires multiple queries to display the entire tree (or a

Re: [sqlite] Some questions on hierarchical data (nested set model)

I am very interested in hearing on this as well. A recommendation has been Joe Celko's book "Trees and Hierarchies in SQL for Smarties" (. I have

[sqlite] Some questions on hierarchical data (nested set model)

I want to store a tree in an sqlite database. My first choice was the adjacency list model: CREATE TABLE tree ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, parent_id INTEGER ); But this method requires multiple queries to display the entire tree (or a subtree) in my GUI (a gtk+