> add an extension to SQLite that enables handling external blobs in the same transactions as internal storage
In this specific case it is ok to write blobs, then if it's succeful to write the metadata, because the existence of a blob doesn't mean anything. I wouldn't explore any smarties for a backup program, but I'm curious as to what are the problems of storing them in db.
> My idea was more like accumulating N chunks of changes (or up to M files if they're smaller) before committing any of that to disk.
This is what pragma synchronous is about
https://sqlite.org/pragma.html#pragma_synchronous
> In WAL mode when synchronous is NORMAL (1), the WAL file is synchronized before each checkpoint and the database file is synchronized after each completed checkpoint and the WAL file header is synchronized when a WAL file begins to be reused after a checkpoint, but no sync operations occur during most transactions
rakoo
npub1y4…jh9df
2026-10-07 05:33:20 UTC
in reply to nevent1q…v5cr
Author Public Key
npub1y4k8zwggprw5xkyck08lz9ng82ujf43c0ml22grvf56mray42xmq8jh9dfPublished at
2026-10-07 05:33:20 UTCEvent JSON
{
"id": "0d2e3ef028eeae441d184818016714076dbb61ad5f9c279467f623ae560d63de",
"pubkey": "256c71390808dd435898b3cff116683ab924d6387efea5206c4d35b1f49551b6",
"created_at": 1791351200,
"kind": 1,
"tags": [
[
"p",
"9096c95c05b71521d6812b521bc02db89f6677a33ce3670d9af2bcfee5042497"
],
[
"e",
"3acaeda9aba45f18c5f17442b5187574dcf07ad2bb0c7810caf2f9aeee471550",
"",
"root",
"8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c"
],
[
"p",
"8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c"
],
[
"e",
"c7b3cbf6441f0bd5f4ff586d02f3dbdb42a4b755ad2c403c648ab78b33961760",
"",
"reply",
"8ab44a84fb757fea3c983e68a9bcc8e331fa49ed99cfcfd06a4499d542eae93c"
],
[
"p",
"256c71390808dd435898b3cff116683ab924d6387efea5206c4d35b1f49551b6"
],
[
"proxy",
"https://blah.rako.space/objects/e4a5f0af-70d3-4e40-81b5-022c0e8feb34",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://blah.rako.space/objects/e4a5f0af-70d3-4e40-81b5-022c0e8feb34",
"pink.momostr"
],
[
"-"
]
],
"content": "\u003e add an extension to SQLite that enables handling external blobs in the same transactions as internal storage\r\n\r\nIn this specific case it is ok to write blobs, then if it's succeful to write the metadata, because the existence of a blob doesn't mean anything. I wouldn't explore any smarties for a backup program, but I'm curious as to what are the problems of storing them in db.\r\n\r\n\u003e My idea was more like accumulating N chunks of changes (or up to M files if they're smaller) before committing any of that to disk.\r\n\r\nThis is what pragma synchronous is about\r\n\r\nhttps://sqlite.org/pragma.html#pragma_synchronous\r\n\r\n\u003e In WAL mode when synchronous is NORMAL (1), the WAL file is synchronized before each checkpoint and the database file is synchronized after each completed checkpoint and the WAL file header is synchronized when a WAL file begins to be reused after a checkpoint, but no sync operations occur during most transactions",
"sig": "e7b7e8f88915fea2778548935427aaa7da2de41476ae317a33b884ab1f74df44c55d70b61351042865df6b03cf6d2cc08fb49e914a3d26e4ff144e410eff3856"
}