MySql Trigger + Firebase Push Notifications anyone experience with it?

[Alexander Stolte]

Hello Community,

for months I have been developing a social media app together with B4A and soon also B4I, as a database, I have taken a MySQL. Now I want to notify the users, in the current alpha status of the app, sends each user via the app a notification to the users, but that's not the perfect solution, just because you can manipulate that.

Then I learned how to do that via triggers in MySQL, but there are hardly any solutions, a PHP script is too slow to wait until it has been sent.

Another way would be to develop a B4J service that handles the requests one by one

but before I wanted to ask if someone has already made experience with it and if he is interested in revealing this.

"New Notification, your post was voted by 5 people"

Greetings

 

[Descartex]

Hi.
I've made that a trigger calls a jar script created with B4J passing a list of arguments so, yes, it works.

 

[Alexander Stolte]

Thanks fo your answer, so it is possible nice.

How could you receive the arguments in B4J?

 

[Descartex]

In b4j you receive a list of arguments on main sub, so you can use it as you need.

 

[Descartex]

Yes, Ilan.
My script does It that way. Sends the notification vía Firebase to the topic of the app.
It is very simple and Fast, as you said.

 

[Alexander Stolte]

Thank you and with Wait For I can do it asynchronously.