rot13maxi on Nostr: sqlite is all you ever need ...
sqlite is all you ever need
Switched from postgres to sqlite for wss://powrelay.xyz
Much snappier now. Tried moving all the events but there might be a couple I missed, just rebroadcast if one of yours is missing 😅
Published at
2023-05-31 02:59:15Event JSON
{
"id": "78e99f5eb1f3e06c6472e6e7a0a995ec7d55288d4c43e6023eaca5e81b772e2e",
"pubkey": "d987084c48390a290f5d2a34603ae64f55137d9b4affced8c0eae030eb222a25",
"created_at": 1685501955,
"kind": 1,
"tags": [
[
"q",
"000006f6478f1eeb026b36b08ebcbb255ebca513b6fd29b0aca984cc9c2d93c9"
],
[
"p",
"27a9ee7edc5486882d7acd61e6631ff18a09e99b6ee5e45906f1d0dc60c61f5f"
]
],
"content": "sqlite is all you ever need nostr:note1qqqqdaj83u0wkqntx6cga09my40tefgnkm7jnv9v4xzve8pdj0ystt8s6y",
"sig": "4272a5f8c2219d2f2eea8977048fc63580fff1de4448ba7c8361877f5ec59efe5e694c15e5bb1cbab241536e775b62bb28943483f10d50d6bea4c2cd674d3a25"
}
