From: | Mingyu Li <lmy2010lmy(at)gmail(dot)com> |
---|---|
To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [PoC] run SQL over ciphertext |
Date: | 2023-10-11 07:34:27 |
Message-ID: | CACoW8n3HB6bubcyvpHwG1A3h6ihig9aLovaTnP-RL1tj6iG7Xg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello Peter,
Thanks for referring me to your TCE project, nice work! It takes time to go
through the long thread of discussion and the patch.
A quick question: what operations do pg_encrypted_* support? Are
(in)equality checks sufficient to fulfill real-world queries?
--
Best,
Mingyu
Peter Eisentraut <peter(at)eisentraut(dot)org> 于2023年10月11日周三 14:43写道:
> On 10.10.23 08:42, Mingyu Li wrote:
> > We have developed an extension, allowing PostgreSQL to run queries over
> > encrypted data. This functionality is achieved via user-defined
> > functions that extend encrypted data types and support commonly used
> > expression operations. Our tests validated its effectiveness with TPC-C
> > and TPC-H benchmarks. You may find the code here:
> > https://github.com/SJTU-IPADS/HEDB <https://github.com/SJTU-IPADS/HEDB>.
> >
> > This PoC is a reimplementation fork while collaborating with a cloud
> > database company; the aim is to enable their DBAs to manage databases
> > without the risk of data leaks, /meeting the requirements of laws such
> > as GDPR./
> >
> > I am wondering if anyone thinks this is a nice feature. If so, I am
> > curious about the steps to further it mature and potentially have it
> > incorporated as a part of PostgreSQL contrib.
>
> FYI, see also
> <
> https://www.postgresql.org/message-id/flat/89157929-c2b6-817b-6025-8e4b2d89d88f(at)enterprisedb(dot)com>
>
> for a similar project.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2023-10-11 07:37:46 | Re: Pre-proposal: unicode normalized text |
Previous Message | Ashutosh Bapat | 2023-10-11 07:22:00 | Re: RFC: Logging plan of the running query |