Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Create trigger based on insertion/updation in spanner database

I want to run a nodejs Job whenever an entry is created on the spanner database. The entry in spanner database will contain some future timestamp. The nodejs Job should run at that particular timestamp.

Can I apply some db trigger to initiate the action?

Note: The nodejs Job is deployed on GKE

like image 863
Ankur Verma Avatar asked May 03 '26 12:05

Ankur Verma


1 Answers

No, Cloud Spanner does not support triggers.

Either the application that creates the row calls the nodeJS job, or you have a regularly-occurring job that scans the relevant table for new rows.

like image 145
RedPandaCurios Avatar answered May 06 '26 06:05

RedPandaCurios