Simon Willison on Nostr: Figured out a new recipe for tracking SQLite table history using a JSON audit log and ...
Published at
2024-02-27 02:01:36Event JSON
{
"id": "5ca975c00c9c8c4fc6d79232bc8b391aa4bf692c7c30f7f6be35f13f040be704",
"pubkey": "8b0be93ed69c30e9a68159fd384fd8308ce4bbf16c39e840e0803dcb6c08720e",
"created_at": 1708999296,
"kind": 1,
"tags": [
[
"proxy",
"https://fedi.simonwillison.net/users/simon/statuses/112000977876726712",
"activitypub"
]
],
"content": "Figured out a new recipe for tracking SQLite table history using a JSON audit log and a somewhat terrifying set of nested json_patch() SQL functions\nhttps://til.simonwillison.net/sqlite/json-audit-log\n\nhttps://cdn.masto.host/fedisimonwillisonnet/media_attachments/files/112/000/975/479/352/526/original/65b4f26ba8168159.png",
"sig": "ba92f4b4ef4f281d9966b71385f79c078325b196345632833910205488d5fa7ff15bbfa104341fea485399c992b5a80588ce3717f5490959647ab3717a04ce48"
}
