Want to stay on top? Ruby Weekly is a once-weekly e-mail newsletter covering the latest Ruby and Rails news.
     Feed Icon

Load 171021 countries, states, and towns into your app’s database

By Peter Cooper / June 2, 2006

Devin Steffler shows you how to load over 100000 countries, states, and towns into your Rails app's database, from how to get the data to the code to transform the data into database entries.

Comments

  1. Devin says:

    I posted the file in a comment on a comment in the article so that you can simply download a zip file containing all of the SQL insert scripts so that you don't need to build a script generator to parse the text file containing all of the cities/states/countries.

  2. Peter Cooper says:

    Great work, Devin!

Other Posts to Enjoy

Twitter Mentions