A new spin: pushing data to a remote database?

I have two feeders, both running 1090 and 978. I have seen how alot of guys install SQL databases on their RasPi and then query that, but has anyone setup a remote SQL server or similar remote reposity and push their position reporting data / JSON formatted data uphill to their own DB?

If anyone has a lead on others doing this, I would love to hear about it. Thanks!

2 Likes

No problem at all. You can run two different options.

The easier one is using Virtual Radar Server. This has an option to create a SQLite database and store the information there. On Virtual Radar Server you can add both feeders as source.

The more difficult way (but still easy to get it done) is setting up readsb (the alternative to dump1090-fa) as a net-only decoder and collect the data via network from the two feeders. As readsb (and dump1090-fa) is able to generate a JSON output, you will need then a script to move the JSON data to a database.
One example can be found here:
http://cactusprojects.com/logging-dump1090-fa-to-local-database/

It works with a local DB, but with using the remote option of readsb, you can have the DB whereever you like.

1 Like