Thanks. I may reconsider and start off with Postgres. I want to make a command line tool that anyone can download/run to get metadata and statistics about relays and interactions, hence wanting Sqlite for ease of use. It should give info that's more in-depth than a normal client would show, but not a monstrous Hadoop thing. I want it to be able to answer questions like, "Is such-and-such relay dropping my events specifically, or is it broken?" or "Which relays are filtering such-and-such words?" But I also want it to be able to reconstruct conversations, social graphs, and trends eventually to prove that Nostr is one big circlejerk or to find the pockets of people who don't just talk about zaps.
Sounds like Postgres is probably the way to go. It supports arrays semi-natively, too, which may help solve the nip01 tags problem a little more easily.
victor /
npub16h…axymy
2023-03-19 13:41:28
in reply to nevent1q…r2hz
Author Public Key
npub16h43mvfanfmsvkg86vgqwr4h268l23t6034wulepd0m4j3dky9ssraxymyPublished at
2023-03-19 13:41:28Event JSON
{
"id": "2e92f41ec18a525f4dd3dcdbc19604fe8a2c126305aeba8272278272889cd7c8",
"pubkey": "d5eb1db13d9a77065907d310070eb7568ff5457a7c6aee7f216bf75945b62161",
"created_at": 1679233288,
"kind": 1,
"tags": [
[
"e",
"6b72b73f963f97268bba1e79d19af5522859cbaf670a03073245dc808762dfc7",
"",
"root"
],
[
"e",
"1a33f0ca5d2855c72d8ccb12efc11250a742c9242b47e3c5dda88b250c01a45c",
"",
"reply"
],
[
"p",
"d5eb1db13d9a77065907d310070eb7568ff5457a7c6aee7f216bf75945b62161"
],
[
"p",
"3baabe4d008648b5438bfe3180e3d443cbc36478fbabb65007099a96a1c56922"
]
],
"content": "Thanks. I may reconsider and start off with Postgres. I want to make a command line tool that anyone can download/run to get metadata and statistics about relays and interactions, hence wanting Sqlite for ease of use. It should give info that's more in-depth than a normal client would show, but not a monstrous Hadoop thing. I want it to be able to answer questions like, \"Is such-and-such relay dropping my events specifically, or is it broken?\" or \"Which relays are filtering such-and-such words?\" But I also want it to be able to reconstruct conversations, social graphs, and trends eventually to prove that Nostr is one big circlejerk or to find the pockets of people who don't just talk about zaps.\n\nSounds like Postgres is probably the way to go. It supports arrays semi-natively, too, which may help solve the nip01 tags problem a little more easily.",
"sig": "f5bf37c182d6582a9c720941188b4a77eb6d861b6a0466fc1c7280734c8f8168c69df01d20cc9ea681f1a75228daa8caf71c5085793596c9e26c6ca2c4d13b2e"
}