Web application to search the CrUX data from Google BigQuery API for multiple websites
- React Frontend + TypeScript
- Node.js Backend
- Axios for client side api handling
- Express for Backend api route hanlding
- Bootstrap for styling on the Frontend
- nodejs-bigquery library for managing query requests to BigQuery Database
- Clone the project using
git clone <repo_url>
command - run
cd client && touch .env && cd ..
- run
cd server && touch .env && cd ..
- under
client/.env
add the following keyREACT_APP_API_BASE_URL="http://localhost:4000"
- under
server/.env
add the following keyGCP_PROJECT_ID=<your gcp project id>
- Download
service account credentials
from gcp and save it underserver/big-query.json
. Refer here for more - run
cd client && yarn install && yarn start && cd ..
to run client onhttp://localhost:3000
- run
cd server && yarn install && yarn start && cd ..
to run server onhttp://localhost:4000
- Search CrUX data for a url
- Tabular data of the result
- Sorting on data fields and you can set the sorting by clicking/toggling on any data fields
- Filter data by enabling/disabling certain metrics from the table to view only particular data
- Support CrUX data for multiple urls searching
![Screenshot 2024-01-19 at 11 10 40 AM](https://private-user-images.githubusercontent.com/19742306/297965591-03ebe090-3356-43b2-8a12-57f7acceeb9c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkwNDk2NDAsIm5iZiI6MTczOTA0OTM0MCwicGF0aCI6Ii8xOTc0MjMwNi8yOTc5NjU1OTEtMDNlYmUwOTAtMzM1Ni00M2IyLThhMTItNTdmN2FjY2VlYjljLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMDglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjA4VDIxMTU0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWYxOTBlNjQzNGFkMDU5ZDI3NTM1YWIwNDk2YWMyOWUxYWFlNmJjNDFkY2JjYzI1YTcyYTUwYmZjODlmYTQzODUmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.Ar7-jrkvToHjosj9HeVWehOJ7kIrliwvadaAurP8ne8)
![Screenshot 2024-01-19 at 11 10 26 AM](https://private-user-images.githubusercontent.com/19742306/297965574-85dd46a0-305b-45db-be6d-208e879db666.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzkwNDk2NDAsIm5iZiI6MTczOTA0OTM0MCwicGF0aCI6Ii8xOTc0MjMwNi8yOTc5NjU1NzQtODVkZDQ2YTAtMzA1Yi00NWRiLWJlNmQtMjA4ZTg3OWRiNjY2LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMDglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjA4VDIxMTU0MFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTNlMTYxZGUxMTBiMTNhZjE4NTg3ODU1Y2RhYmY4ZWMzYTBhY2VjZjlmYzc2ZjczMWVmNGM0YzNiY2M0YWM5MzImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.-G4og_AU3uF1cDjc819eBmZXPJmgNDd2yXSpz-1exBI)