Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Auto-update radio link database #8

Open
mhansen opened this issue Oct 15, 2016 · 1 comment
Open

Auto-update radio link database #8

mhansen opened this issue Oct 15, 2016 · 1 comment

Comments

@mhansen
Copy link
Owner

mhansen commented Oct 15, 2016

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 mhansen changed the title Auto-update links Auto-update radio link database Oct 15, 2016
@mhansen
Copy link
Owner Author

mhansen commented Jun 9, 2018

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant