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
Feed/Run VRS from MySQL Database
Re: Feed/Run VRS from MySQL Database
I do like the sound of this idea. Hope it comes to something!
Cheers,
Ian
Ian
Re: Feed/Run VRS from MySQL Database
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.
Re: Feed/Run VRS from MySQL Database
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

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
Re: Feed/Run VRS from MySQL Database
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
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
Christian
Re: Feed/Run VRS from MySQL Database
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 ...
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 ...