hacker_news_posts_atom (view)
2 rows where "atom_updated" is on date 2024-04-09
This data as json, atom, copyable, CSV (advanced)
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
39983219 | A solid pattern to build LLM Applications | https://simonwillison.net/2024/Apr/9/a-solid-pattern-to-build-llm-applications/ | https://news.ycombinator.com/item?id=39983219 | 2024-04-09T19:28:42Z | Submitter: tosh - 3 points, 0 comments |
39979031 | Building files-to-prompt using Claude 3 Opus | https://simonwillison.net/2024/Apr/8/files-to-prompt/ | https://news.ycombinator.com/item?id=39979031 | 2024-04-09T13:07:49Z | Submitter: chedar - 4 points, 0 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;