Cy on Nostr: Crap... window functions won't let you order by multiple columns. seconds/nanoseconds ...
Crap... window functions won't let you order by multiple columns. seconds/nanoseconds isn't going to work. Wait, but I put the timespec in a blob, I could make a collation that would—
sqlite only allows you to collate UTF-8 encoded text strings for no reason
ffffff....
Published at
2024-12-14 20:52:39Event JSON
{
"id": "783d9576b7089b92ede228861365f2710c200db4fc3b1e60668095517bee8b77",
"pubkey": "bd9bf6b093eae31b2d42eeab8d71227ea77991ac6a1c8e6861d64e8ba508c327",
"created_at": 1734209559,
"kind": 1,
"tags": [
[
"p",
"bd9bf6b093eae31b2d42eeab8d71227ea77991ac6a1c8e6861d64e8ba508c327",
"wss://relay.mostr.pub"
],
[
"e",
"b7a4b2c310e52835b913adf75477a6639e53d0e389878aadbb228092a8fc7993",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://fedicy.us.to/cy/p/1734209559.827322",
"activitypub"
]
],
"content": "Crap... window functions won't let you order by multiple columns. seconds/nanoseconds isn't going to work. Wait, but I put the timespec in a blob, I could make a collation that would—\nsqlite only allows you to collate UTF-8 encoded text strings for no reason\nffffff....\n",
"sig": "2967eb17fd6b863952a4af08e2a6664f5f097366486ac616ba5e697bedf91d887c97e8c2565abafed06231f6e033cb17695ac415bd8b153c6979f6a0a74e5f6f"
}
