> Way more tractable.
It does still tie it in ways I find uncomfortable.
The metadata database being SQLite is sensible-enough. The risk of upstream going evil is somewhat mitigated by the strong stability that allows for just pinning it without consequence.
> sqlite provides the structure. blobs contain files content and nothing else.
Ah I see, yes, not conflating control & payload.
I would say structured binary formats would also provide the same loss of ambiguity, but they are more work if one can rely on SQLite (or something like LMDB, if you just go full key-value store).
> sqlite has that
I was under the impression it would be in the program using it. It does? I had thought unlike some [like PostgreSQL](https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-COMMIT-DELAY) it was missing this.
Would you have a link?
LisPi
npub132…qgzqx
2026-10-07 01:38:05 UTC
in reply to nevent1q…ajpg
Author Public Key
npub1326y4p8mw4l750yc8e52n0xguvcl5j0dn88ul5r2gjva2sh2ay7qjqgzqxSeen on
wss://relay.momostr.pinkPublished at
2026-10-07 01:38:05 UTCEvent JSON
{
"id": "7f268e41fa76ccd9f06c309eccf674c8b08679e3ac1a05ec48bd989892f85fb1",
"pubkey": "8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c",
"created_at": 1791337085,
"kind": 1,
"tags": [
[
"p",
"9096c95c05b71521d6812b521bc02db89f6677a33ce3670d9af2bcfee5042497"
],
[
"e",
"3acaeda9aba45f18c5f17442b5187574dcf07ad2bb0c7810caf2f9aeee471550",
"",
"root",
"8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c"
],
[
"e",
"f2cb0cba0a3078106345061ccc7b7d8c3d027d5cb699fbc9ef988b1ea3e53c21",
"",
"reply",
"256c71390808dd435898b3cff116683ab924d6387efea5206c4d35b1f49551b6"
],
[
"p",
"8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c"
],
[
"p",
"256c71390808dd435898b3cff116683ab924d6387efea5206c4d35b1f49551b6"
],
[
"proxy",
"https://udongein.xyz/objects/834976a1-1113-47da-bf3e-e34ecc08c0b4",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://udongein.xyz/objects/834976a1-1113-47da-bf3e-e34ecc08c0b4",
"pink.momostr"
],
[
"-"
]
],
"content": "\u003e Way more tractable.\r\n\r\nIt does still tie it in ways I find uncomfortable.\r\n\r\nThe metadata database being SQLite is sensible-enough. The risk of upstream going evil is somewhat mitigated by the strong stability that allows for just pinning it without consequence.\r\n\r\n\u003e sqlite provides the structure. blobs contain files content and nothing else.\r\n\r\nAh I see, yes, not conflating control \u0026 payload.\r\n\r\nI would say structured binary formats would also provide the same loss of ambiguity, but they are more work if one can rely on SQLite (or something like LMDB, if you just go full key-value store).\r\n\r\n\u003e sqlite has that\r\n\r\nI was under the impression it would be in the program using it. It does? I had thought unlike some [like PostgreSQL](https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-COMMIT-DELAY) it was missing this.\r\n\r\nWould you have a link?",
"sig": "b96634ff92799317bc2970c999254bd6a1b91dce68d4a762386a99d06d72af77b54a228c4224eee1b94e3d0de2f75e28e50a71ef8b8e0caed4207431df734ee7"
}