Am 04.03.2012 10:31, schrieb Kit:
2012/3/4 Christoph P.U. Kukulies<k...@kukulies.org>:
Thanks for the ideas. The problem is with md5sum clashes: all files with 0
bytes have the same md5sum.
Also files with same contents have the same md5sum but may have a different
name.
That's no problem. if you put names to another table, you may share one content.
Normalize. One cell, one atomic information. You may use md5sum as
"text primary key" or you may define PRIMARY
KEY(filename,md5sum,size).
Interesting. How would that work syntaxwise? I mean, at table creation time?
CREATE TABLE dir(filename text, md5sum text, size int, content blob,
PRIMARY KEY(filename,md5sum,size));
Filename, version, date and size put to another table with md5sum as a
foreign key. Inspire with Git system or use it.
I will have a look at Git.
Christoph
If you planning version control system, you may select from completed
systems, eg. Subversion, Git, Mercurial and Bazaar.
Thanks for the above. Actually, I'm not planning a versioning system.
I'm planning a database based testsuite.
At the moment I have everything in the filesystem. The test situation is
that about 500 testprograms have to be run
with product release N against product release N-1. The test programs
are duplicated at the moment in all
places. The deployments of product release builds N, N-1, N-2 are also
in the filesystem.
If I boil it all down from, say 60 GB to 2 GB (as my first attempts
resulted in), I could generate the testbed on the push
of a button out of the database and assemble it in a tree with two
branches, the "new candidate" branch and the "reference" branch,
run the tests. That all could be web app based in the end.
Just a question on "NORMALIZATION": Is normalization being done on a
database by some operation, like
giving a command: "normalize it" or is it done by design of the data
structures being entered?
--
Christoph
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
