Multiple unique constraints and duplicates

[bokolob]

Hello!

My collection should have multiple unique keys, is there a way to ignore duplicates when insert? Both put and add calls throw exception. The only way I think about - start transaction and filter out existing elements, but I suppose it’s slower.

Thanks.

[dfahlander]

Use [bulkPut()](https://dexie.org/docs/Table/Table.bulkPut()) or [bulkAdd()](https://dexie.org/docs/Table/Table.bulkAdd()) and catch the resulting promise explicitely (using returnPromise.catch(), not try... await...catch). This way the duplicates will be silently ignored while the other ones shall succeed.