Database Lab – Full-size staging databases as a service

Re:Database Lab – Full-size staging databases as a service by penagwin on Friday February 07, 2020 @03:29PM (#22270554)

> There are masking tools out there that can mask data from production

Thank you so much! "Masking" was the phrase I needed to find some potential solutions! I wasn't able to find much before, that points me in the correct direction. Thanks!

[ Parent | on HN ]

Re:Database Lab – Full-size staging databases as a service by samokhvalov on Friday February 07, 2020 @05:02PM (#22271512)

There are various approaches here, and there are some FOSS tools that you can use.

Some links:

- https://blog.taadeem.net/english/2019/01/03/8_anonymization_... – description of methods, and a tool for Postgres, postgresql_anonymizer

- https://habr.com/en/company/yandex/blog/485096/ – not for Postgres, it's for ClickHouse (open-source DBMS for analytics) but covers the topic very well.

[ Parent | on HN ]

Re:Database Lab – Full-size staging databases as a service by rickbad68 on Friday February 07, 2020 @04:39PM (#22271248)

Other common terms for this are sanitization or redaction

[ Parent | on HN ]