Terence Eden on Nostr: I want to create a "trending" page on my blog. For example, the most-read posts in ...
I want to create a "trending" page on my blog.
For example, the most-read posts in the last day / week / month / year / all time.
I've got the SQL query which will get that data.
But how should I present it in the URl?
VOTE NOW!
Published at
2024-12-08 13:59:11 UTCEvent JSON
{
"id": "00d22e8d5927fe04baef5f2aa824ef08576ed1f656fee69362cc6bd691e13c0b",
"pubkey": "350b4da116bd4aa32feaa4d36a4aa69b544e430946c2a9fa1ac43b3342652b3e",
"created_at": 1733666351,
"kind": 1,
"tags": [
[
"proxy",
"https://mastodon.social/@Edent/113617558024476073",
"web"
],
[
"proxy",
"https://mastodon.social/users/Edent/statuses/113617558024476073",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.social/users/Edent/statuses/113617558024476073",
"pink.momostr"
],
[
"-"
]
],
"content": "I want to create a \"trending\" page on my blog.\n\nFor example, the most-read posts in the last day / week / month / year / all time.\n\nI've got the SQL query which will get that data.\n\nBut how should I present it in the URl?\n\nVOTE NOW!",
"sig": "506c110bc77369222dd353e111553a90464129943cc75e11aeced0dc658eb8fcc6dc486bd7bfe5628dc6c6b2b181c594a32e7ab48c246b49935e4766c618293c"
}
