Adam Silverstein adamsilverstein

💭

Working remotely, as usual

WordPress core committer, Developer Relations Engineer Xoogler

adamsilverstein / webp 90 quality

Created June 2, 2022 13:17

adamsilverstein / 82 quality webp

Created June 2, 2022 13:12

adamsilverstein / picture-in-wordpress.sql

Created February 24, 2022 15:53

	WITH picture AS (
	SELECT
	url
	FROM
	`httparchive.pages.2022_01_01_mobile`
	WHERE
	JSON_VALUE(JSON_VALUE(payload, '$._element_count'), '$.picture') IS NOT NULL
	), wordpress AS (
	SELECT DISTINCT
	url

adamsilverstein / extend-uploader.js

Last active March 18, 2022 14:14

	// When image uploads complete, trigger a check for additional mime types
	//Extend the Uploader success.
	jQuery.extend(wp.Uploader.prototype, {
	success: function( file ) {
	wp.ajax.post(
	'media-create-image-mime-types',
	{
	_wpnonce: _wpPluploadSettings.defaults.multipart_params._wpnonce,
	attachment_id: file.id,
	}

adamsilverstein / multi-meta.json

Last active March 18, 2022 14:14

adamsilverstein / mime-types.php

Last active March 18, 2022 14:14

	<?php
	/**
	* Multiple mime types for WordPress.
	*
	* @wordpress-plugin
	* Plugin Name: Multi-mime.
	* Description: Uploaded images in multiple mime types, requires https://github.com/WordPress/wordpress-develop/pull/2239.
	* Plugin URI:
	* Version: 1.0.0
	* Author: Adam Silverstein, Google

adamsilverstein / WebP usage in WordPress by version.sql

Created January 26, 2022 17:38

	SELECT
	mobile.version,
	ROUND(pct_webp_mobile, 3) AS pct_webp_mobile,
	ROUND(pct_webp_desktop, 3) AS pct_webp_desktop
	FROM
	(
	SELECT
	version, pct_webp AS pct_webp_mobile
	FROM
	(

adamsilverstein / webp-size-vs-jpeg.sql

Created January 18, 2022 20:23

	SELECT
	has_webp,
	APPROX_QUANTILES(bytesImg, 1000)[OFFSET(500)] / 1024 / 1024 AS median_img_mbytes
	FROM (
	SELECT DISTINCT
	url,
	info AS version
	FROM
	`httparchive.technologies.2021_11_01_mobile`
	WHERE

adamsilverstein / wp-rocket-site-kit-compat.php

Last active March 18, 2022 06:12

Improve compatibility between Site Kit and WP Rocket

	<?php
	/**
	* WP Rocket compatibility for Site Kit.
	*
	* @wordpress-plugin
	* Plugin Name: SiteKit WP Rocket Compatibility
	* Description: Improve compatibility between Site Kit and WP Rocket.
	* Plugin URI:
	* Version: 1.0.0
	* Author: Adam Silverstein, Google

adamsilverstein / cwv-performance-by-wp-version.sql

Created October 15, 2021 20:45

	CREATE TEMP FUNCTION IS_GOOD(good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (
	good / (good + needs_improvement + poor) >= 0.75
	);

	CREATE TEMP FUNCTION IS_NON_ZERO(good FLOAT64, needs_improvement FLOAT64, poor FLOAT64) RETURNS BOOL AS (
	good + needs_improvement + poor > 0
	);
	SELECT *
	FROM (
	SELECT