SQLite User Forum

Suggestion on how to read the forums for latest items
Login

Suggestion on how to read the forums for latest items

(1) By Kevin Youren (KevinYouren) on 2021-05-23 21:18:57 [link] [source]

If you are interested in reading the forums in a similar way to reading the latest entries in a newsfeed ("Just In", etc), try these links.

Also makes it easier to do a search of the last few days.

For Sqlite & Fossil, I get the latest 100:

https://sqlite.org/forum/timeline?ss=v&y=f&n=100&vfx&nsm
https://fossil-scm.org/forum/timeline?ss=v&y=f&n=100&vfx&nsm

The Pikchr forum isn't changed often, I get the latest 50:

https://pikchr.org/home/timeline?ss=v&y=f&n=50&vfx&nsm

(2) By L Carl (lcarlp) on 2021-05-24 17:22:20 in reply to 1 [source]

Is there a query that will just show topics (one line per topic) that have had postings in the past 24 hours?

(3.3) By Stephan Beal (stephan) on 2021-05-24 18:23:44 edited from 3.2 in reply to 2 [link] [source]

Is there a query that will just show topics (one line per topic) that have had postings in the past 24 hours?

The days=N parameter is what you're looking for, but there's not a way to reduce the output to just the topic strings.

Example: /timeline?days=1&y=f

(Note that "N days" really means "N times 24 hours," so days=1 may span 2 days.)

Edit: adding &ss=c to the URL flags will reduce the output further but won't eliminate the timestamps.