masking
masking copied to clipboard
kibitan
Command line tool for generating anonymized database for MySQL/MariaDB
Currently the user needs to know the semantic details of the database in order to define which tables/columns need to be masked. It would be nice to make `masking` smart...
there is a use-case that on a nullable column, just keep it `NULL` if it's `NULL`, mask data if it's not `NULL`. ## Tech tips - how to define the...
mysqldump `--complete-insert` option will provide insert statement with schema type information, which required in the current implementation, but we don't need it for output sqldump and it will be better...
In order to make less effort for new schema change, if masking has a feature of a default value of an anonymized column can be nice. *Tech Tips* - masking...
fix #88 after the investigation, somehow `mysqldump` behavior looks changed. it output with many breaklines ``` INSERT INTO `users` (`id`, `string`, `email`, `integer`, `float`, `boolean`, `null`, `date`, `time`, `binary_or_blob`, `nullable_string`,...
i heard the use-case that, they want to have a part of anonymised database, not entire database. the production data is too big and not neccesary to have whole data-set...
it can be used for replecation? mysql has a replication mode with SQL statement-based replication. https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html#replication-sbr-rbr-sbr-advantages if so, it can be usable for realtime anonymising
In order to have a binary Reference repository: https://github.com/cloudamqp/lavinmq