xorcyan
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
good night 😴
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
I have a few questions though:
but insert like that (across multiple tables) should be in a transaction (insert all or nothing)Are DB commits not guaranteed to be as expected across tables? wdym by http for serverless env? why does it differ from websocket?
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
too late to grasp the issue properly though
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
yay, fixed
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
I missed that somehow
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
websocket 👍
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
nvm, got it I think https://orm.drizzle.team/docs/get-started-postgresql#neon-postgres
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
Error: No transactions support in neon-http driver I get this error48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
sorry for the ping 😐
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
neon serverless (
"@neondatabase/serverless": "^0.9.5")48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
huh
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
still, I would expect each query statement to be auto committed
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
got the issue?
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
I got an error along those lines
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
I tried but the neon client doesn't support transactions
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
even tho I delete those records
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
and for some reason the id keeps starting from the incremented value instead of 0
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
same output even after removing awaits from the array inside Promise.all
48 replies
DTDrizzle Team
•Created by xorcyan on 9/26/2024 in #help
db.insert doesn't immediately insert the values into the DB (Neon)
wait
48 replies