Re: GPG signing

2020-06-03 Thread Bruce Momjian
On Wed, May 27, 2020 at 10:14:46AM +1000, Tim Cross wrote: > > Marc Munro writes: > > > I need to be able to cryptographically sign objects in my database > > using a public key scheme. > > > > Is my only option to install plpython or some such thing? Python > > generally makes me unhappy as

Re: GPG signing

2020-05-28 Thread Michel Pelletier
On Thu, May 28, 2020 at 5:14 PM Marc Munro wrote: > On Wed, 2020-05-27 at 14:42 -0700, Michel Pelletier wrote: > > Hi Marc, > > > > You can sign content with pgsodium: > > > > https://github.com/michelp/pgsodium > > Michel, > Yay! A modern crypto implementation. And it seems to do most of what

Re: GPG signing

2020-05-28 Thread Marc Munro
On Wed, 2020-05-27 at 14:42 -0700, Michel Pelletier wrote: > Hi Marc, > > You can sign content with pgsodium: > > https://github.com/michelp/pgsodium Michel, Yay! A modern crypto implementation. And it seems to do most of what I need right out of the box with way less work than pgcrypto. Any

Re: GPG signing

2020-05-27 Thread Michel Pelletier
As it's not well documented yet (sorry) I'm following up to add signing is done with `crypto_sign()` and `crypto_sign_open()` https://github.com/michelp/pgsodium/blob/master/test.sql#L73 On Wed, May 27, 2020 at 2:42 PM Michel Pelletier wrote: > Hi Marc, > > You can sign content with pgsodium:

Re: GPG signing

2020-05-27 Thread Michel Pelletier
Hi Marc, You can sign content with pgsodium: https://github.com/michelp/pgsodium On Tue, May 26, 2020 at 12:21 PM Marc Munro wrote: > On Tue, 2020-05-26 at 12:04 -0700, Adrian Klaver wrote: > > On 5/26/20 12:01 PM, Marc Munro wrote: > > > I need to be able to cryptographically sign objects in

Re: GPG signing

2020-05-26 Thread Tim Cross
Marc Munro writes: > I need to be able to cryptographically sign objects in my database > using a public key scheme. > > Is my only option to install plpython or some such thing? Python > generally makes me unhappy as I'm never convinced of its stability or > the quality of its APIs, and it

Re: GPG signing

2020-05-26 Thread raf
Marc Munro wrote: > On Tue, 2020-05-26 at 12:04 -0700, Adrian Klaver wrote: > > On 5/26/20 12:01 PM, Marc Munro wrote: > > > I need to be able to cryptographically sign objects in my database > > > using a public key scheme. > > > [ . . . ] > > > Any other options?  Am I missing something? > > >

Re: GPG signing

2020-05-26 Thread Marc Munro
On Tue, 2020-05-26 at 12:04 -0700, Adrian Klaver wrote: > On 5/26/20 12:01 PM, Marc Munro wrote: > > I need to be able to cryptographically sign objects in my database > > using a public key scheme. > > [ . . . ] > > Any other options?  Am I missing something? > >

Re: GPG signing

2020-05-26 Thread David G. Johnston
On Tuesday, May 26, 2020, Marc Munro wrote: > I need to be able to cryptographically sign objects in my database > using a public key scheme. > > Any other options? Am I missing something? > This feels like it should be an application (middleware...) concern, not the database proper. i.e.,

Re: GPG signing

2020-05-26 Thread Adrian Klaver
On 5/26/20 12:01 PM, Marc Munro wrote: I need to be able to cryptographically sign objects in my database using a public key scheme. Is my only option to install plpython or some such thing? Python generally makes me unhappy as I'm never convinced of its stability or the quality of its APIs,

GPG signing

2020-05-26 Thread Marc Munro
I need to be able to cryptographically sign objects in my database using a public key scheme. Is my only option to install plpython or some such thing? Python generally makes me unhappy as I'm never convinced of its stability or the quality of its APIs, and it is not obvious to me which of the