npub105ve72qqmjxz08skum2lkds9qkj67689djwwr2a0qkrxts3hqydqm9hk8p (npub105v…hk8p)
I thought it was common these days to use UUIDs generated at the application layer as keys? Then no insert-select is needed, you already have the key.
My current employer has a team gradually migrating our schema to that model.
firebreathingduck /
npub1dk…3vsdp
2023-08-18 12:35:06
in reply to nevent1q…ya67
Author Public Key
npub1dkv5khjgwhaxke6m2rns3ap3hcgzp2h3j7cpmysx3q6dtw7yqeesa3vsdpPublished at
2023-08-18 12:35:06Event JSON
{
"id": "5892c1cd7c23577dcd433bff0f68668dd64fe8960543164baa38d24e24a96331",
"pubkey": "6d994b5e4875fa6b675b50e708f431be1020aaf197b01d92068834d5bbc40673",
"created_at": 1692362106,
"kind": 1,
"tags": [
[
"p",
"7d199f2800dc8c279e16e6d5fb360505a5af68e56c9ce1abaf058665c237011a",
"wss://relay.mostr.pub"
],
[
"p",
"678fbdf04a787406ea6ccc5fd35c1cf57ac74ea9d0aa81df88f7a941f57e75e3",
"wss://relay.mostr.pub"
],
[
"e",
"146356512420c37785f3b773c99c0d409ece5d2a912d2c9c6cc0f28ce9e4ba0d",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://social.vivaldi.net/users/firebreathingduck/statuses/110910642981213277",
"activitypub"
]
],
"content": "nostr:npub105ve72qqmjxz08skum2lkds9qkj67689djwwr2a0qkrxts3hqydqm9hk8p \n\nI thought it was common these days to use UUIDs generated at the application layer as keys? Then no insert-select is needed, you already have the key.\n\nMy current employer has a team gradually migrating our schema to that model.",
"sig": "ce6b93c5fe5dc9e59007d48edb3a7835056b29bb3e1a1cbddebaeac919f56d750d102fa0897170bd340669e05789810f46ef6f6d4a6c3e932011a62702c703f3"
}