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

From Mingyu Li
Subject [PoC] run SQL over ciphertext
Date
Msg-id CACoW8n1ccpw4qWw24pMHofVmwScdB+vc=TznwN8DfnSr7eYhNQ@mail.gmail.com
Whole thread Raw
Responses Re: [PoC] run SQL over ciphertext
Re: [PoC] run SQL over ciphertext
List pgsql-hackers
Hi all,

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.

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.

Best regards,
Mingyu Li

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Fix output of zero privileges in psql
Next
From: Peter Eisentraut
Date:
Subject: Re: Pre-proposal: unicode normalized text