github.com/HTTPArchive/bigquery commits | Ecosyste.ms: OpenCollective

Always will be WHERE clause in lens join

fbbfc9e7dd8eaf063213bac1fb71aa680a1fac10 authored over 3 years ago by Barry <[email protected]>

Fix blink usage

947b07534432a50acbe0d942b352cd15c0c8f480 authored over 3 years ago by Barry <[email protected]>

Fix typo

58cb0221e208034499a1dd4b0f132d762becf0ba authored over 3 years ago by Barry <[email protected]>

Fix date join

8d8102247d4f9f444ef29fb1d19569f967f22da0 authored over 3 years ago by Barry <[email protected]>

Fix typo

f1780c2cfdd03e9053c51c5ccaebc6b35640aa65 authored over 3 years ago by Barry <[email protected]>

Fix CrUX historgrams

b81efd67152a7b6679aa90c565a2a34d0a4f27eb authored over 3 years ago by Barry <[email protected]>

Fix blink timeseries

74437988f1296e41027c377697ada5a5837616b5 authored over 3 years ago by Barry <[email protected]>

Remove comment

cfbdfef7493071e58fb07316676bf3eafe04bbc6 authored over 3 years ago by Barry <[email protected]>

Change comment

a50d66e75f64a34b5dd048cdfb894e9df15b46f3 authored over 3 years ago by Barry <[email protected]>

tabs and spaces

2ffff4f6a077eb3b3f87f9b2f5b5e6b8fa18a2da authored over 3 years ago by Barry <[email protected]>

Handle date queries for blink_features

e32a605e28bbf32a11aa1565ba135020e766bdb2 authored over 3 years ago by Barry <[email protected]>

Fix response_bodies pipeline (#123)

* python dataflow pipeline

* fix response_bodies

9f5d97f1a435421fb930cb503989776a0b126998 authored over 3 years ago by Rick Viscomi <[email protected]>

improve comment

9441886bcd6f14bca202741f33c4a8b24a34b700 authored over 3 years ago by Barry <[email protected]>

Support blink timeseries for ranking joins

2f8ef6cbafcdf6dc96e0b9442874b6117cba3934 authored over 3 years ago by Barry <[email protected]>

Fogot to hit save

36a8d6366118b5c1db6376450e293c9b9de46126 authored over 3 years ago by Barry <[email protected]>

Add remiaingin lenses and make it <= so

423335057c4cc40033847654aaa89cb6ace6fdf3 authored over 3 years ago by Barry <[email protected]>

Support histograms

2ff112173278b73dd4e30fb06f3b1d1d07ba728e authored over 3 years ago by Barry <[email protected]>

Improved timeseries queries

566d033254d4ab06ea94e2808a6514cb6be910bc authored over 3 years ago by Barry <[email protected]>

Add ranking lenses

1c221c861726c0a0668a3751e7052d78ac7cd506 authored over 3 years ago by Barry <[email protected]>

Merge pull request #120 from HTTPArchive/add-editor-config

Add editorconfig file

df52822ac82ae4b37af9c34b852bef13486cc458 authored over 3 years ago by Barry Pollard <[email protected]>

Add editorconfig file

d20dd9175d63737f231e569dd7c441f33ac9ce71 authored over 3 years ago by Barry <[email protected]>

Merge pull request #119 from HTTPArchive/rawvalues-numericvalue-histograms

Fix histograms for rawValue

109858dbc6aa9b219320c57312a27bf93096d495 authored over 3 years ago by Barry Pollard <[email protected]>

Fix histograms for rawValue

d96cb2a31d973fad7b24dbcabb4c2606a125dbce authored over 3 years ago by Barry <[email protected]>

Merge pull request #118 from HTTPArchive/rawvalues-numericvalue

Switch from rawValue to numericValue for three reports

170c50a0341eaede899ac3fa1beb2a2a84a3aad0 authored over 3 years ago by Barry Pollard <[email protected]>

Prefer numericValue

1345599e915789fb1a431895daa185c8a1f99c1d authored over 3 years ago by Barry <[email protected]>

Switch from rawValue to numericValue

ba395338e25791ab40abd913dccfefc0ab08527e authored over 3 years ago by Barry <[email protected]>

Merge pull request #117 from HTTPArchive/incremental-time-series-fix2

Second fix for timeseries

972d312e1ec922247a06d4def53e122c2c920f23 authored over 3 years ago by Barry Pollard <[email protected]>

Second fix for timeseries

f77e81241758a7cd55f0495032301519e1e52411 authored over 3 years ago by Barry <[email protected]>

Merge pull request #116 from HTTPArchive/incremental-time-series-fix

Fix incremental timeseries bug introduce with recent report changes

8a588813383b364aba4b839c9516f27389ad0de6 authored over 3 years ago by Barry Pollard <[email protected]>

Fix incremental timeseriesa bug

cb900491313189501a914a459f791e8f24928070 authored over 3 years ago by Barry <[email protected]>

Merge pull request #114 from HTTPArchive/a11y-scores-fix

Stop a11yscore crashing on large lighthouse payloads

1816e084b1da6093c983a8586fbc995e307fedb4 authored over 3 years ago by Barry Pollard <[email protected]>

Add space

04479fca42069548fa0d44e9a9543699aee383ad authored over 3 years ago by Barry <[email protected]>

Add DETERMINISTIC to PWA UDF

dd281fc5f1b19ff5ec093b48c83b6b207d3a2966 authored over 3 years ago by Barry <[email protected]>

Merge pull request #115 from HTTPArchive/incremental-timeseries

Incremental time series

e316b8f40bcea6fe47b4b214604a415a3d334d1e authored over 3 years ago by Barry Pollard <[email protected]>

Review feedback + add PWA optimisation

8ddc5e6f138587b58c46bc7d991efa58d559b301 authored over 3 years ago by Barry <[email protected]>

Change percentiles

Co-authored-by: Rick Viscomi <[email protected]>

d8214d328ddabcd388be498bf8b51d2651e1931c authored over 3 years ago by Barry Pollard <[email protected]>

More comments

22e452f5b894f63f427bbe69ba22d43abcf6210d authored over 3 years ago by Barry <[email protected]>

Add missing flag

e1c210d6d8a26d5303c0cb9ca41900881ba7b0f6 authored over 3 years ago by Barry <[email protected]>

Make timeseries incremental

d72fc66ad4df2e76b40220acace9f57d03a702b2 authored over 3 years ago by Barry <[email protected]>

Add comment

26431f53da19a59069e0c703fb92325d86a036e8 authored over 3 years ago by Barry <[email protected]>

Stop a11yscore crashing on large lighthouse payloads

29c72f903cfbdf3cf9a451c6f549f29293ea208c authored over 3 years ago by Barry <[email protected]>

Merge pull request #113 from HTTPArchive/fixing-timing-bug

Fix typo in timing logic

490b75d77d90d6a1f2750f2874d00c4ce684121b authored over 3 years ago by Barry Pollard <[email protected]>

Fix typo in timing logic

cc2c45abd9c4e9a47e089cfe1a0713c09c146b24 authored over 3 years ago by Barry <[email protected]>

Add HTTP/3 SQL query (#111)

* Add HTTP/3 SQL query

* Update sql/timeseries/h3.sql

Co-authored-by: Rick Viscomi <rvisco...

093750271057b94a4c763e175e4592f0e488042d authored over 3 years ago by Barry Pollard <[email protected]>

Merge pull request #109 from HTTPArchive/add-query-timings

Add query timings

274641c835f9c091cd0b459a4bae643ce588fcb4 authored over 3 years ago by Barry Pollard <[email protected]>

Add query timings to help us know which ones to optimise first

c6b03f90a8ce79aa606bcdc1937bac95febb5b55 authored over 3 years ago by Barry <[email protected]>

Adds lens CrUX timeseries and skips queries which can't generate (#108)

842f0aec020ecdb1046ae258e66efbdcc0dd0655 authored over 3 years ago by Barry Pollard <[email protected]>

Merge pull request #107 from HTTPArchive/crux-sites-instead-avg

Change CrUX queries to look at number of sites that passed

a70cc8c17491dc3b9e47374789060a970c4412a3 authored over 3 years ago by Barry Pollard <[email protected]>

Only FID is optional for CWV

4135c7758a8e2139a9928bc44f449e21569f0b21 authored over 3 years ago by Barry <[email protected]>

Remove comma

d624f02e361580769372fbb94d8449a42beeb74a authored over 3 years ago by Barry <[email protected]>

Handle null CWV values

8e6e828f00e0e565181a731a751214d633dfb847 authored over 3 years ago by Barry <[email protected]>

Review feedback

765b66b52351c280b4c75fbdafef80f78a07289a authored over 3 years ago by Barry <[email protected]>

Add passes Core Web Vitals query

f85f3e7b782eb9f4232b2a3e2419d985c4578c38 authored over 3 years ago by Barry <[email protected]>

Spaces

7c7ec644fc64732ed4ecdb8fe699cc3461f8c084 authored over 3 years ago by Barry <[email protected]>

Change group by

2eb739fc6c2144559a67129115c40f906c81544b authored over 3 years ago by Barry <[email protected]>

Change CrUX queries to look at number of sites that pass, rather than average values per site

71447aa08cdade3e2b3c7aaae3e0dbd4a1335743 authored over 3 years ago by Barry <[email protected]>

Merge pull request #106 from HTTPArchive/cls-histogram

Add CLS histogram query

760836b56e8261c538ff6b71b9b91792528aef5e authored over 3 years ago by Barry Pollard <[email protected]>

Add CLS histrogram query

79dc48bc42f94f91c74b0153aa624623bf95b41e authored over 3 years ago by Barry <[email protected]>

Merge pull request #105 from HTTPArchive/crux-histograms

Add LCP histogram

e5c8f45e7d4b2715f3f781589abeab49e60117d2 authored over 3 years ago by Barry Pollard <[email protected]>

Add LCP histogram

516e96db567adcd99c6ad4ef4a57ddedb13c144e authored over 3 years ago by Barry <[email protected]>

Merge pull request #104 from HTTPArchive/crux-crontab3

Fix typo in cron

411ffedd2875db189b4fabd8e6ee939e034e9e35 authored over 3 years ago by Barry Pollard <[email protected]>

Fix typo in cron

959ea72938ac3627f126f2142e2cdf2e75d52372 authored over 3 years ago by Barry <[email protected]>

Merge pull request #103 from HTTPArchive/crux-crontab2

CrUX report fixes

7e152907851754849c32639cbf41c89a02e1d4f3 authored over 3 years ago by Barry Pollard <[email protected]>

Change to 15th day and fix bug

da3ec9936d1476d7a78c0515ce540729c8e35dcc authored over 3 years ago by Barry <[email protected]>

Merge pull request #102 from HTTPArchive/crux-crontab

Set up CrUX reports to run on cron

31ff8a8643b4d9c6e7a53777368a02ec8ce0e799 authored over 3 years ago by Barry Pollard <[email protected]>

Set up CrUX reports to run on cron

081ffe1b5e9f2f6b98fc0d829a94534e17a53e43 authored over 3 years ago by Barry <[email protected]>

Merge pull request #100 from HTTPArchive/crux-reports

Add ability to run just a subset of reports like CrUX

5bd3fc14f9bef7e7c316134742b70dd9d149ca8f authored over 3 years ago by Barry Pollard <[email protected]>

Merge pull request #101 from HTTPArchive/cls-fix

Fix CLS typo

5eef87b62bd2c169b58fb589133f6bff708f02ef authored over 3 years ago by Barry Pollard <[email protected]>

Fix CLS typo

9f0bbd719d8cd1d96ab72c3a9ff127b53cabc33d authored over 3 years ago by Barry <[email protected]>

Add ability to run ust a subset of reports like CrUX

d0aa67d9f42c225f82afbe2d5fa31d9c1e52d520 authored over 3 years ago by Barry <[email protected]>

Merge pull request #99 from HTTPArchive/fid-fix

Fix typo in FID query

eb3c979770059b9bd4d896e41b3f4df722c2e00d authored over 3 years ago by Barry Pollard <[email protected]>

Fix typo in FID query

ee80c2b640949828cc788d9de92c3e5585ef6c53 authored over 3 years ago by Barry <[email protected]>

Merge pull request #98 from HTTPArchive/add-core-web-vitals

Add CWV extracts

6cb2d1474579690f01605d56c6d20b4387c65c18 authored over 3 years ago by Barry Pollard <[email protected]>

Forgot to add the actual new queries!

bac243579f0ec7ee878f9956d8e5f0e7b202de4e authored over 3 years ago by Barry <[email protected]>

Add CVW extracts

6ed5b9122f2f86f4e75c73e89a704cb513c2ba07 authored over 3 years ago by Barry <[email protected]>

Merge pull request #95 from HTTPArchive/curx-timeseries-fix

Fix time series charts for CrUX Report

aeba40b814dd5e02ca9440e37a942f57c8d50a32 authored over 3 years ago by Barry Pollard <[email protected]>

Fix timseries charts for CrUX Report

1248d92cee2620b3dc0ed9793beafaaee3dadb60 authored over 3 years ago by Barry <[email protected]>

Create FUNDING.yml

acef15add27f0ba360fba44e2b74ab2575baed46 authored over 3 years ago by Rick Viscomi <[email protected]>

Reimplement HAR data pipeline with Apache Beam in Python (#93)

* python dataflow pipeline

* example dataflow job

* add support for LH, requests, and page...

3e190c0710e65df5407edec1670f70b2abc9f03d authored almost 4 years ago by Rick Viscomi <[email protected]>

Update imgLazy.sql (#92)

f13340daa3f21caeee01c0b86a5bc13b3b61fbf1 authored almost 4 years ago by Rick Viscomi <[email protected]>

Re-create webSocketStream.sql

b9c69b1901bc552d2e2ce5640dc3f040c6f17ad8 authored about 4 years ago by Thomas Steiner <[email protected]>

Point to the new Getting Started guide (#90)

The old link describes old BigQuery UI, and I found myself struggling to even find and add HTTP ...

cbc79335fc1775227ac08455ee1fb522b738f946 authored about 4 years ago by Ingvar Stepanyan <[email protected]>

Merge pull request #89 from HTTPArchive/remove-some-queries

Remove some queries

17a1bcd43e988f001405810be83ed71f3428db75 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete shapeDetectionText.sql

dd0d82bde3edd0ce234cc9b306bee5db6ff5bb3a authored about 4 years ago by Thomas Steiner <[email protected]>

Delete shapeDetectionFace.sql

fcf7cf2eeff269542dfdc8940b90a90bc20a9919 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webSocketStream.sql

01d1a616a3606a93ebbfcd7a8462dd7adae6d578 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete fileSystemAccess.sql

f4b3f52f68e3c3c7d6b2220db6b57a4651269e11 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webSerial.sql

99345aa68a17e1ffe1b55f634c879e607190a83e authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webNFCRead.sql

41a77896954388626cafb5370da905405ac081be authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webNFCWrite.sql

c2bd171917824a4cb7675ac8c37cbfb4008aab4c authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webShareNoFiles.sql

d33f8b095d1c58f6e0e83d174cda49860484b14e authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webShareContainingFiles.sql

4fff10e802e02bf187b46069d0f5bff16d456cbb authored about 4 years ago by Thomas Steiner <[email protected]>

Delete textFragment.sql

fda22e7cc2830f5e07ae4b17a9d42e134ae5b730 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webMIDI.sql

0aa73c0f3b21125bd831b1d6794e7c66dfa673a5 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webBluetooth.sql

7b3626271faa4e90b4b4bf231ef33b89f1fdb8ff authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webUSB.sql

9abe61a1d7a0a003921c17ec5e639004f40b065c authored about 4 years ago by Thomas Steiner <[email protected]>

Delete webOTP.sql

ffe6f7a714e3ab0bc4c3160eea27dabad2346a6b authored about 4 years ago by Thomas Steiner <[email protected]>

Delete shapeDetectionBarcode.sql

b58edf1a69c848b775d5d32b82935245b9862483 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete contactPicker.sql

2df19ae3efab028736ccf8b8f0fbfd82426363d0 authored about 4 years ago by Thomas Steiner <[email protected]>

Delete asyncClipboardWrite.sql

f848a57cbf7a65df8d4eed667001f15f31fe56dd authored about 4 years ago by Thomas Steiner <[email protected]>