SQL Triggers for Azure Functions

[@halo2bullseye922]

Thanks!

[@schmiroh]

Very well explained 👍

[@giosefer]

Hy Fanie, can you help me? I created my first SQL Triggers for Azure Functions with MySqlDB but the function has problem with the connection. In in the file local.settings.json the parameters is set: "Server=tcp:,; Integrated Security=true; Database=test; Uid= ; Pwd=" The db is up&running on azure cloud. What am I doing wrong ?

[@dareljohnson5770]

This is amazing content! Thanks.

[@manipathak7721]

Hey Fanie, nicely explained. I have few clarification points 1. Is it possible to track the changes on a single column of table rather than whole table . For ex I only want to run my function on insert. So as soon as a new record is inserted then only my function should run. 2 . Any practical example to wait the function for few interval of time after a new record inserted. 😊

[@yaroslavmilanich489]

Thanks 😊 going to use it

[@Astral100]

Have you tried to deploy it and make it work in Azure? It doesn't work in Azure for me, although it works locally.

[@tarunbablani5555]

How do we deploy this to an azure function which will do a sql trigger on a table for an azure sql database

[@diptanu.saha.knightKing]

Thank you for a lovely tutotial, however the code doesn't work for me ! do you have a repo that I can refer to please ?

[@jcnet2008]

Amazing.!! Do you have an example using output bindings?

[@DeepakShaw]

Excellent Demo, does such notification works also with SQLite? Thanks.

[@FanieReynders]

Have not tested it, would be interested to know tho.

[@DeepakShaw]

@@FanieReynders Yes, I have tested and it works perfectly with SQL Server. Thanks for the idea. But I need to achieve the SQLite.. no luck yet.

[@shyampramanik780]

Is this feature can be used in production ?

[@FanieReynders]

The trigger functionality is still in preview, so it has no SLA, but nothing stops you from implementing it in production. It depends.