maria-discuss team mailing list archive

[SARTrack Admin <info@xxxxxxxxxxxxxx>]

I develop a Windows application for Search and Rescue (using Delphi and 
MyDAC components), which gets a stream of "APRS" data packets, up to 10 
per second.
These are saved in the SQL database, but all Clients which are connected 
to the database MUST be notified when a Table change has occured, so 
that they then can update their internal tables. Which in turn update 
their Maps (GPS location of moving items) and other data, which MUST be 
up-to-date.

Currently I am having all Clients polling the database every 5 seconds, 
which really sucks, and causes all kinds of other problems.

Is there any chance that MariaDB will have some kind of Client 
Notification system when a Table has changed, as some other SQL 
databases seem to have?

Thanks

Bart Kindt
SARTrack Limited
http://www.sartrack.co.nz/

--

SARTrack Developer and CEO