Skip to content

List of countries

For the next version of Amore, I’m trying to get away from my too-clever-to-be-its-own-good makeid function. For most of the tables there are other fields that I can use as a primary key, but the locations table really needs some sort of identifier for each record. After looking around, it seems there is no standardized codes for locations. The closest is ISO 3166-2 which goes down to the state/province level, while I’m looking for something that goes down to the city or neighborhood level. In the end, I opted to use an auto-incrementing numeric primary key.

Since deciding that, it’s been a matter of re-entering all the continents and countries into the table. I may add states and provinces later, but this is good enough for the time being.

For future reference, here are the lists of countries by continent/region:

Published inAmoreblogFediverse

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *