Re: [sqlite] TEXT PRIMARY KEY

2012/3/4 Christoph P.U. Kukulies : >> CREATE TABLE dir(filename text, md5sum text, size int, content blob, >>    PRIMARY KEY(filename,md5sum,size)); > > Coming back to your suggestion using PRIMARY KEY(filename,md5sum,size), how > would I address this PRIMARY KEY, example: > >

Re: [sqlite] TEXT PRIMARY KEY

Am 04.03.2012 10:31, schrieb Kit: 2012/3/4 Christoph P.U. Kukulies: 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

Re: [sqlite] TEXT PRIMARY KEY

2012/3/4 Christoph P.U. Kukulies : > 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

Re: [sqlite] TEXT PRIMARY KEY

Am 04.03.2012 10:31, schrieb Kit: 2012/3/4 Christoph P.U. Kukulies: 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

Re: [sqlite] TEXT PRIMARY KEY

2012/3/4 Christoph P.U. Kukulies : > 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

Re: [sqlite] TEXT PRIMARY KEY

Am 03.03.2012 19:29, schrieb Kit: 2012/3/3 Christoph P.U. Kukulies: I'm building a unique ID made up from the basename, md5sum and size of the file. This results as a TEXT PRIMARY KEY (e.g. filename_md5sum_size). Can I use (I'm using System.Data.SQLite) a try clause to find