RSqlite create table from dataframe, specify primary unique key

Question

I use RSqlite :: dbWriteTable to periodically save pieces of data in sqlite database. This method has the advantage that if the table does not exist yet, it creates it for the first time and adds data at subsequent times.

This method, however, does not allow you to specify a primary key and therefore does not protect against duplicate entries.

Is there a way to solve this or another method as a flexible dbWriteTable declaration that is duplicate safe?

thanks