DEV Community

Discussion on: Comparing Data Handling in MySQL and PostgreSQL: the RETURNING clause and CTE's

Collapse
 
anduser96 profile image
Andrei Gatej

Yes, thank you very much. So with both approaches, only one connection is made? I find it a bit strange, since with the “node” approach we have multiple requests and with the other one we have only one big query. Or is the same connection used among all the requests?

Thread Thread
 
gduple profile image
Grant

Yes, it would be one connection if I understand what you are asking, though you would presumably do multiple steps within a transaction, so that you have better control of how the overall operation behaves (for ACID compliance).

Thread Thread
 
anduser96 profile image
Andrei Gatej

Got it! Thank you!