{"id":39895,"date":"2015-11-03T15:49:28","date_gmt":"2015-11-03T15:49:28","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/database-debugging-tools-for-developers\/"},"modified":"2016-12-24T00:02:40","modified_gmt":"2016-12-24T00:02:40","slug":"database-debugging-tools-for-developers","status":"closed","type":"plugin","link":"https:\/\/srd.wordpress.org\/plugins\/database-debugging-tools-for-developers\/","author":10452081,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"2.2.0.1","stable_tag":"2.2.0.1","tested":"4.7.33","requires":"3.6","requires_php":"","requires_plugins":"","header_name":"Database Debugging Tools for Developers","header_author":"Magenta Cuda","header_description":"","assets_banners_color":"","last_updated":"2016-12-24 00:02:40","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"https:\/\/wpdbdt.wordpress.com\/","header_author_uri":"https:\/\/profiles.wordpress.org\/magenta-cuda\/","rating":5,"author_block_rating":0,"active_installs":10,"downloads":2670,"num_ratings":1,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"2.2.0.1":"<ul>\n<li>fix a small bug with SELECT with multiple primary keys<\/li>\n<\/ul>","2.2":"<ul>\n<li>fix broken RegEx&#039;s which failed to match some SQL operations as it should<\/li>\n<li>support logging SQL SELECT operations <\/li>\n<li>support recovery from backup\/restore timeout failure<\/li>\n<\/ul>","2.1.1":"<ul>\n<li>fix diff tool so that it correctly handles tables with multiple primary keys<\/li>\n<\/ul>","2.1.0.2":"<ul>\n<li>bug fix<\/li>\n<\/ul>","2.1.0.1":"<ul>\n<li>bug fix<\/li>\n<\/ul>","2.1":"<ul>\n<li>improved user interface<\/li>\n<li>code refactored to improve software quality<\/li>\n<\/ul>","2.0.1.1":"<ul>\n<li>Fix HTML entities bug<\/li>\n<\/ul>","2.0.1":"<ul>\n<li>Remember the table size, cell size and sort order for each table for the next session <\/li>\n<li>Highlight the changed fields in serialized values<\/li>\n<\/ul>","2.0.0.1":"<ul>\n<li>Fix readme tags<\/li>\n<\/ul>","2.0":"<ul>\n<li>Added the diff tool<\/li>\n<\/ul>","1.0":"<ul>\n<li>Initial release.<\/li>\n<\/ul>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"1"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["1.0","2.0","2.0.0.1","2.0.1","2.0.1.1","2.1","2.1.0.1","2.1.0.2","2.1.1","2.2","2.2.0.1"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1557148","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1557148","resolution":"2","location":"assets"},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1294512","resolution":"3","location":"assets"}},"screenshots":{"1":"Backup Tool","2":"Diff Tool","3":"Diff Tool - Detail View"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[151,153,9151,1591,3971],"plugin_category":[59],"plugin_contributors":[89222],"plugin_business_model":[],"class_list":["post-39895","plugin","type-plugin","status-closed","hentry","plugin_tags-backup","plugin_tags-database","plugin_tags-diff","plugin_tags-testing","plugin_tags-tool","plugin_category-utilities-and-tools","plugin_contributors-magenta-cuda","plugin_committers-magenta-cuda"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/database-debugging-tools-for-developers.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/database-debugging-tools-for-developers\/assets\/screenshot-1.png?rev=1557148","caption":"Backup Tool"},{"src":"https:\/\/ps.w.org\/database-debugging-tools-for-developers\/assets\/screenshot-2.png?rev=1557148","caption":"Diff Tool"},{"src":"https:\/\/ps.w.org\/database-debugging-tools-for-developers\/assets\/screenshot-3.png?rev=1294512","caption":"Diff Tool - Detail View"}],"raw_content":"<!--section=description-->\n<p>These tools are intended to be used by WordPress developers for testing and debugging.<\/p>\n\n<p>The backup tool lets you do a quick backup of individual MySQL tables by duplication into the same database, i.e. using \"CREATE TABLE copy LIKE orig; INSERT INTO copy SELECT * FROM orig;\".\nUseful for testing when you know only some tables will be changed so you don't have to save and restore the entire database.\nMost useful for repeated testing, i.e. backup table(s), test, restore table(s), test, restore table(s), ... test, restore table(s), delete backup.<\/p>\n\n<p>The diff tool shows the rows in the selected tables that were inserted, updated or deleted.\nFor updated rows the columns that have changed values have the values highlighted - red for the original value and green for the new value.\nAlthough large values are truncated in table cells the full value is available by clicking on the table cell.\nFurther, serialized values are prettified using JSON.stringify( value, 4 ).\nThe diff tool is intended for viewing the effect on the database tables of a small number of WordPress operations,\ni.e. it is not suitable for testing a large number of WordPress operations.<\/p>\n\n<p>Please visit <a href=\"https:\/\/wpdbdt.wordpress.com\/\">https:\/\/wpdbdt.wordpress.com\/<\/a> for a very quick introduction.<\/p>\n\n<p><strong>This plugin requires at least PHP 5.4.<\/strong><\/p>\n\n<!--section=installation-->\n<ol>\n<li>Download the plugin from the WordPress repository.<\/li>\n<li>Open the 'Plugins' menu item and activate the plugin.<\/li>\n<li>Read the tutorial at <a href=\"https:\/\/wpdbdt.wordpress.com\/\">https:\/\/wpdbdt.wordpress.com\/<\/a><\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt>Can this be used for backing up a database?<\/dt>\n<dd><p>No, the backup is done by creating additional tables in the same database so if the database is lost the backup is also lost.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>2.2.0.1<\/h4>\n\n<ul>\n<li>fix a small bug with SELECT with multiple primary keys<\/li>\n<\/ul>\n\n<h4>2.2<\/h4>\n\n<ul>\n<li>fix broken RegEx's which failed to match some SQL operations as it should<\/li>\n<li>support logging SQL SELECT operations<\/li>\n<li>support recovery from backup\/restore timeout failure<\/li>\n<\/ul>\n\n<h4>2.1.1<\/h4>\n\n<ul>\n<li>fix diff tool so that it correctly handles tables with multiple primary keys<\/li>\n<\/ul>\n\n<h4>2.1.0.2<\/h4>\n\n<ul>\n<li>bug fix<\/li>\n<\/ul>\n\n<h4>2.1.0.1<\/h4>\n\n<ul>\n<li>bug fix<\/li>\n<\/ul>\n\n<h4>2.1<\/h4>\n\n<ul>\n<li>improved user interface<\/li>\n<li>code refactored to improve software quality<\/li>\n<\/ul>\n\n<h4>2.0.1.1<\/h4>\n\n<ul>\n<li>Fix HTML entities bug<\/li>\n<\/ul>\n\n<h4>2.0.1<\/h4>\n\n<ul>\n<li>Remember the table size, cell size and sort order for each table for the next session<\/li>\n<li>Highlight the changed fields in serialized values<\/li>\n<\/ul>\n\n<h4>2.0.0.1<\/h4>\n\n<ul>\n<li>Fix readme tags<\/li>\n<\/ul>\n\n<h4>2.0<\/h4>\n\n<ul>\n<li>Added the diff tool<\/li>\n<\/ul>\n\n<h4>1.0<\/h4>\n\n<ul>\n<li>Initial release.<\/li>\n<\/ul>","raw_excerpt":"WordPress database tools for debugging.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/39895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=39895"}],"author":[{"embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/magenta-cuda"}],"wp:attachment":[{"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=39895"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=39895"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=39895"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=39895"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=39895"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/srd.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=39895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}