Event JSON
{
"id": "f22ff60550ff1789d80a187d9a5b6c9dd69adc5f85953114d5271c01c74b7c1b",
"pubkey": "0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd",
"created_at": 1739721841,
"kind": 1,
"tags": [
[
"e",
"086ea8aa75bac1d422da3b14f8f8472434a6ab7aab60a560b175bdd82552fe32",
"wss://gleasonator.dev/relay",
"root",
"9e30e940238cd9ebebc6328176dd4d109812129442f2a6c38727fc66fa7ea90a"
],
[
"e",
"5b40f86b76293e53672ee18fe7c165f086967baa2f2ead95cf931b41f8f0e704",
"wss://gleasonator.dev/relay",
"reply",
"80caa3337d33760ee355697260af0a038ae6a82e6d0b195c7db3c7d02eb394ee"
],
[
"p",
"80caa3337d33760ee355697260af0a038ae6a82e6d0b195c7db3c7d02eb394ee",
"wss://gleasonator.dev/relay"
],
[
"p",
"63fe6318dc58583cfe16810f86dd09e18bfd76aabc24a0081ce2856f330504ed",
"wss://gleasonator.dev/relay"
],
[
"p",
"97c70a44366a6535c145b333f973ea86dfdc2d7a99da618c40c64705ad98e322",
"wss://gleasonator.dev/relay"
],
[
"p",
"3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d",
"wss://gleasonator.dev/relay"
],
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245",
"wss://gleasonator.dev/relay"
],
[
"p",
"ee11a5dff40c19a555f41fe42b48f00e618c91225622ae37b6c2bb67b76c4e49",
"wss://gleasonator.dev/relay"
],
[
"p",
"00000000827ffaa94bfea288c3dfce4422c794fbb96625b6b31e9049f729d700",
"wss://gleasonator.dev/relay"
],
[
"p",
"9e30e940238cd9ebebc6328176dd4d109812129442f2a6c38727fc66fa7ea90a",
"wss://gleasonator.dev/relay"
]
],
"content": "It's INSERT INTO with an ON CONFLICT clause. If the row doesn't exist, it's created. If it exists, the fields are updated in-place, which has much better performance than deleting the row and creating a new one.",
"sig": "835adebb5fe7a7798b6bbc90d3627b6b65e2286df184d286e2c227ee0294b39f96af8f7f7bb08ebbb24bbe335b5a2f007ace94b1da5c7784e3af81f9b1d6d29d"
}
