SQLite triggers - call bash script

Question

is it possible to create a trigger in SQLite that when it fires it calls a bash script? MSSQL supports calling exe programs when a trigger is activated.

Thanks for any information.

XDF · Accepted Answer · 2012-04-17 23:41:02Z

2

Regarding the standard triggers of SQLite the answer is no. There is no built-in mechanism to call external programs from a trigger.

But if you are ready in invest time on research and coding the answer is yes. You can modify the C source code (it is in public domain) and add a feature to call the external program. Or you can use the API provided like sqlite3_create_function() or sqlite3_update_hook() to run your program whenever an event occurs.

Most SQLite language extensions (at least Perl, Python, Ruby) allow you to use the extension API from the language so there is no need to write C. However I haven't tested what happens if you present your own Perl/Python/Ruby function to SQLite, use it in defining a trigger and then disconnect from the database. The trigger definition remains but the function is lost?

answered Apr 17, 2012 at 23:41

XDF

1571 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite triggers - call bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related