hacker_news_posts_atom (view)
2 rows where "atom_updated" is on date 2024-04-25
This data as json, atom, copyable, CSV (advanced)
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
40157664 | Options for accessing Llama 3 from the terminal using LLM | https://simonwillison.net/2024/Apr/22/llama-3/#fast-api-access-via-groq | https://news.ycombinator.com/item?id=40157664 | 2024-04-25T13:57:24Z | Submitter: gmays - 1 points, 0 comments |
40154978 | Model behaviour is determined by your dataset, nothing else | https://simonwillison.net/2024/Apr/25/james-betker/ | https://news.ycombinator.com/item?id=40154978 | 2024-04-25T08:36:49Z | Submitter: scarecrow112 - 2 points, 1 comments |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW hacker_news_posts_atom as select id as atom_id, title as atom_title, url, commentsUrl as atom_link, dt || 'Z' as atom_updated, 'Submitter: ' || submitter || ' - ' || points || ' points, ' || numComments || ' comments' as atom_content from hacker_news_posts order by dt desc limit 100;