Simon Willison on Nostr: Some notes on working with consecutive groups in SQL using window functions, a ...
Published at
2023-06-08 19:03:38Event JSON
{
"id": "8916bf2c82fd85646e7489a8db5be143564125bf82a5f2f9b6784b1a6a8c80d2",
"pubkey": "8b0be93ed69c30e9a68159fd384fd8308ce4bbf16c39e840e0803dcb6c08720e",
"created_at": 1686251018,
"kind": 1,
"tags": [
[
"mostr",
"https://fedi.simonwillison.net/users/simon/statuses/110510146778404066"
]
],
"content": "Some notes on working with consecutive groups in SQL using window functions, a pattern I figured out today while playing with my Swarm checkin data https://til.simonwillison.net/sql/consecutive-groups",
"sig": "87ac8253b60621494b0120f807b528c58b76b021942490bfbd35ae3baeb2525eee70ab5ec9e915a3fccfa8be67bc79d06ec67331c6e906c22b482975581f4345"
}
