Sorry if this has been asked in the past, but the search function is
still down…
My scenario:
For my research agency, I’m trying to download XML files from the
National Weather Service (NWS) and import certain data into my SQL
Server database. Normally, I would use .NET to do this, but I’m trying
to find a Ruby solution.
Question:
Suppose I write a Ruby script to run every hour, collect the XML, parse,
and upload to the database. Can/should I use ActiveRecord for this? I’m
not even sure HOW this would work, let alone IF. I’ve been successful at
AJAX-ifying the retrieval/display of the XML (using REXML), but the next
step is to store some of the data in SQL Server. I would like to utilize
my current YAML config file too.
Any tips?
Thanks,
Chris