I was working on an adaptation of some software I was writing, where the output data would feed various database tables, and then these tables would feed other (higher level) tables, either through triggers or more code.

Sad to say I got bogged-down trying to design the tables. Obviously you need aircraft tables (target tables if you want to include ground vehicles), but how much data should the tables contain? All the hits, hits that have changed, etc. When should data be archived, etc.

Anyway, the actual software to interface the Basestation socket or Boris socket is not that difficult, but would be different for each database design.

What kind of tables do you envision your database having, and what software is going to be on the other side extracting the data?

Yes, it probably needs to have a GUI, so you can shut it down easier, and maybe show the number of records. I was going to add a thread that deletes old records after 15 minutes also, but figured that could be done in the database. I just wanted to put something out there that populated a table for you to get started with. Java has a pretty simple MySQL interface, which makes it easy to throw something together.

As you can tell, I'm not very good with SQL. I would like to create some triggers that would add records to a "target" table. That is, add a record if the Mode-S code hasn't been seen before. Then maybe a trigger IF:THEN to update the values of records already created. Say, update the last-seen timestamp, but not the first-seen timestamp, etc.

Alternatively, I could write a Java thread that went through the detection table, and modified the target records, and then deleted the detection records as they were consumed. That seems like a better way to save disk space, and backup space.

I'm in the same situation as the topicstarter, trying to get the basestation data in a MySQL database and then display it on a Google Maps Page. That last part, the Google Maps App, is already done and working fine however I'm still scratching my head about the part box to database. I've tried to download the program made by edgy31 since it will cover everything I need but the files aren't anymore available on the skydrive

Is there any other host where the program/source code is available or is there another similar program?