Sorry if this has been asked in the past, but the search function is
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.
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.