{"repo":"josacar/triki","free":true,"listed":false,"github":"https://github.com/josacar/triki","clone":"git clone https://github.com/josacar/triki.git","description":"Mysql, PostgreSQL and SQL dump obfuscator aka anonimizer","language":"Crystal","stars":45,"topics":["crystal-language","crystal-lang","crystal","shards","crystal-shard","mysql","postgresql","sqlserver","obfuscator","database-dump"],"license":"MIT","category":"databases-storage","readme_excerpt":"Triki You want to develop against real production data, but you don't want to violate your users' privacy. Enter Triki: standalone Crystal code for the selective rewriting of SQL dumps in order to protect user privacy. Documentation API documentation is available at . Table of Contents - Supported databases and versions - Install - Quick Start - Column Types & Configuration Options - Error Handling & Troubleshooting - Scaffolding - Speed - Contributing - Thanks - License Supported databases and versions Servers - MySQL - Postgres - SQL Server Clients - pg dump ( Postgresql ) up to 15.x - mysqldump ( MySQL ) up to 8.2 - mysqldump ( MariaDB ) aka mariadb-dump ( since v0.3.0 ) up to 10.11 Note : Clients may break current SQL dump parsing as by now there is no proper integration testing in CI with all combinations of servers and clients versions, above versions have been partially manually tested. Install Add this in your shard.yml And then run shards install Quick Start 1. Create an obfuscator script 2. Pipe a database dump through it That's it — every row in users gets anonymized, sessions is emptied, and roles passes through unchanged. Tip: For large dumps, compile once and use the binary for much faster processing: Example Usage Make an obfuscator.cr script: And to get an obfuscated dump: For details on required mysqldump flags and troubleshooting common issues, see Error Handling & Troubleshooting below. PostgreSQL & SQL Server By default the database type is assumed to be M","default_branch":null,"files":null,"tree":[],"storefront":"/r/josacar","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/josacar/triki/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}