Viewing profile — daamien

OP is one of 7 PostgreSQL core team members. That's kind of his job to massively overthink this :)

Hi ! I'm the main developer of this extension. Happy to answer any question you have about this project and anonymization in general!

Pseudonymizing functions are just one way to mask the data. There are many other masking functions that will actually anonymize the data. And the extension does not force you to re…

PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained. This extension is currently not available on RDS but it is available…

Both approach are possible * Static Masking will destroy the authentic data once for all * Dynamic Masking will only alter the data the "masked users". Regular users will continue …

This is called "Privacy By Default" https://postgresql-anonymizer.readthedocs.io/en/stable/priva...

Of course there's no perfect solution for anonymizing a dataset... The extension offers a large panel of masking functions : some are pseudonymizing functions but others are more d…

Version 2.0 was released a few days ago. It's a complete rewrite in Rust. Performance should be better than with v1.x

This called "Masking Data Wrappers" https://postgresql-anonymizer.readthedocs.io/en/stable/maski...

PostgreSQL Anonymizer developer here : this was possible with version 0.8 which is now completely unmaintained. This extension is currently not available on RDS but it is available…

PostgreSQL Anonymizer developer here : the problem you are describing here only affects version 1.x Version 2.0 was released a few days ago with a branch new masking system that do…

Actually the GDPR "just" requires to protect the data against "reasonably likely" attacks. « To determine whether a natural person is identifiable, account should be taken of all t…

See PEV2 : https://github.com/dalibo/pev2

This is still an issue : https://postgresql.verite.pro/blog/2018/08/27/glibc-upgrade....

... and with dozens of other data sources: https://wiki.postgresql.org/wiki/Foreign_data_wrappers

PostgreSQL does this out of the box with : CREATE EXTENSION file_fdw; CREATE SERVER import FOREIGN DATA WRAPPER file_fdw; CREATE FOREIGN TABLE foo ( col1 text, col2 text, ... ) SER…

direct link to the PDF : http://www.postgresql.org/message-id/attachment/43080/Postgr...

Temporary index and Hypothetical index are two different things. Temporary index is a real index that's usually dynamically created by the optimizer to speed up a query. But it's k…