adamsilverstein

<?php
/**
 * Profile image loading and resizing.
 *
 * @wordpress-plugin
 * Plugin Name: Profile image processing
 * Description: Profile image loading and resizing by mime format.
 * Plugin URI: n/a
 * Version:     1.0.0
 * Author:      Adam Silverstein, Google

adamsilverstein

adamsilverstein

<?php
/**
 * Add Google tag to WordPress.
 *
 * @wordpress-plugin
 * Plugin Name: google-tag-for-wp.
 * Description: Add the Google tag to the header of a WordPress site.
 * Plugin URI: n/a
 * Version:     1.0.0
 * Author:      Adam Silverstein, Google

adamsilverstein

<?php
/**
 * Outout WebP sub size images from PNG uploads.
 *
 * @wordpress-plugin
 * Plugin Name: WebP-from-PNG.
 * Description:  Output WebP sub size images for PNG uploads.
 * Plugin URI:
 * Version:     1.0.0
 * Author:      Adam Silverstein, Google

adamsilverstein

<?php
/**
 * Disable password reset
 *
 * @wordpress-plugin
 * Plugin Name: Disable password reset.
 * Description: Disable password reset.
 * Plugin URI:
 * Version:     1.0.0
 * Author:      Adam Silverstein, Google

adamsilverstein

/*
* Yielding method using scheduler.yield, falling back to setTimeout:
*/
async function yieldToMain() {
  if('scheduler' in window && 'yield' in scheduler) {
    return await scheduler.yield();
  }

  return new Promise(resolve => {
    setTimeout(resolve, 0);

adamsilverstein

<?php
/**
 * Set a cookie with the 'Partitioned' attribute
 *
 * @wordpress-plugin
 * Plugin Name: Partitioned Cookie demo.
 * Description:  Add a partitioned cookie.
 * Plugin URI:
 * Version:     1.0.0
 * Author:      Adam Silverstein, Google

adamsilverstein

SELECT
  *
FROM(
  SELECT
    JSON_VALUE(third_party, '$.entity') as entity,
    CAST(APPROX_QUANTILES(CAST(JSON_QUERY(third_party, '$.blockingTime') AS FLOAT64), 100)[offset(75)] as INT64) as p75_blockingTime,
    COUNT(page) as usage
  FROM
    `httparchive.all.pages`,
    UNNEST(technologies) as technologies,

adamsilverstein

%%bigquery oembeds
WITH
  WPEmbeds AS (
    SELECT
      url,
      JSON_EXTRACT(payload, '$._cms.wordpress.has_embed_block') AS has_embed_block,
      CAST( JSON_EXTRACT(payload, '$._cms.wordpress.embed_block_count.total') AS FLOAT64 ) AS embed_block_count_total,
      JSON_EXTRACT_ARRAY(payload, '$._cms.wordpress.embed_block_count.total_by_type') AS embed_block_count_total_by_type,

    FROM `httparchive.pages.2023_10_01_*`

adamsilverstein

%%bigquery bytype
WITH
  embed_data AS (
    SELECT
      url,
      JSON_EXTRACT(payload, '$._cms.wordpress.has_embed_block') AS has_embed_block,
      CAST(JSON_EXTRACT(payload, '$._cms.wordpress.embed_block_count.total') AS FLOAT64)
        AS embed_block_count_total,
      JSON_EXTRACT(payload, '$._cms.wordpress.embed_block_count.total_by_type') AS embeds,
    FROM `httparchive.pages.2023_10_01_desktop`