lynxline.com - LYNXLINE LABS | Software Experiments with Fun & Inspiration

Description: Software Experiments with Fun & Inspiration

Example domain paragraphs

SQLite is wonderful!

Just today I found that SQLite support queries with a recurse to get the inner sub-trees:

CREATE TABLE els ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL UNIQUE ,pid INTEGER DEFAULT NULL REFERENCES els ,name TEXT ); INSERT INTO els (id, pid, name) VALUES (1, NULL, 'top'); INSERT INTO els (id, pid, name) VALUES (2, 1, 'x2'); INSERT INTO els (id, pid, name) VALUES (3, 1, 'x1'); INSERT INTO els (id, pid, name) VALUES (4, 3, 'y2'); INSERT INTO els (id, pid, name) VALUES (5, 3, 'y1'); INSERT INTO els (id, pid, name) VALUES (6, 1, 'x3'); INSERT INTO els (id, pid, name) VALUES (7, 6, 'w2'); INSERT INT

Links to lynxline.com (1)