Interesting idea. You mean any app that works with postgress would as well run with a nostr adapter instead?
In a way SQL is synchronous and stateless, while NOSTR is asynchronous and stateful, a streaming api subscribing for future updates. Would a SQL query return when the relay sends EOSE?
earthcuddle
npub19v…0m7ps
2026-01-27 12:22:42 UTC
in reply to nevent1q…yvxz
Author Public Key
npub19vw7zdr07yyhdw8ns3d26c26n70mh2090d4cr6m24c8ee8wjpq0qg0m7psSeen on
wss://nostr.momPublished at
2026-01-27 12:22:42 UTCEvent JSON
{
"id": "c6b6d377a1cd3396f1beeb182594f1424016c38b2edb2a91208041f47595a694",
"pubkey": "2b1de1346ff10976b8f3845aad615a9f9fbba9e57b6b81eb6aae0f9c9dd2081e",
"created_at": 1769516562,
"kind": 1,
"tags": [
[
"e",
"ab76ecfee12c8ce7ebd8680c30c9ea732c7a731141652027417b7d09763c93ab",
"",
"root"
],
[
"e",
"c13dacea91c4a9142ee763d476776addf559a7bb677e95bf8bdedbf28ce74b98",
"",
"reply"
],
[
"p",
"c7eda660a6bc8270530e82b4a7712acdea2e31dc0a56f8dc955ac009efd97c86"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d"
],
[
"p",
"2b1de1346ff10976b8f3845aad615a9f9fbba9e57b6b81eb6aae0f9c9dd2081e"
]
],
"content": "Interesting idea. You mean any app that works with postgress would as well run with a nostr adapter instead?\n\n In a way SQL is synchronous and stateless, while NOSTR is asynchronous and stateful, a streaming api subscribing for future updates. Would a SQL query return when the relay sends EOSE?",
"sig": "cf775ac16c310b941516ec863d43074ea992d3e8deda537753e9e1b9c26ed43b84059480b88c136a082443837f5cc470dd846547e7559307cc55030a7d0f9e3c"
}