All I know is it works in MySQL when I have one connection and multiple prepared statements.
Are you suggesting I need to have like this (pseudocode) in order to be sure of my last_insert_id?
db1 = db.connect('user:pass@database')
updatefoo = db1.prepare('insert into foo (column) values (?)')
db2 = db.connect('user:pass@database')
updatebar = db2.prepare('insert into bar (column) values (?)')
Negative12DollarBill /
npub1kg…yef3q
2024-10-28 22:53:58
in reply to nevent1q…ue8s
Author Public Key
npub1kgmrjzpzgngflt9afpjcsz99rrttzl3k8q5a7yfmmujyk2rhmrjqcyef3qPublished at
2024-10-28 22:53:58Event JSON
{
"id": "c176c55de0be5a437c670a71ca3821ef33f02a7eba05898ae025ec6a267f1eee",
"pubkey": "b23639082244d09facbd48658808a518d6b17e363829df113bdf244b2877d8e4",
"created_at": 1730156038,
"kind": 1,
"tags": [
[
"p",
"b23639082244d09facbd48658808a518d6b17e363829df113bdf244b2877d8e4"
],
[
"e",
"269b2c5608d64871eef579cca883e2e12d0b98d4bc2e0e704ef2d58f7d35d5be",
"",
"root",
"b23639082244d09facbd48658808a518d6b17e363829df113bdf244b2877d8e4"
],
[
"proxy",
"https://techhub.social/@negative12dollarbill/113387506129726780",
"web"
],
[
"p",
"8332bb05f2a95027eaac2c05c5cb2a8d0868430eaa7269d3bdbc356113c17312"
],
[
"e",
"dc6c842cd171abaabb2227b71f2fdc72f40ad257a5b71b300af71f3ae391ff8e",
"",
"reply",
"8332bb05f2a95027eaac2c05c5cb2a8d0868430eaa7269d3bdbc356113c17312"
],
[
"proxy",
"https://techhub.social/users/negative12dollarbill/statuses/113387506129726780",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://techhub.social/users/negative12dollarbill/statuses/113387506129726780",
"pink.momostr"
],
[
"-"
]
],
"content": "All I know is it works in MySQL when I have one connection and multiple prepared statements.\n\nAre you suggesting I need to have like this (pseudocode) in order to be sure of my last_insert_id?\n\ndb1 = db.connect('user:pass@database')\n\nupdatefoo = db1.prepare('insert into foo (column) values (?)')\n\ndb2 = db.connect('user:pass@database')\n\nupdatebar = db2.prepare('insert into bar (column) values (?)')",
"sig": "7a9fd013f3798ae9824eac16e6754b04795e6b6af89855a30ff96ac2ba5b4dc238e9195df0b1d45a0a32eb9e65e355cff207512a8eb6305ffe4bd28aaf0ce4e3"
}