Re: [PoC] run SQL over ciphertext - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PoC] run SQL over ciphertext
Date
Msg-id 12788b03-80bc-4514-a846-cee9a36caebe@eisentraut.org
Whole thread Raw
In response to [PoC] run SQL over ciphertext  (Mingyu Li <lmy2010lmy@gmail.com>)
Responses Re: [PoC] run SQL over ciphertext
List pgsql-hackers
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@enterprisedb.com> 
for a similar project.




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: CREATE DATABASE with filesystem cloning
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag