This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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 | |
} ); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
"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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
OlderNewer