I do not know enough about the subject to answer this, but I know the folks that read this do.
I wonder is there any way to call an application which resides on the database server computer from stored procedure or trigger? Is the language of stored procedures and triggers only restricted by SQL statements and some arithmetic operations?
It is interesting that Oracle and MS SQL Server already have this functionality. In Oracle it is Java stored procedure, in MS SQL Server it is called “extended stored procedure” where you can call C++ routine out of your stored procedure. It is difficult overestimate the convenience of being able to do some processing triggerted by the record insertion event.
In this case the database could be used not only for “pulling” data out, but also being able to “push” data to some component.
You can go to the meetup message boards and post an answer. If you’d like to post anonymously, feel free to use the account: