{"id":28624,"date":"2018-06-11T19:14:08","date_gmt":"2018-06-11T17:14:08","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28624"},"modified":"2018-06-11T19:14:08","modified_gmt":"2018-06-11T17:14:08","slug":"forget-db-a-simple-gdpr-inspired-tool-to-anonymise-confidential-database-data","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2018\/06\/11\/forget-db-a-simple-gdpr-inspired-tool-to-anonymise-confidential-database-data\/","title":{"rendered":"forget-db &#8211; a simple GDPR inspired tool to anonymise confidential database data"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p><a href=\"https:\/\/github.com\/owenmelbz\/forget-db\">forget-db<\/a>:<\/p>\n<blockquote><p>A simple(ish) command line tool written in PHP 7.1 using Laravel Zero and Faker to help you anonymise\/pseudonymise data within your database to support protecting either sensitive information, or peoples right to be forgotten with GDPR compliance.<\/p>\n<p>The tool allows you to connect to either mysql, postgres, sqlite or sqlserver and replace defined information with random data to allow you to keep statistics\/relationships\/audit of actions etc.<\/p>\n<p>It uses a simple yaml configuration file to define the conditions for overwriting, which fields you want to overwrite, and what to overwrite them with.<\/p><\/blockquote>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>forget-db: A simple(ish) command line tool written in PHP 7.1 using Laravel Zero and Faker to help you anonymise\/pseudonymise data within your database to support protecting either sensitive information, or peoples right to be forgotten with GDPR compliance. The tool allows you to connect to either mysql, postgres, sqlite or sqlserver and replace defined information &hellip; <a href=\"https:\/\/mamchenkov.net\/wordpress\/2018\/06\/11\/forget-db-a-simple-gdpr-inspired-tool-to-anonymise-confidential-database-data\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">forget-db &#8211; a simple GDPR inspired tool to anonymise confidential database data<\/span><\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"forget-db - a simple GDPR inspired tool to anonymise confidential database data #WebDev #PHP #GDPR #Laravel #CLI #privacy #databases","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[1,6,18,133,62,1334],"tags":[1960,1559,3063,3588,3549,38,384,1330],"keyring_services":[],"class_list":["post-28624","post","type-post","status-publish","format-standard","hentry","category-general","category-linux","category-programming","category-sysadmin","category-technology","category-web-work","tag-command-line","tag-databases","tag-frameworks","tag-gdpr","tag-laravel","tag-php","tag-privacy","tag-web-development"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":42744,"url":"https:\/\/mamchenkov.net\/wordpress\/2019\/06\/25\/gdpr-cookie-scanner\/","url_meta":{"origin":28624,"position":0},"title":"GDPR cookie scanner","author":"Leonid Mamchenkov","date":"June 25, 2019","format":false,"excerpt":"I came across the GDPR Expert service via this HackerNews thread. It is a service that helps website owners with the GDPR compliance. Behind the scenes, there is this open source tool, which scans for cookies and provides the details about the vendor and purpose of each identified cookie. The\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":26993,"url":"https:\/\/mamchenkov.net\/wordpress\/2016\/11\/28\/deployer-deployment-tool-for-php\/","url_meta":{"origin":28624,"position":1},"title":"Deployer \u2014 Deployment tool for PHP","author":"Leonid Mamchenkov","date":"November 28, 2016","format":false,"excerpt":"Deployer is yet another tool for deploying PHP projects. \u00a0 It looks to have more similarities with Laravel Envoy and phake, than with Robo.li, of which I am a new and growing fan. \u00a0But I thought I'd throw it into the mix here, just in case I'll change my mind\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"deployer","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2016\/11\/deployer.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":28468,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/04\/08\/handling-amazon-sns-messages-with-php-lumen-and-cloudwatch\/","url_meta":{"origin":28624,"position":2},"title":"Handling Amazon SNS messages with PHP, Lumen and CloudWatch","author":"Leonid Mamchenkov","date":"April 8, 2018","format":false,"excerpt":"Gonzalo Ayuso throws a few snippets of code in the blog posts title \"Handling Amazon SNS messages with PHP, Lumen and CloudWatch\", which shows how to work with Amazon SNS\u00a0(Simple Notifications Service) and Amazon CloudWatch\u00a0(cloud and network monitoring solution) from PHP.\u00a0 The examples are based on the Lumen micro-framework, which\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27869,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/08\/24\/eu-gdpr-helpful-resources\/","url_meta":{"origin":28624,"position":3},"title":"EU GDPR Helpful Resources","author":"Leonid Mamchenkov","date":"August 24, 2017","format":false,"excerpt":"As a follow up to my earlier post about EU General Data Protection Regulation, here are a few helpful resources: Getting to the GDPR: Four key use cases to jumpstart your efforts, from IBM. Preparing for the General\u00a0Data Protection Regulation (GDPR), from UK's Information Commissioner's Office. Data protection self assessment\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27854,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/08\/17\/eu-general-data-protection-regulation-gdpr\/","url_meta":{"origin":28624,"position":4},"title":"EU General Data Protection Regulation (GDPR)","author":"Leonid Mamchenkov","date":"August 17, 2017","format":false,"excerpt":"Here are a few things to get you started with European Union General Data Protection Regulation (GDPR). \u00a0First is a little introduction: After four years of preparation and debate the GDPR was\u00a0finally approved\u00a0by the EU Parliament on\u00a014 April 2016. It will enter in force 20 days after its publication in\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27878,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/08\/28\/tntsearch-a-fully-featured-full-text-search-engine-written-in-php\/","url_meta":{"origin":28624,"position":5},"title":"TNTSearch &#8211; a fully featured full text search engine written in PHP","author":"Leonid Mamchenkov","date":"August 28, 2017","format":false,"excerpt":"TNTSearch - a fully featured full text search engine written in PHP. \u00a0Here's also a blog post that shows how to use it with the Laravel framework. \u00a0Which shouldn't be too difficult to adjust for any other PHP framework.","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28624","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=28624"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/28624\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=28624"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=28624"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=28624"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=28624"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}