I think it is better to just have a single connection if possible. So that if anything goes wrong, you can just terminate a single process in the database.

Imagine if you have multiple connection and something goes wrong then you can end up saturating your database with your script and making it unusable.