Interesting, are you saying that sqlite's jsonb implementation is slower than postresql's?
https://sqlite.org/draft/jsonb.html
taoeffect / Greg Slepak
npub16r…uklmh
2024-08-17 04:54:27
in reply to nevent1q…atln
Author Public Key
npub16r38ex4lrehkx0su57tm6wjweyytv5yqvqs9wver7mwvlz8y38eqkuklmhPublished at
2024-08-17 04:54:27Event JSON
{
"id": "9f4140f60e545a02f80e5f0c870a7cc86620ffb67ed282952b343865091e5e14",
"pubkey": "d0e27c9abf1e6f633e1ca797bd3a4ec908b650806020573323f6dccf88e489f2",
"created_at": 1723870467,
"kind": 1,
"tags": [
[
"p",
"d0e27c9abf1e6f633e1ca797bd3a4ec908b650806020573323f6dccf88e489f2"
],
[
"p",
"0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd"
],
[
"e",
"f9679417711a87cf6b17ebcb0f737f217c9aba28f446327ab971f8c1f516e1d4",
"wss://relay.primal.net",
"root"
],
[
"e",
"9485586f4b03ba7a2fb06db677291ab1553075bd7a6b2c60ce3d04114071d855",
"wss://relay.primal.net",
"reply"
]
],
"content": "Interesting, are you saying that sqlite's jsonb implementation is slower than postresql's?\nhttps://sqlite.org/draft/jsonb.html",
"sig": "ef050407165bd22bd98426e89c8b9533f41d24aab3860fa307e4468e43f0cbb9cedec23d22a40a01b155f7dce0ce44e4301b5266ef145d3b7cfebe98576df4d9"
}