Martti Malmi on Nostr: Why not just SQL query filters :D "SELECT * FROM events WHERE kind = 0 LIMIT 10000 ...
Why not just SQL query filters :D "SELECT * FROM events WHERE kind = 0 LIMIT 10000 GROUP BY author"
Martti Malmi /
npub1g53…drvk
2023-01-10 15:04:56
in reply to nevent1q…4njj
Author Public Key
npub1g53mukxnjkcmr94fhryzkqutdz2ukq4ks0gvy5af25rgmwsl4ngq43drvkPublished at
2023-01-10 15:04:56Event JSON
{
"id": "7c93ddaa1edb79e548df64253c3a7afc5615a8095cc1265bde57932177958201",
"pubkey": "4523be58d395b1b196a9b8c82b038b6895cb02b683d0c253a955068dba1facd0",
"created_at": 1673363096,
"kind": 1,
"tags": [
[
"e",
"b59a2d45dc276c4043406b851965c6df302739d491ce26734a794ca6d317564e",
"wss://nostr.ono.re",
"reply"
],
[
"p",
"4523be58d395b1b196a9b8c82b038b6895cb02b683d0c253a955068dba1facd0"
],
[
"p",
"fef6bc34aae8088ff06fcd9165429b05e29a118f0e1f9ce5b1005e147dd1de64"
],
[
"p",
"4523be58d395b1b196a9b8c82b038b6895cb02b683d0c253a955068dba1facd0"
]
],
"content": "Why not just SQL query filters :D \"SELECT * FROM events WHERE kind = 0 LIMIT 10000 GROUP BY author\"",
"sig": "bcaaa0cc7dae1ba1cf38f40b25b0be9b93828341b3751859b033992091159b29f5f044318765fdd1841a576888e4c246cd82a9307bfcf644143337907845ff66"
}