I’ve been using Kiba ETL for a client project and it is a great way to separate ETL concerns.
NOTES: I still envision using a rake task to download GeoNames data, but then to use the following ETL hierarchy to move that data into both SQLite3 tables and *.csv files for each of the following:
Country
State
County
Zipcode
Potential ETL Hierarchy
Under the etl or lib/etl directory:
csv_source.rb - to read the downloaded GeoNames data
I’ve been using Kiba ETL for a client project and it is a great way to separate ETL concerns.
NOTES: I still envision using a rake task to download GeoNames data, but then to use the following ETL hierarchy to move that data into both SQLite3 tables and *.csv files for each of the following:
Potential ETL Hierarchy
Under the
etl
orlib/etl
directory:GeoNames
dataNOTE: I’m open to other suggestions.