If I understand correctly the two options are different use-cases.

So it kinda depends on what you're trying to achieve.

Mike Huls

Jul 1, 2022

If I understand correctly the two options are different use-cases. THe first will only insert records that are not already present, the second will fail the entire query if you want to insert duplicate records.

So it kinda depends on what you're trying to achieve.

Dynamic, Lazy Dependency Injection in Python

Automatic Python dependency injection to make your code more testable, decoupled, uncomplicated and readable.

Log Breadcrumbs: only show Logs leading up to an Error

How to log breadcrumbs using Python's built-in logging package

Let’s Write a Composable, Easy-to-Use Caching Package in Python

Easy, user-friendly caching that tailors to all your needs

Turn Your Python Function into a Decorator with One Line of Code

A new way to write shorter, clearer, and more readable Python decorators that also act as a context manager

Read more

Dynamic, Lazy Dependency Injection in Python

Log Breadcrumbs: only show Logs leading up to an Error

Let’s Write a Composable, Easy-to-Use Caching Package in Python

Turn Your Python Function into a Decorator with One Line of Code