3 ms·
Since this is a CSV on GitHub: https://github.com/getomni-ai/datasets/blob/main/hn_projects_dataset.csv https://github.com/getomni-ai/datasets/blob/main/hn_proj
by simonw 2y ago
Since this is a CSV on GitHub: https://github.com/getomni-ai/datasets/blob/main/hn_projects_dataset.csv https://github.com/getomni-ai/datasets/blob/main/hn_projects...
You can open it in Datasette Lite (WebAssembly in your browser) to run SQLite SQL against it like this:
https://lite.datasette.io/?csv=https://github.com/getomni-ai/datasets/blob/main/hn_projects_dataset.csv https://lite.datasette.io/?csv=https://github.com/getomni-ai...
Here's a SQL query showing just the open source projects focused on AI, for example: https://lite.datasette.io/?csv=https://github.com/getomni-ai/datasets/blob/main/hn_projects_dataset.csv#/data?sql=select+one_liner%2C+github_link%2C+comment%2C+hn_user+from+hn_projects_dataset+where+%22is_open_source%22+%3D+%3Ap0+and+%22project_industry%22+%3D+%3Ap1+order+by+rowid+limit+101&p0=true&p1=ARTIFICIAL_INTELLIGENCE https://lite.datasette.io/?csv=https://github.com/getomni-ai...
- pdyc 2y agohow is this opening it? i am getting cors errors on my tool, are you doing some server side processing?
- pdyc 2y agoanswering my own question. github raw content does not have cors problem. You can construct the raw content link from the normal github content link to download using fetch.
- samstave 2y agoTHIS IS FN DOPE. --- I need more examples of datasette! Thanks for showing this.
- simonw 2y agoTurns out I've shared a whole bunch of examples like this in comments here in the past! https://hn.algolia.com/?dateRange=all&page=0&prefix=false&query=lite.datasette.io&sort=byPopularity&type=comment https://hn.algolia.com/?dateRange=all&page=0&prefix=false&qu...
- samstave 2y agohttps://github.com/SoMaCoSF/CyberScraper-2077 https://github.com/SoMaCoSF/CyberScraper-2077 Need to figure out how to connect Datasette with CyberScraper. --- Heh - I forgot to look at your username. :-) long time fan. BTW I recall when you guys announced Lanyrd on YC.
- avghaloplayer 2y agoHey I am the developer behined cyberscraper-2077, I will look into your feature request :)