Hacker News Reader

Comment by gelatocar | Hacker News Reader

This is great, I've been meaning to build something similar for some time. I tried to run the queries from the tutorial but hit lots of CORS errors loading the datasets, is there any way that you have found to work around those?

View on HN

I'm sorry, I think I fixed this. Can you check? Thanks for letting me know!

Sorry, it seems to still be happening, running:

    SELECT count(*) FROM 'https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_2023-01.parquet';

Shows the error:

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_20.... (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.

I get the same issue in both firefox and brave

edit: actually accessing that file directly gets a Access Denied error for me

Sorry, can you please check again?

https://sql-workbench.com/#queries=v0,SELECT-count(*)-FROM-'...

Thanks!

Yep, looking good now, thanks! Other datasets that don't have CORS headers still don't work ie. https://sql-workbench.com/#config=%7B%22plugin%22%3A%22Datag... but I'm guessing that's inherent limitation of running this without a backend

Yes, unfortunately if the "foreign" sources don't support CORS, you'd have to use a CORS proxy... If you want to self-host, there's one at https://github.com/Zibri/cloudflare-cors-anywhere that can be deployed to CloudFlare Workers (the code is a bit messy though).

GitHub supports CORS for raw data for example, that's why I put it in the sample queries.

Reply on news.ycombinator.com