hacker_news_posts_atom (view)
2 rows where "atom_updated" is on date 2024-03-25
This data as json, atom, copyable, CSV (advanced)
atom_id | atom_title | url | atom_link | atom_updated | atom_content |
---|---|---|---|---|---|
39816988 | Building and testing C extensions for SQLite with ChatGPT Code Interpreter | https://simonwillison.net/2024/Mar/23/building-c-extensions-for-sqlite-with-chatgpt-code-interpreter/ | https://news.ycombinator.com/item?id=39816988 | 2024-03-25T14:46:10Z | Submitter: synergy20 - 1 points, 0 comments |
39814754 | Google Chrome –Headless Mode | https://til.simonwillison.net/chrome/headless | https://news.ycombinator.com/item?id=39814754 | 2024-03-25T11:07:41Z | Submitter: thunderbong - 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;