Feed/Run VRS from MySQL Database

[TomMuc]

what is the best/easiest method to feed data from a database to vrs to see the aircrafts like it were live-data?

i wrote a little script that saves live-data from dump1090 to a mysql database https://github.com/TomMuc1/Dump1090-MySQL-Alert-Filter
now i was wondering what could be a nice way to display recorded data in real time and like a timelapse ...

this is what the database stores on a per second basis:
now, hex, flight, altitude, lat, lon, track, speed, vert_rate, seen_pos, seen, rssi, messages, category, squawk, nucp, mlat, tisb


any ideas welcome

cheers
tom

[MK2wx]

I do like the sound of this idea. Hope it comes to something!

[agw]

I did something similar a while back. Playback involved writing a bit of code that generated a stream of BaseStation format messages (http://woodair.net/sbs/Article/Barebone ... t_Data.htm - you just need to implement the MSG type) and have VRS connect to that. The tricky part is getting the intervals between the messages reasonably correct.

[TomMuc]

thanx for reply my idea was to run it directly out of the database - there is no interface already in vrs to load data directly from mysql?
if not - wouldn't you think that the easiest way were a json-file generated from mysql-data?
does vrs handle the json format from dump1090?
https://github.com/mutability/dump1090/ ... ME-json.md

cheers
tom

[borchi]

Hi,

i´m collecting my data for over a year now, saving it on my raspi, transfering it to my webserver: https://flightlog.openspotter.org

Good idea to generate a JSON form the Database. VR can use JSON, it´s in the receiver settings, but i do not know how to adress the url like http://127.0.0.1/dump1090/data/aircraft.json

[TomMuc]

nice website/flightlog ... at least beside the fact it resides in the epicenter of political failure where every year 4 billion bavarian euros are burned!
vrs uses a tcp stream - not single json files like dump1090 - my question was about the used json format.
had no time to look into this thing over the last weeks - moreover maybe i'll use flightairmap instead vrs ...