nzwirelessmap icon indicating copy to clipboard operation
nzwirelessmap copied to clipboard

Auto-update radio link database

Open mhansen opened this issue 9 years ago • 1 comments

Links have to be updated manually.

An automatic fix might look like:

  • Some virtual machine with a cronjob, which
  • Downloads the data from RSM
  • Imports it to sqlite3
  • Exports to CSV
  • Uploads CSV to Fusion Tables

It's probably not worth doing this though, given the low traffic.

mhansen avatar Oct 15 '16 09:10 mhansen

Exporting to sqlite3 may not be required. The mdb-sqlite adapter I have just uses a java MS Access library. I could instead export to an in-memory SQL database (maybe H2?) and then query from there directly. Then I would need no sqlite3, no native code, could do it all in Java. Then this would be easier to deploy somewhere that can run pure java.

mhansen avatar Jun 09 '18 22:06 mhansen