Interesting take! I guess it’s probably better to sanitise once at insertion compared to do it each time you read the data, and also because it makes the DB portable since it’s supposed to be the source of truth.
I still like the idea of not taking this for granted, thou, and also because there might be use cases for saving non-sanitised data.
meduz' /
npub1ky…0ypyv
2024-09-18 00:27:24
in reply to nevent1q…vdgt
Author Public Key
npub1ky3nat6gzlxc9zmex5nd0vuck3vwse36zz4yp4u9p09n5l09sjjqm0ypyvPublished at
2024-09-18 00:27:24Event JSON
{
"id": "d781b8b94befaf7ded87f2105e08029104740b1b88eeca83275e5a50a2613d2c",
"pubkey": "b1233eaf4817cd828b793526d7b398b458e8663a10aa40d7850bcb3a7de584a4",
"created_at": 1726619244,
"kind": 1,
"tags": [
[
"p",
"9514f8f344dd309396ef36ea9ce44633165c2752c35cb9c52c0144ea8e14a8c0"
],
[
"proxy",
"https://m.nintendojo.fr/@meduz/113155718796386212",
"web"
],
[
"p",
"52f04f11cda0a1038ef7e6460046804a0e3e6dcac8ad2659070c91197292da98"
],
[
"e",
"2b4f7f35df8323cb96e6cb667d35bde64131d76becc1822596dd9f9f1680d8a0",
"",
"root",
"9514f8f344dd309396ef36ea9ce44633165c2752c35cb9c52c0144ea8e14a8c0"
],
[
"e",
"3c2d8cd1e3cb0ae1baf5189fc41305c30102e4666f79d2fb362f99c3ea230301",
"",
"reply",
"9514f8f344dd309396ef36ea9ce44633165c2752c35cb9c52c0144ea8e14a8c0"
],
[
"proxy",
"https://m.nintendojo.fr/users/meduz/statuses/113155718796386212",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://m.nintendojo.fr/users/meduz/statuses/113155718796386212",
"pink.momostr"
],
[
"-"
]
],
"content": "Interesting take! I guess it’s probably better to sanitise once at insertion compared to do it each time you read the data, and also because it makes the DB portable since it’s supposed to be the source of truth.\n\nI still like the idea of not taking this for granted, thou, and also because there might be use cases for saving non-sanitised data.",
"sig": "27412eade5d0943512168bf2185c245cf632e4b2b6fe9e4c6469c64e77acea9632f9a83a067f35314fced428d5ed8730058f0dc31fdf167c052e4c5d4e622fe6"
}