Someone who has experience with SQL database design?
i wanna make a table where every item can have an arbitrary number of tags. What is the best way for achieving this? Comma separated values?
aetios /
npub1p3…ne87u
2024-07-01 12:53:03
Author Public Key
npub1p3qhh5c3tmm7tj3l607yrcgq8qul3n8t8zrhr65l5khz5r5uxdpsane87uPublished at
2024-07-01 12:53:03Event JSON
{
"id": "c3ff0b8694cd8ab7e20d413f8a35511a378a7f48fe69d67f3ae9d77bf0b6f35a",
"pubkey": "0c417bd3115ef7e5ca3fd3fc41e1003839f8cceb388771ea9fa5ae2a0e9c3343",
"created_at": 1719838383,
"kind": 1,
"tags": [
[
"proxy",
"https://sns.minovsky.space/objects/e4271eb6-8d1b-41ca-bfd8-4682bd17b744",
"activitypub"
]
],
"content": "Someone who has experience with SQL database design?\n\ni wanna make a table where every item can have an arbitrary number of tags. What is the best way for achieving this? Comma separated values?",
"sig": "6e83611a75f4f28b40456da3aa0922c4f086a2a916bfd2145f4f948e6ed9702631e2b497c7b1965dd2cafdb68c80f604e863ed4492faabfb5e125e03aeca2ad3"
}