-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 08/01/2010 08:47 AM, Nikolaus Rath wrote: > Since in this > case the file names are just opaque labels without any relations or > structure, hashing them all was a pretty good solution.
I think it is rare that would work as a way of obfuscating SQLite databases in general since it would break relations and alter the statistical distribution of values. Also note that a hash function would not be sufficient since it can be used to confirm things. For example you could use the hashes to confirm if "Nigerian Prince.txt" is one of the filenames. > I was wondering why there isn't a hash function build into SQLite. Firstly note the last 4 letters of the name. It is indeed a fairly frequent lament here that SQLite should include some functions the poster thinks is generally applicable. Did you know it doesn't include a string reverse function as standard, nor any of the trigonometry ones, not even square root, is missing many potentially useful string functions and even omits statistical functions like standard deviation, median etc? There is no way the SQLite team could make everyone happy and what one group of people find useful would be totally useless to many others. Consequently they created APIs that make it easy to add functions. > You mean with sqlite3_create_function()? That is the one. You can even override the builtin functions using it. If you are doing this with APSW and want some help making it work automagically for all your code as well as the shell then post to the python-sqlite mailing list. Also see the bottom of http://sqlite.org/contrib Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkxWFVYACgkQmOOfHg372QSb/ACgnCv9VSmtzGgOJXOMWXTZhkXZ TCkAoLAp0nwRiUf0grBffr+6i3R6hxjU =gKta -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
