SQLite 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 [link] [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 [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.