Home

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:

Additionally, the last inserted rowid is displayed on the SQL page, if an insert statement has been executed: