#GM & #PV my #nostr fam.
Nostr development question of the day.
How should store data for my app in my postgres database? Do I keep it all denormalized at rest and then create events on the fly when requested? Or do I store my data in event form at rest?
#asknostr
#grownostr
CC: jb55 (npub1xts…kk5s) Kieran (npub1v0l…qj49)
Ian
npub1pmh…uksr
2024-06-06 21:03:18
Author Public Key
npub1pmhevxtlt3478pvmdqt7dftnv6zc2mzpdc569yjm6ks4k2jhezcs53uksrPublished at
2024-06-06 21:03:18Event JSON
{
"id": "cebbaadfa98bed64f39c5d58b4fafd8e77750dcfa331ef67f601e64b6323ba43",
"pubkey": "0eef96197f5c6be3859b6817e6a5736685856c416e29a2925bd5a15b2a57c8b1",
"created_at": 1717700598,
"kind": 1,
"tags": [
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"",
"mention"
],
[
"p",
"63fe6318dc58583cfe16810f86dd09e18bfd76aabc24a0081ce2856f330504ed",
"",
"mention"
],
[
"t",
"GM"
],
[
"t",
"gm"
],
[
"t",
"PV"
],
[
"t",
"pv"
],
[
"t",
"nostr"
],
[
"t",
"asknostr"
],
[
"t",
"grownostr"
]
],
"content": "#GM \u0026 #PV my #nostr fam. \n\nNostr development question of the day.\n\nHow should store data for my app in my postgres database? Do I keep it all denormalized at rest and then create events on the fly when requested? Or do I store my data in event form at rest?\n\n#asknostr \n#grownostr\n\nCC: nostr:npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5s nostr:npub1v0lxxxxutpvrelsksy8cdhgfux9l6a42hsj2qzquu2zk7vc9qnkszrqj49",
"sig": "a8ec41c910f1622e359d63d26ff39fed6acea0122b940ba8540e455515954bc3511a5edf094196a00961bffbe35b669596aa4ae4bd60964b313f23fd2c0a5d05"
}