Am 03.03.2012 19:29, schrieb Kit:
2012/3/3 Christoph P.U. Kukulies<k...@kukulies.org>:
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 out whether
the entry is already there?
I think this can be faster than asking the database by an SQL statement,
whether the KEY is already there.
Christoph
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.
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?
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
