Ideas and Resources

Videos / Presentations

• French: https://www.youtube.com/watch?v=KGSlp4UygdU
• English: https://www.youtube.com/watch?v=niIIFL4s-L8
• Chinese: https://www.youtube.com/watch?v=n9atI31FcSM

Similar Tools

Here's a list of open-source projects with similar goals. AS the PostgreSQL Anonymizer extension is often compared to some of them, we try to maintain the feature matrix below:

Name	rules syntax	static masking	dynamic masking	backup masking	replica masking	FDW masking
PostgreSQL Anonymizer	SQL	✅	✅	✅	✅	✅
database anonymizer	YAML	-	-	✅	-	-
greenmask	YAML	-	-	✅	-	-
pg_anon	JSON	-	-	✅	-	-
pg_anonymize	SQL	-	✅	✅	-	-
pg_diffix	SQL	-	✅	-	-	-
pg-anonymizer	JS	-	-	✅	-	-
pg-mask	SQL	-	-	✅	-	-
pganonymize	YAML	-	-	✅	-	-
pgantomizer	YAML	-	-	✅	-	-
pgEdge Anonymizer	YAML	✅	-	-	-	-
pgstream	YAML	-	-	-	✅	-

Similar Implementations

• Dynamic Data Masking With MS SQL Server

• Citus : Using search_path and views to hide columns for reporting with Postgres

• MariaDB : Masking with maxscale

GDPR

• Ultimate Guide to Data Anonymization

• UK ICO Anonymisation Code of Practice

• L. Sweeney, Simple Demographics Often Identify People Uniquely, 2000

• How Google anonymizes data

• IAPP's Guide To Anonymisation

Concepts

• Differential_Privacy

• K-Anonymity

Academic Research

• L. Sweeney. k-anonymity: a model for protecting privacy. International Journal on Uncertainty, Fuzziness and Knowledge-based Systems, 10 (5), 2002, pp. 557-570. https://epic.org/wp-content/uploads/privacy/reidentification/Sweeney_Article.pdf

• A. Narayanan and V. Shmatikov, “Robust de-anonymization of large sparse datasets,” in 29th IEEE Symposium on Security and Privacy, 2008, pp. 111–125. https://www.cs.cornell.edu/~shmat/shmat_oak08netflix.pdf