pgcrypto question

2019-10-07 Thread Erik Aronesty
Currently, it is my understanding that the pgcrypto library requires the user to send a password or private key up to the server for decryption. Is there a notion of a client-side encrypt/decrypt plugin when doing a postgres query? For example, a user could query postgres, get back data of type "

Re: pgcrypto question

2019-10-07 Thread Erik Aronesty
, 2019 at 12:05:16PM -0400, Erik Aronesty wrote: > >Currently, it is my understanding that the pgcrypto library requires > >the user to send a password or private key up to the server for > >decryption. > > > > Correct. In the naive case the key is included in each SQL qu

Re: pgcrypto question

2019-10-07 Thread Erik Aronesty
my client apps can stay the same. On Mon, Oct 7, 2019 at 3:49 PM Tomas Vondra wrote: > > On Mon, Oct 07, 2019 at 02:51:30PM -0400, Erik Aronesty wrote: > >Good idea for "psycopg". It would be easy for a POC, but I think the > >only meaningful layer to operate at w

Re: Fast, stable, portable hash function producing 4-byte or 8-byte values?

2019-12-15 Thread Erik Aronesty
You can always tweak fnv for whatever bite-size or bit size you want. Sometimes I know a little information about my data shape and make a custom fnv that only looks at the first half for the last half of a string, etc. On Wed, Dec 11, 2019, 1:02 PM Erwin Brandstetter wrote: > Thanks for the su