How to filter ship signals by IMO number and push updated data to MySQL?

[Nikseell]

Hi everyone,

I'm working on a project where I need to filter ship signals to isolate a specific ship using its IMO number. Additionally, I want to push this data to a MySQL database every time the ship's information gets updated in real-time. Can anyone guide me on the best approach or share any resources/tutorials that might help?

Thanks in advance!

[jvde-github]

Hi,

there are probably utilities to push NMEA into a mysql database on the web. I have not looked for it. I have added an option to filter on MMSI which allows you to filter on a ship with a particular IMO number:

AIS-catcher -o 5 FILTER on SELECT_MMSI xxxxx

This will produce JSON output that you can try to push into mysql via a Python or bash script? Any other thoughts.