Feed/Run VRS from MySQL Database

Want to post something that doesn't quite fit into the other forums? This is the place for that.
TomMuc
Posts: 16
Joined: Sat Sep 26, 2015 8:45 am

Feed/Run VRS from MySQL Database

Postby TomMuc » Thu Sep 21, 2017 3:03 pm

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
Posts: 23
Joined: Sun Jul 16, 2017 10:01 pm

Re: Feed/Run VRS from MySQL Database

Postby MK2wx » Sat Sep 23, 2017 10:28 am

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

agw
Posts: 1896
Joined: Fri Feb 17, 2012 3:20 am

Re: Feed/Run VRS from MySQL Database

Postby agw » Sun Oct 15, 2017 2:25 pm

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/Barebones42_Socket_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
Posts: 16
Joined: Sat Sep 26, 2015 8:45 am

Re: Feed/Run VRS from MySQL Database

Postby TomMuc » Sun Oct 15, 2017 11:23 pm

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
Posts: 1
Joined: Fri Oct 21, 2016 9:07 pm

Re: Feed/Run VRS from MySQL Database

Postby borchi » Thu Oct 19, 2017 7:07 pm

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
Posts: 16
Joined: Sat Sep 26, 2015 8:45 am

Re: Feed/Run VRS from MySQL Database

Postby TomMuc » Thu Oct 19, 2017 7:58 pm

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 ...


Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest