These are the indexes: https://github.com/hoytech/strfry/blob/master/golpe.yaml#L24-L47 (all the indexes have the created_at timestamp as a suffix). Now the query part I don't understand exactly how it works on strfry when you are querying for multiple different things.
I've used a similar scheme for the indexes here: https://github.com/fiatjaf/eventstore/blob/98cbffec7cc64773633c392de351586402418b7b/lmdb/helpers.go#L55-L139. But my query code is so complicated I don't even understand it myself anymore: https://github.com/fiatjaf/eventstore/blob/98cbffec7cc64773633c392de351586402418b7b/lmdb/query.go (it was simpler before, but mleku (npub1fjq…leku) complained I was using a bunch of goroutines unnecessarily so I did this and the performance has improved a lot).
But since you're starting from scratch and you're not afraid of including C dependencies on your Haskell app, I recommend trying to embed jb55 (npub1xts…kk5s)'s https://github.com/damus-io/nostrdb as it's made for this and more optimized for clients rather than relays.
fiatjaf /
npub180…jh6w6
2024-12-22 13:10:04
in reply to nevent1q…t2at
Author Public Key
npub180cvv07tjdrrgpa0j7j7tmnyl2yr6yr7l8j4s3evf6u64th6gkwsyjh6w6Published at
2024-12-22 13:10:04Event JSON
{
"id": "00002ada9bf7f8a1862a2b25efb3437c601d36504f5efd0984ee0b14fdd9dedf",
"pubkey": "3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d",
"created_at": 1734873004,
"kind": 1,
"tags": [
[
"p",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"3b8c97ae9286f01253c4f88d42d16e858c7c92513abf2f38251aff713514bce6"
],
[
"p",
"fa984bd7dbb282f07e16e7ae87b26a2a7b9b90b7246a44771f0cf5ae58018f52"
],
[
"e",
"7c1d55907113a4f7a70377e6e829aa67c4bcb5587a45d9ac605a37cf3de627ae",
"wss://wot.utxo.one/",
"root",
"3b8c97ae9286f01253c4f88d42d16e858c7c92513abf2f38251aff713514bce6"
],
[
"nonce",
"9223372036854812788",
"16"
]
],
"content": "These are the indexes: https://github.com/hoytech/strfry/blob/master/golpe.yaml#L24-L47 (all the indexes have the created_at timestamp as a suffix). Now the query part I don't understand exactly how it works on strfry when you are querying for multiple different things.\n\nI've used a similar scheme for the indexes here: https://github.com/fiatjaf/eventstore/blob/98cbffec7cc64773633c392de351586402418b7b/lmdb/helpers.go#L55-L139. But my query code is so complicated I don't even understand it myself anymore: https://github.com/fiatjaf/eventstore/blob/98cbffec7cc64773633c392de351586402418b7b/lmdb/query.go (it was simpler before, but nostr:npub1fjqqy4a93z5zsjwsfxqhc2764kvykfdyttvldkkkdera8dr78vhsmmleku complained I was using a bunch of goroutines unnecessarily so I did this and the performance has improved a lot).\n\nBut since you're starting from scratch and you're not afraid of including C dependencies on your Haskell app, I recommend trying to embed nostr:npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5s's https://github.com/damus-io/nostrdb as it's made for this and more optimized for clients rather than relays.",
"sig": "ec9c571f23ce79fa91ad077a3f586b8660ba91de41361959dbcc2a32b082a1d3e8cafc08d265143ef7f1de9716bcde2ed9286c5b47188047a6ab4ad72bb6ca48"
}