Android Question New data in remote database = notification

Oke · Nov 20, 2021

I have a database on a hosting server.
How do I make every time new data is inputted into the database, I get an automatic notification ?

Alex_197 · Nov 20, 2021

Oke said:
I have a database on a hosting server.
How do I make every time new data is inputted into the database, I get an automatic notification ?

Firebase Notification. Let's say on the server there is either a running application or a web site that creates the new data. Let's assume that we're talking about a website written in ASP.NET. User clicks on a button on the webpage and a new record has been created.

Now on record created event we can run a code on this web page that will send a notification to the B4A app.

Oke · Nov 20, 2021

Alex_197 said:
Firebase Notification. Let's say on the server there is either a running application or a web site that creates the new data. Let's assume that we're talking about a website written in ASP.NET. User clicks on a button on the webpage and a new record has been created.

Now on record created event we can run a code on this web page that will send a notification to the B4A app.

Is it possible to check new data from b4a app?

DonManfred · Nov 20, 2021

Oke said:
Is it possible to check new data from b4a app?

Implement jRDC2 on your Server and use B4A JRDC2 Client to fetch Data from the jRDC2 on your Server.

Peter Simpson · Nov 20, 2021

If you are using a general shared server solution like around 99% of businesses/people do, then jRDC2 is definitely not the solution for you. In the last I've just set a 60 - 300 seconds ping to check for new data, It's as simple as that.

Most simple website services give you free hosting databases (but no desktop access), so you should define if you have access to the actual desktop. A simple pinging the database every x seconds should suffice.

I can think of lots of solutions, this is just one of many simple solutions that popped into my head. Firebase Notifications is another solutions, but you will have to do a lot of work to get everything working smoothly.

I take it that you're using either MS SQL or MySQL???
To me you've not really described anything, do you need instant notification, or can it be delayed 5 minutes (maybe not)...

Oke · Nov 20, 2021

DonManfred said:
Implement jRDC2 on your Server and use B4A JRDC2 Client to fetch Data from the jRDC2 on your Server.

The problem is I'm still using shared hosting ...

Peter Simpson · Nov 20, 2021

Oke said:
The problem is I'm still using shared hosting ...

My point exactly, and that is not a problem...

Oke · Nov 20, 2021

Peter Simpson said:
If you are using a general shared server solution like around 99% of businesses/people do, then jRDC2 is definitely not the solution for you. In the last I've just set a 60 - 300 seconds ping to check for new data, It's as simple as that.

Most simple website services give you free hosting databases (but no desktop access), so you should define if you have access to the actual desktop. A simple pinging the database every x seconds should suffice.

I can think of lots of solutions, this is just one of many simple solutions that popped into my head. Firebase Notifications is another solutions, but you will have to do a lot of work to get everything working smoothly.

I take it that you're using either MS SQL or MySQL???
To me you've not really described anything, do you need instant notification, or can it be delayed 5 minutes (maybe not)...

yes using MySql,
Can you provide a sample code to ping a server in the B4A app ?

Peter Simpson · Nov 20, 2021

Just use B4XPages with a timer, then just use your usual connect to database routine to check for new data. There are other things that you'll need to do to keep the app running in the background, but this is a good start for you...

Oke · Nov 20, 2021

Peter Simpson said:
Just use B4XPages with a timer, then just use your usual connect to database routine to check for new data. There are other things that you'll need to do to keep the app running in the background, but this is a good start for you...

will it not burden / disrupt the server ?

Oke · Nov 20, 2021

Peter Simpson said:
Just use B4XPages with a timer, then just use your usual connect to database routine to check for new data. There are other things that you'll need to do to keep the app running in the background, but this is a good start for you...

need to do to keep the app running in the background,
how not to be turned off by the system ?

MikeSW17 · Nov 20, 2021

Oke said:
will it not burden / disrupt the server ?

You don't need to download/read all the data every time. Just implement a single-record table on the server with a LastUpdateDateTime or SequentialCounter. Update that whenever an add/change/delete is made to the main data. The remote App can just periodically read & compare that with it's currently stored value and do whatever when it changes.

Oke · Nov 20, 2021

MikeSW17 said:
You don't need to download/read all the data every time. Just implement a single-record table on the server with a LastUpdateDateTime or SequentialCounter. Update that whenever an add/change/delete is made to the main data. The remote App can just periodically read & compare that with it's currently stored value and do whatever when it changes.

thank you sir, i will try

Peter Simpson · Nov 20, 2021

MikeSW17 said:
You don't need to download/read all the data every time. Just implement a single-record table on the server with a LastUpdateDateTime or SequentialCounter. Update that whenever an add/change/delete is made to the main data. The remote App can just periodically read & compare that with it's currently stored value and do whatever when it changes.

WHERE DID I SAY DOWNLOAD AND READ ALL THE DATA???

Alex_197 · Nov 20, 2021

DonManfred said:
Implement jRDC2 on your Server and use B4A JRDC2 Client to fetch Data from the jRDC2 on your Server.

That's not what he wants - instead of fetching data he wants the new record to be pushed into his app.

MikeSW17 · Nov 21, 2021

Peter Simpson said:
WHERE DID I SAY DOWNLOAD AND READ ALL THE DATA???

You didn't. In mentioning concern about 'burdening/disrupting the server' @Oke seemed to be implying he was thinking along those lines.
My reply was to his comment, not yours.

peacemaker · Nov 21, 2021

Oke said:
using MySql

Create a trigger in a table, and in this trigger may call a MySQL-procedure that creates a new record in a table that should be polled by a periodical script.
Or collect some new records and use https://stackoverflow.com/questions/13474012/invoke-pusher-when-mysql-has-changed.
Or need to study https://github.com/Cyclonecode/mysql-notification

Oke · Nov 30, 2021

peacemaker said:
Create a trigger in a table, and in this trigger may call a MySQL-procedure that creates a new record in a table that should be polled by a periodical script.
Or collect some new records and use https://stackoverflow.com/questions/13474012/invoke-pusher-when-mysql-has-changed.
Or need to study https://github.com/Cyclonecode/mysql-notification

thanks for the information, it helps

peacemaker · Nov 30, 2021

Oke said:
it helps

How exactly did you use ?

tigrot · Nov 30, 2021

A triggered procedure can use a CURL to activate a web page, which can send a firebase message to a B4a app.

Android Question New data in remote database = notification

Member

Well-Known Member

Member

Expert

Expert

Member

Expert

Member

Expert

Member

Member

Active Member

Member

Expert

Well-Known Member

Active Member

Expert

Member

Expert

Well-Known Member

Similar Threads

Privacy & Transparency

Privacy & Transparency