2012/4/16 Puneet Kishor <punk.k...@gmail.com>: > I am experimenting with a home-grown versioning system where every > "significant" modification to row would be performed on a copy of the row, > the original being preserved. > Any other suggestions to achieve a similar functionality would be welcome. > -- > Puneet Kishor
1. Use Git or Mercurial 2. Try this: CREATE TABLE instance ( filename TEXT, version INT, size INT, md5sum TEXT, creation_date TEXT, last_write_time TEXT, PRIMARY KEY(filename,version), FOREIGN KEY (md5sum) REFERENCES resource (md5sum) ); CREATE TABLE resource ( md5sum TEXT, data BLOB, primary key(md5sum) ); -- Kit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users