Skip to content
mibtester edited this page Sep 22, 2016 · 18 revisions

What is new in this fork of sqlitebrowser?

I added a docking-window, which allow to visualize tables, which contain a tree-like structure. Take for instance the example from the sqlite3 documentation:

CREATE TABLE org(
  name TEXT PRIMARY KEY,
  boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);
INSERT INTO org VALUES('Bob','Alice');
INSERT INTO org VALUES('Cindy','Alice');
INSERT INTO org VALUES('Dave','Bob');
INSERT INTO org VALUES('Emma','Bob');
INSERT INTO org VALUES('Fred','Cindy');
INSERT INTO org VALUES('Gail','Cindy');

The relationship between the records can now easily be viewed with the tree-structure viewer:

3An image showing the above database in the tree-structure viewer.

Welcome to the sqlitebrowser wiki!

Clone this wiki locally