In sqlite, how do I use trigger to write to other files?

Question

I can use trigger to write to other files for audting trails. How do I exactly do that?

I have tried this to no avail

CREATE TRIGGER log AFTER INSERT ON my_table
BEGIN
ATTACH DATABASE /location/otherfile AS logDb
Insert ..

I tried the above code the sqlite console and got the syntax error near ATTACH. How else can I do this?

Thanks!

score 1 · Answer 1 · answered Sep 26 '17 at 08:04

Inside a trigger body, only INSERT/UPDATE/DELETE/SELECT statements are allowed, and you cannot access other database schemas.

To access other files, you have to create a user-defined function, which requires support from any application that modifies the database.

1 Answers1