[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Monotone-devel] Re: Getting all certificates efficiently
From: |
Lapo Luchini |
Subject: |
[Monotone-devel] Re: Getting all certificates efficiently |
Date: |
Sun, 30 Apr 2006 23:32:47 +0000 (UTC) |
User-agent: |
Loom/3.14 (http://gmane.org/) |
Nathaniel Smith <njs <at> pobox.com> writes:
> > monotone db execute "SELECT id,name,value FROM revision_certs"
> Hrm. I was doing to say "SELECT id, name, base64(value) FROM
> revision_certs", but it looks like we don't actually expose a base64
> function to sqlite.
mtn db execute 'SELECT id,name,quote(value) FROM revision_certs'
This does extract value in X'0123456789abcdef' format.
(even easier to use than base64, imho)
Lapo
--
Lapo Luchini
www.lapo.it