hacker_news_posts_atom (view)
0 rows where "atom_updated" is on date 2023-07-27
This data as json, atom, copyable
atom_updated (date) 0 ✖
0 records
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;