Nothing in the specs mandate a relational DB.
One of the most performant relay implementations store the events in LMDB, a file based no-SQL database that's supposedly very efficient. https://github.com/hoytech/strfry
jb55 (npub1xts…kk5s) is also working on one such LMDB-backed database design. https://github.com/damus-io/nostrdb
Unhosted Marcellus
npub100…dfyy5
2023-07-24 23:39:41
in reply to nevent1q…7qx3
Author Public Key
npub100mahqlhxg50thmt5dyynu40nl25hat9kkkknzk8pqjfkvgq0xsqtdfyy5Published at
2023-07-24 23:39:41Event JSON
{
"id": "d582d53a7f6c119bacaa79fa1fce500b88501385f46505d3a1b1d5aa87f012c9",
"pubkey": "7bf7db83f73228f5df6ba34849f2af9fd54bf565b5ad698ac708249b310079a0",
"created_at": 1690241981,
"kind": 1,
"tags": [
[
"e",
"1b23500efda7cbb23f34e338ca0b02449f3f32258d5b150863af3305b530ac97",
"",
"reply"
],
[
"p",
"026d8b7e7bcc2b417a84f10edb71b427fe76069905090b147b401a6cf60c3f27"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"",
"mention"
],
[
"r",
"https://github.com/hoytech/strfry"
],
[
"r",
"https://github.com/damus-io/nostrdb"
]
],
"content": "Nothing in the specs mandate a relational DB.\n\nOne of the most performant relay implementations store the events in LMDB, a file based no-SQL database that's supposedly very efficient. https://github.com/hoytech/strfry\n\nnostr:npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5s is also working on one such LMDB-backed database design. https://github.com/damus-io/nostrdb",
"sig": "188979339c32b15939bbbf43e14d8bd30a1d20b7cdbd877de89f00760bc7eea7707b63a04d06ab4ca376bb6e8847b5e5f0d3313a059593fd00f5130690727911"
}