Makes sense. I am trying to get event id - hint + address - hint + pubkey - outbox relay pairs for 1M records each to fit within 3MB to aviod needing disk operations.
The interesting part is that I don't need to have table for keys or event IDs the app has seen. The 32bytes they need can all be fully discarded. If I need to load one specific event ID again, the 3MB index knows where to get it from.
Otherwise, just having 1M events in the phone is slows down even simple index management. :(
Vitor Pamplona
npub1gc…fnj5z
2025-03-22 18:52:28
in reply to nevent1q…dj5c
Author Public Key
npub1gcxzte5zlkncx26j68ez60fzkvtkm9e0vrwdcvsjakxf9mu9qewqlfnj5zPublished at
2025-03-22 18:52:28Event JSON
{
"id": "d404029e10607b56812a6a5e00d2ee7ea1d7af165ef38b511b470691984891c1",
"pubkey": "460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"created_at": 1742669548,
"kind": 1,
"tags": [
[
"alt",
"A short note: Makes sense. I am trying to get event id - hint + ..."
],
[
"e",
"3d1ef323d6fe8442bb076b3eaa3cb8501c83c6ad8c03a304a51be82a25484e01",
"",
"root"
],
[
"e",
"9495c28f81c7485ceea3362fb8cc9d0219993c115452998146a4ddefb80b0396",
"",
""
],
[
"e",
"0edf6cc72abd8dbdbe7754a64c0a797577b85635bd57aeb43e7e10d9d919023a",
"wss://relay.damus.io/",
"reply",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c",
"wss://vitor.nostr1.com/"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"wss://nostr.wine"
]
],
"content": "Makes sense. I am trying to get event id - hint + address - hint + pubkey - outbox relay pairs for 1M records each to fit within 3MB to aviod needing disk operations. \n\nThe interesting part is that I don't need to have table for keys or event IDs the app has seen. The 32bytes they need can all be fully discarded. If I need to load one specific event ID again, the 3MB index knows where to get it from.\n\nOtherwise, just having 1M events in the phone is slows down even simple index management. :(",
"sig": "a91a646fc5c9b5b264551b41e020fe1c66986917ba593333d662cfddf5520588f510ffbb0badf59236e624f27cef7a21448674dfbcd4fdb7406a7619ba8571a1"
}