I try really hard to like denormalization of data in document databases.
I also try really hard to like relational SQL even for deeply nested data with many relations.
Today I failed on both. Suggestions explicitly welcome.
#sql #nosql #mongodb #postgresql
Louis /
npub1tp…adzfn
2023-09-05 19:16:09
Author Public Key
npub1tp9e9qhmc02khh3jzpn8vmqwhj3u25yw352ed2x87zs4e2ps2uwqhadzfnSeen on
wss://relay.noswhere.comPublished at
2023-09-05 19:16:09Event JSON
{
"id": "f1b974c008681e52193cabe7d279f8c105f2024b16152ba0222f8f5813f08081",
"pubkey": "584b9282fbc3d56bde321066766c0ebca3c5508e8d1596a8c7f0a15ca830571c",
"created_at": 1693941369,
"kind": 1,
"tags": [
[
"t",
"sql"
],
[
"t",
"nosql"
],
[
"t",
"mongodb"
],
[
"t",
"postgresql"
],
[
"proxy",
"https://emacs.ch/users/louis/statuses/111014141595063074",
"activitypub"
]
],
"content": "I try really hard to like denormalization of data in document databases.\n\nI also try really hard to like relational SQL even for deeply nested data with many relations.\n\nToday I failed on both. Suggestions explicitly welcome.\n\n#sql #nosql #mongodb #postgresql",
"sig": "e21b1c1a3cf27ed355a03ea42c32ebe709d2d3ec2df5e05f82ed2bc3711cff5f0c08876b095fccb9cd729266d5a84b4d300b43118edaa547d33a5f5d3de6e3ca"
}