Since SQLite is perfect for use in single-user desktop utility applications and since such applications typically store hierarchial data (tree) in a single table, it would be nice to have support for special features like connect by of oracle.
See: http://www.adp-gmbh.ch/ora/sql/connect_by.html -- View this message in context: http://www.nabble.com/Managing-trees-in-the-database-t1135555.html#a2974277 Sent from the SQLite forum at Nabble.com.