SQL-powered bulk anonymization
civicrm_obfuscate_db.php
is terrible code, but with enough nested REPLACE(REPLACE(REPLACE(
we could deliver something crude and kind of performant.
I'd like it to have some simple rules, eg,
- Names are generated using a salt + MD5, then replaced down to something pronounceable.
- Names are between four and seven characters.
- Names have a reduced alphabet.
- Maybe names which are more vowels than consonants will be less weird to read?
- Or vowel-consonant-vowel-random-consonant, or something?
Anyway, the above can be done (in some truly awful to read SQL), and would be faster than Faker + Civi API, for use on larger DBs.