I am using SQLite Database.

I have table that holds the current material details, lets call it Material.db.
Once the current material is processed, this material details will be deleted and new material details will be inserted.

What I want is before deleting the current material, I want this data to be stored in a archive database say archive.db.

How can this be achieved using Sqlite triggers or any other better way of doing this?
I am trying to avoid making changes in my application code so looking for an option from Sqlite Database.

Not sure whether we can have trigger making an insert to a different db