ChipTuner on Nostr: > also, SQL is a stupid way to store events when you don't need all that advanced ...
> also, SQL is a stupid way to store events when you don't need all that advanced search logic nor that many tables, plus it would be space inefficient due to all the extra indexes that come by default that are probably not possible to turn off even though the query logic doesn't need it
Sure, but it scales. I can stand up a dozen relays and load balance the databases with replicas. Might not be the most efficient, but I can make up for that with more of them. We need to be able to run dozens of relay instances off the same backend.
Published at
2025-03-05 16:48:04Event JSON
{
"id": "8ea5ca6db227b9016cba3a2b47010bdcfc609d82b7e698520228bba30f373523",
"pubkey": "036533caa872376946d4e4fdea4c1a0441eda38ca2d9d9417bb36006cbaabf58",
"created_at": 1741193284,
"kind": 1,
"tags": [
[
"e",
"d19cda77e2863418ff78bc5673ef6997f850c03c8ea718156d2e6bffdf6b226b",
"wss://nos.lol/",
"root"
],
[
"e",
"d72a43b88a0d12f18e612465a05f3098fdc568e701b8a04c50394b18c7787841",
"wss://nos.lol/",
"reply",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
],
[
"p",
"460c25e682fda7832b52d1f22d3d22b3176d972f60dcdc3212ed8c92ef85065c"
],
[
"p",
"0689df5847a8d3376892da29622d7c0fdc1ef1958f4bc4471d90966aa1eca9f2"
],
[
"p",
"036533caa872376946d4e4fdea4c1a0441eda38ca2d9d9417bb36006cbaabf58"
],
[
"p",
"4c800257a588a82849d049817c2bdaad984b25a45ad9f6dad66e47d3b47e3b2f"
]
],
"content": "\u003e also, SQL is a stupid way to store events when you don't need all that advanced search logic nor that many tables, plus it would be space inefficient due to all the extra indexes that come by default that are probably not possible to turn off even though the query logic doesn't need it\n\nSure, but it scales. I can stand up a dozen relays and load balance the databases with replicas. Might not be the most efficient, but I can make up for that with more of them. We need to be able to run dozens of relay instances off the same backend. ",
"sig": "1881badec18e0ba0eb1ee72271696bd9689e0379ce3721883b0b92e1469c6af9ae7d0747f79ebfdad0ba24f929df3fa6ed1e3f218a09c746f50bbac1c0f4e865"
}
