npub1fzx00c36ny4whyuhg4ykx6987wxp885fmwmc784n27qcu6pavwzs3wt6h3 (npub1fzx…t6h3)
Database agnostic code is a myth.
You really need to have a reason to switch RDBMS.
PostgreSQL uses MVCC for transactions. I don't think MySQL does.
Because different databases handle transactions differently, the Unit Tests could pass but going live (with a multitude of users) could be your undoing.
TL;DR - have a DOWNGRADE path tested and working before you start.
Mike Kutz /
npub1nn…hnqyq
2023-12-12 12:15:14
in reply to nevent1q…yk32
Author Public Key
npub1nnrsgqhc9eur9sw02p4lw4lq37nh702l0epkp3ns5g42uq2a9yaqlhnqyqSeen on
wss://relay.nostr.bandPublished at
2023-12-12 12:15:14Event JSON
{
"id": "bd68a426f0ab7ea89950eade8afea64e83c3dd02dee8c043daa08ffc266af9f5",
"pubkey": "9cc70402f82e7832c1cf506bf757e08fa77f3d5f7e4360c670a22aae015d293a",
"created_at": 1702383314,
"kind": 1,
"tags": [
[
"p",
"488cf7e23a992aeb939745496368a7f38c139e89dbb78f1eb357818e683d6385",
"wss://relay.mostr.pub"
],
[
"p",
"584b9282fbc3d56bde321066766c0ebca3c5508e8d1596a8c7f0a15ca830571c",
"wss://relay.mostr.pub"
],
[
"e",
"65a31c03b8a83f84ba6cbc4b877f6677f2d82dedcb37d145407ec7e822dba4ef",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://mastodon.world/users/mkutz1492/statuses/111567392901750730",
"activitypub"
]
],
"content": "nostr:npub1fzx00c36ny4whyuhg4ykx6987wxp885fmwmc784n27qcu6pavwzs3wt6h3 \n\nDatabase agnostic code is a myth.\n\nYou really need to have a reason to switch RDBMS.\n\nPostgreSQL uses MVCC for transactions. I don't think MySQL does.\n\nBecause different databases handle transactions differently, the Unit Tests could pass but going live (with a multitude of users) could be your undoing.\n\nTL;DR - have a DOWNGRADE path tested and working before you start.",
"sig": "fcbd40d15259776497fec4552930e37c204a29f747c37c24e61a58fe0a8ce3060ffd4be296fcfd0c13c10b33f94a84f2db256c812d37ded7069089e5ddb748e6"
}