paragonie / ciphersweet

Fast, searchable field-level encryption for PHP projects
https://ciphersweet.paragonie.com
Other
437 stars 32 forks source link

global blind index implementation? #65

Closed slushpuppy closed 2 years ago

slushpuppy commented 2 years ago

Hi, I am making a global search system from my app that allows users to search for encrypted data from multiple tables with differing schemas containing encrypted data. The only commonality between the data being searched are that they are all text searches with the same transformations. what would be the best way to go about doing this?

paragonie-security commented 2 years ago

Use EncryptedMultiRows, define a pseudo-table that all of the blind indexes would be defined over regardless of their actual location within the database.