Sibshops on Nostr: It still is trivial. If I want an audit trail in SQL, I can create a trigger function ...
It still is trivial. If I want an audit trail in SQL, I can create a trigger function to update an audit table.
Sibshops /
npub1hd…ypxgx
2024-07-08 21:57:16
in reply to nevent1q…85gz
Author Public Key
npub1hdyja62nzjkc5tk8mpwrshuygldzd80x2all75jsehy82ttynt3qqypxgxPublished at
2024-07-08 21:57:16Event JSON
{
"id": "e18105cb1606966b8bfd613fc3dba075f55fd19d30502eb7aaa04b27fab0fcca",
"pubkey": "bb492ee95314ad8a2ec7d85c385f8447da269de6577fff5250cdc8752d649ae2",
"created_at": 1720468636,
"kind": 1,
"tags": [
[
"p",
"bb492ee95314ad8a2ec7d85c385f8447da269de6577fff5250cdc8752d649ae2"
],
[
"p",
"968d1f61165b5a5ec16e1e839eca14335c34a1e8fba90f8440c0cdae4ca90edd"
],
[
"e",
"55a75911654611c798872a8edbf36cc980f295cb8df6a61b6b0881b2a136fc2e",
"",
"reply"
],
[
"proxy",
"https://mastodon.online/@Sibshops/112752632573756567",
"web"
],
[
"e",
"fe9739d2b6e0d5256ac44889d642a3ac89a7bc874fac2169a1135a545dd46e1f",
"",
"root"
],
[
"proxy",
"https://mastodon.online/users/Sibshops/statuses/112752632573756567",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://mastodon.online/users/Sibshops/statuses/112752632573756567",
"pink.momostr"
],
[
"expiration",
"1723060637"
]
],
"content": "It still is trivial. If I want an audit trail in SQL, I can create a trigger function to update an audit table.",
"sig": "2e35eced001a7f627605013e296e2d36fbcebd82e42e26d9c81cd4730b845de0bd547444b780f86ac805377f328495505b29d0398f910657e11e79bfaaf8a3e2"
}