External Reporting/Database

Hi, I’m new to ADSB Exchange and feeding and have a question. Is it possible to stream the data being received into a database so that it can be reported on? I’d like to be able to keep track of planes seen, how many times, different types of plane etc. I have a script that pulls the chunk files, unzips them and can bring them in as JSON into Power BI but it’s very messy. I’m thinking InFlux or Prometheus for the DB?

Hope someone has some great ideas.

Yes, you can just query the data from an open port though I don’t remember the details but a quick google search should help.

Unfortunately I keep coming up blank on google. I think the port is 30005 and is only presented locally so I’ll try installing influxdb local and see if I can connect

Looks like Port 30004 for beast_out data from Readsb.