search

GoogleChrome / webstatus.dev

A tool to monitor and track the status of all Web Platform features across dimensions that are related to availability and implementation quality across browsers, and adoption by web developers.
https://webstatus.dev
Apache License 2.0
103 stars 8 forks source link

Add new ChromiumUsage field to features search spanner logic #847

Closed DanielRyanSmith closed 1 week ago

DanielRyanSmith commented 2 weeks ago

Addresses #844

This is a small change to update the features search spanner logic to query for a new ChromiumUsage field.

DanielRyanSmith commented 1 week ago

Hey @jcscottiii, thanks for the direction here - I modified the query, and while it seems functional, it might not be efficient (I was not able to use ORDER BY inside the ARRAY_AGG function).

It took a while for me to get grasp the different tables for adding test data (took way too long to realize WebFeatureChromiumHistogramEnumValues and ChromiumHistogramEnumValues were two different tables that both needed data). Let me know if this is a better direction from my initial attempt - thanks!