public inbox for [email protected]  

help / color / mirror / Atom feed

From: Mingyu Li <[email protected]>
To: Peter Eisentraut <[email protected]>
Cc: [email protected]
Subject: Re: [PoC] run SQL over ciphertext
Date: Wed, 11 Oct 2023 15:34:27 +0800
Message-ID: <CACoW8n3HB6bubcyvpHwG1A3h6ihig9aLovaTnP-RL1tj6iG7Xg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CACoW8n1ccpw4qWw24pMHofVmwScdB+vc=TznwN8DfnSr7eYhNQ@mail.gmail.com>
	<[email protected]>

Hello Peter,

>
https://www.postgresql.org/message-id/flat/[email protected]

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 <[email protected]> 于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/[email protected];
>
> for a similar project.
>
>

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: [PoC] run SQL over ciphertext
  In-Reply-To: <CACoW8n3HB6bubcyvpHwG1A3h6ihig9aLovaTnP-RL1tj6iG7Xg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox