Semisol 👨💻 on Nostr: Instead of producing aggregate reports for everything, you can dump lots of data and ...
Instead of producing aggregate reports for everything, you can dump lots of data and then have CH crunch through it in seconds. And if you want you can add optimizations on top of that for common queries
Published at
2024-03-13 13:40:05Event JSON
{
"id": "3f86bc03927ba7d4d6e6c1f6c722e0484419057bbf1d40e885a778d1524145cd",
"pubkey": "52b4a076bcbbbdc3a1aefa3735816cf74993b1b8db202b01c883c58be7fad8bd",
"created_at": 1710337205,
"kind": 1,
"tags": [
[
"e",
"06b72c048566b048f5f72b4504e7fcd9f0958778f1df3534c1dad7baf44f1c9e"
],
[
"e",
"9304680388a53c92e55d0e110f2e218af7c093bf305b45056350fdc671e0f30e"
],
[
"p",
"e2ccf7cf20403f3f2a4a55b328f0de3be38558a7d5f33632fdaaefc726c1c8eb"
],
[
"p",
"efe5d120df0cc290fa748727fb45ac487caad346d4f2293ab069e8f01fc51981"
]
],
"content": "Instead of producing aggregate reports for everything, you can dump lots of data and then have CH crunch through it in seconds. And if you want you can add optimizations on top of that for common queries",
"sig": "a0833f3dee9e4c70088a91fdd79652586d899ba108544a4254ab330e2b81182a83bcf852e99e4aee811e0cc912d7d2a0b14225f5318b7856c482c484f048fb7c"
}