Post by Peter Cooper on June 2nd, 2006

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

Similar Posts
Popular Posts
Jobs

View All Jobs | Post a Job

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.

[Post to Twitter] Tweet This

This entry was posted on Friday, June 2nd, 2006 at 9:17 pm and is filed under Elsewhere, Ruby on Rails. Responses are currently closed, but you can trackback from your own site.

Previous Post: Perform Yahoo searches in 2 lines of code
Next Post: Accessing Databases with ActiveRecord (but without Rails)

2 Responses to “Load 171021 countries, states, and towns into your app’s database”

  1. #1
    Devin Says:
    June 8th, 2006 at 2:02 am

    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. #2
    Peter Cooper Says:
    June 8th, 2006 at 2:07 am

    Great work, Devin!