Skip to content

Instantly share code, notes, and snippets.

SELECT pages.rank, pages.pageid, pages.url
FROM [httparchive:runs.2013_11_15_pages] AS pages
JOIN (
SELECT pageid, url FROM [httparchive:runs.2013_11_15_requests]
WHERE REGEXP_MATCH(url, r'lazyload')
) AS reqs
ON reqs.pageid = pages.pageid
WHERE rank IS NOT NULL
GROUP BY pages.pageid, pages.rank, pages.url
ORDER BY pages.rank ASC
@eeeps
eeeps / fouc-free_container_queries.html
Last active June 2, 2017 16:58
Can we initialize a ResizeObserver in the head, and start observing elements as they are parsed on first load with a MutationObserver?
<!doctype html>
<head>
<title>FoUC-free container queries</title>
<script>
const ro = new ResizeObserver( ( entries) => {
// do container query stuff
} );
const mo = new MutationObserver( ( mutations ) => {
// `ro.observe( relevantElement )`s as they are parsed and added to the DOM
} );
require 'net/http'
require 'base64'
# use this with Cloudinary resized URLs
# like https://res.cloudinary.com/eric-cloudinary/image/upload/w_16,q_auto/#{public_id}.jpg
# to get LQIPs
def url_to_data_uri( url, mime_type )
# TODO is there a way to derive the MIME type from the response? Probably.
uri = URI( url )
url quality scale painted_width painted_height bytes ssimulacra bpp
https://demo-res.cloudinary.com/w_1.0/q_100/f_jpg/sample 10 1.0 864 576 118834 0.00000000 1.91026877572016
https://demo-res.cloudinary.com/w_1.0/q_90/f_jpg/sample 90 1.0 864 576 117096 0.00088174 1.88233024691358
https://demo-res.cloudinary.com/w_1.0/q_80/f_jpg/sample 80 1.0 864 576 98547 0.00484380 1.58415316358025
https://demo-res.cloudinary.com/w_1.0/q_70/f_jpg/sample 70 1.0 864 576 80775 0.01161613 1.29846643518519
https://demo-res.cloudinary.com/w_1.0/q_60/f_jpg/sample 60 1.0 864 576 70452 0.01496385 1.13252314814815
https://demo-res.cloudinary.com/w_1.0/q_50/f_jpg/sample 50 1.0 864 576 64231 0.01784463 1.03251993312757
https://demo-res.cloudinary.com/w_1.0/q_40/f_jpg/sample 40 1.0 864 576 56898 0.02301142 0.914641203703704
https://demo-res.cloudinary.com/w_1.0/q_30/f_jpg/sample 30 1.0 864 576 45466 0.03035985 0.730870627572016
https://demo-res.cloudinary.com/w_1.0/q_20/f_jpg/sample 20 1.0 864 576 33929 0.04365382 0.54541216563786
We can't make this file beautiful and searchable because it's too large.
"url","width","height","scale","quality","bytes","bits_per_painted_pixel","ssimulacra","dssim","psnr"
"https://res.cloudinary.com/eric-cloudinary/image/upload/wikipedia-photos/001","1276","850","1","undefined","1537493","11.340534759358288","0.0","0.0","inf"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_100,f_jpg/wikipedia-photos/001","1276","850","1.0","100","1086961","8.017414715102342","0.00148977","0.000186","52.3037"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_90,f_jpg/wikipedia-photos/001","1276","850","1.0","90","290198","2.140497879402545","0.01290557","0.002203","40.8954"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_80,f_jpg/wikipedia-photos/001","1276","850","1.0","80","163329","1.20471325834409","0.02397329","0.005460","37.2462"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_70,f_jpg/wikipedia-photos/001","1276","850","1.0","70","125291","0.9241453070256316","0.03145422","0.008249","35.7221"
"https://res.cloudinary.com/er
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 13 columns, instead of 3. in line 5.
url,originalWidth,originalHeight,originalBytes,scale,quality,byteSize,bitsPerPaintedPixel,savingsRatio,ssiumulacra,dssim,psnr,butteraugli
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_100,f_jpg/wikipedia-photos/001",1276,850,858800,1,100,1086961,8.017414715102342,1.26567419655333,0.00148977,0.000186,52.3037,0.718803
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_90,f_jpg/wikipedia-photos/001",1276,850,858800,1,90,290198,2.140497879402545,0.337911038658593,0.01290557,0.002203,40.8954,2.4695
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_80,f_jpg/wikipedia-photos/001",1276,850,858800,1,80,163329,1.20471325834409,0.19018281322776,0.02397329,0.00546,37.2462,3.223867
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_70,f_jpg/wikipedia-photos/001",1276,850,858800,1,70,125291,0.9241453070256316,0.14589077782953,0.03145422,0.008249,35.7221,4.04568
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_60,f_jpg/wikipedia-photos/001",1276,8
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 13 columns, instead of 8. in line 5.
url,originalWidth,originalHeight,originalBytes,scale,quality,byteSize,bitsPerPaintedPixel,savingsRatio,ssimulacra,dssim,psnr,butteraugli
https://res.cloudinary.com/eric-cloudinary/image/upload/wikipedia-photos/001,1276,850,858800,1,undefined,1537493,11.340534759358288,1.79028062412669,0,0,inf,0
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_100,f_jpg/wikipedia-photos/001",1276,850,858800,1,100,1086961,8.017414715102342,1.26567419655333,0.00148977,0.000186,52.3037,0.718803
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_90,f_jpg/wikipedia-photos/001",1276,850,858800,1,90,290198,2.140497879402545,0.337911038658593,0.01290557,0.002203,40.8954,2.4695
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_80,f_jpg/wikipedia-photos/001",1276,850,858800,1,80,163329,1.20471325834409,0.19018281322776,0.02397329,0.00546,37.2462,3.223867
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_70,f_jpg/wikipedia-photos/001",1276,850,858800,1,70,125291,0.92414530702563
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 13 columns, instead of 8. in line 5.
url,originalWidth,originalHeight,originalBytes,scale,quality,byteSize,bitsPerPaintedPixel,savingsRatio,ssimulacra,dssim,psnr,butteraugli
https://res.cloudinary.com/eric-cloudinary/image/upload/wikipedia-photos/001,1276,850,858800,1,undefined,1537493,11.340534759358288,1.79028062412669,0,0,inf,0
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_100,f_jpg/wikipedia-photos/001",1276,850,858800,1,100,1086961,8.017414715102342,1.26567419655333,0.00148977,0.000186,52.3037,0.718803
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_90,f_jpg/wikipedia-photos/001",1276,850,858800,1,90,290198,2.140497879402545,0.337911038658593,0.01290557,0.002203,40.8954,2.4695
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_80,f_jpg/wikipedia-photos/001",1276,850,858800,1,80,163329,1.20471325834409,0.19018281322776,0.02397329,0.00546,37.2462,3.223867
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_70,f_jpg/wikipedia-photos/001",1276,850,858800,1,70,125291,0.92414530702563
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
url,originalWidth,originalHeight,originalBytes,scale,quality,byteSize,bitsPerPaintedPixel,savingsRatio,ssimulacra,dssim,psnr,butteraugli
"https://res.cloudinary.com/eric-cloudinary/image/upload/wikipedia-photos/001","1276","850","1537493","1","undefined","1537493","11.340534759358288","undefined","0.0","0.0","inf","0.0"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_100,f_jpg/wikipedia-photos/001","1276","850","1537493","1.0","100","1086961","8.017414715102342","NaN","0.00148977","0.000186","52.3037","0.718803"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_90,f_jpg/wikipedia-photos/001","1276","850","1537493","1.0","90","290198","2.140497879402545","NaN","0.01290557","0.002203","40.8954","2.469500"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_80,f_jpg/wikipedia-photos/001","1276","850","1537493","1.0","80","163329","1.20471325834409","NaN","0.02397329","0.005460","37.2462","3.223867"
"https://res.cloudinary.com/eric-cloudinary/image/upload/w_1.0,q_70,f_
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
file ssimulacra mean_opinion_score
i01_10_1.bmp 0.03280812 5.97297
i01_10_2.bmp 0.05361108 5.94595
i01_10_3.bmp 0.10545110 4.91667
i01_10_4.bmp 0.20741088 3.21622
i01_10_5.bmp 0.32883978 2.08108
i02_10_1.bmp 0.04410916 6.00000
i02_10_2.bmp 0.06837454 5.97222
i02_10_3.bmp 0.12411026 5.43243
i02_10_4.bmp 0.22185609 3.50000