ietf-openpgp
[Top] [All Lists]

Re: Trust Packets

2004-01-30 02:54:49

Werner Koch <wk(_at_)gnupg(_dot_)org> writes:

The concept of a keyring is PGP specific, other implementations may use an
SQL DB or use a mixed approach, where the trust information is kept separate
from the keys.

Just out of interest, is there anyone using an SQL DB to store PGP keys?  I've
thought about this a bit in the past (I use databases to store other types of
keys) but because of the free-form association of different bits and pieces of
keys with identifying information I can't think of any easy way to do it
unless you use a multi-level lookup.  That is, you can't do a:

  SELECT key FROM table WHERE email = foo

because there could be an arbitrary number of email addresses attached to a
key, and there could be an arbitrary number of keys associated with an email
address.  So you need something like:

  SELECT keyID FROM indexTable WHERE email = foo 
  SELECT key FROM sigKeyTable WHERE keyID = foo

which isn't very efficient (multiple tables, multi-level lookups, etc etc).

Peter.



<Prev in Thread] Current Thread [Next in Thread>