I’m designing a plugin to create database indexes. Suggestions?

This plugin, Index WP MySQL for Speed, is released. GPLed source code is here. Anecdotal experience shows speedups on some big WP and WooCommerce sites. Here’s the data definition language it runs to create useful compound indexes. ALTER TABLE wp_postmeta ADD UNIQUE KEY meta_id (meta_id); ALTER TABLE wp_postmeta DROP PRIMARY KEY; ALTER TABLE wp_postmeta ADD … Read more

ServerSideRender and Media Object: attributes passing image data object to php renderer even though it’s not set

the issue I’m having is that the image data object (imgDataObj in the js), which is saved as an attribute in the JS side, is getting passed to the PHP side even though I’m not passing it in the serversiderender component and I’m not listening for it in the PHP render callback That issue could … Read more

Custom plugin icon not showing up

The dev docs are for adding an icon that the .org repository can use. You’ll note that the relevant docs are part of the “The WordPress.org Plugin Directory” section. To display an icon on the updates screen for a plugin that is not distributed through the repository you need to include the icon URL in … Read more