about summary refs log tree commit diff
path: root/src/libstore/schema.sql
AgeCommit message (Collapse)AuthorFilesLines
2010-02-24 (no commit message)Eelco Dolstra1-1/+1
2010-02-22 * The database needs a trigger to get rid of self-references toEelco Dolstra1-0/+10
prevent a foreign key constraint violation on the Refs table when deleting a path.
2010-02-22 * Put the derivation outputs in the database. This is useful for theEelco Dolstra1-0/+10
garbage collector.
2010-02-19 * Foreign key support in SQLite is not a persistent setting, so enableEelco Dolstra1-3/+1
it at startup. * Implement negative caching. Now `make check' passes.
2010-02-18 * Add the deriver to the ValidPaths table. In principle we could nowEelco Dolstra1-1/+2
store all the derivers of a path efficiently. But that opens a big can of worms with respect to garbage collector semantics.
2010-02-18 * Assign an integer id to every row in the ValidPaths table in orderEelco Dolstra1-12/+9
to make the Refs table more space-efficient. For instance, this reduces the size of the database on my laptop from 93 MiB to 18 MiB. (It was 72 MiB with the old schema on an ext3 disk with a 1 KiB block size.)
2010-02-18 * Convert the Nix database to SQLite.Eelco Dolstra1-0/+27