jb55 on Nostr: Damus used to run on sqlite but it couldn’t handle the load, even with optimized ...
Damus used to run on sqlite but it couldn’t handle the load, even with optimized queries. lmdb is the only thing that doesn’t fall over atm.
jb55 / Will
npub1xts…kk5s
2023-07-24 20:31:35
in reply to nevent1q…6s22
Author Public Key
npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5sPublished at
2023-07-24 20:31:35Event JSON
{
"id": "a8d9c0ea0ccca2fc478e74b9048fc26946030774bb683d01676471ed0b191fe1",
"pubkey": "32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"created_at": 1690230695,
"kind": 1,
"tags": [
[
"e",
"51c9870e994e0602f9eaeb5e53bff782d0ad2e8f91b1bc126c7e3bd822196a97",
""
],
[
"e",
"639077125b17240548f785f4c2c31f05f9920e87f7a048e43a4387f8ed90e913"
],
[
"p",
"604e96e099936a104883958b040b47672e0f048c98ac793f37ffe4c720279eb2"
],
[
"p",
"c6f7077f1699d50cf92a9652bfebffac05fc6842b9ee391089d959b8ad5d48fd"
],
[
"p",
"50c59a1cb233d08d5a1fb493f520c6b5d7f77a2ba42e4666801a3e366b0a027e"
],
[
"p",
"7cc328a08ddb2afdf9f9be77beff4c83489ff979721827d628a542f32a247c0e"
],
[
"p",
"4ea843d54a8fdab39aa45f61f19f3ff79cc19385370f6a272dda81fade0a052b"
]
],
"content": "Damus used to run on sqlite but it couldn’t handle the load, even with optimized queries. lmdb is the only thing that doesn’t fall over atm.",
"sig": "f5908ab858e4eed18b94191a24f3d61b3d8f9c2be7ca2ed26cfec0e17d54d0125668e05f559ae4c13456fa7b8902971ae2c4e6d3730aeb41909a1a65fd5bcf42"
}