1
I am trying to save the user’s location in a database, to subsequently generate reports on users by country, state and region.
Initially I downloaded bases that contained the name of all the cities of the world, in several languages, but this left the maintenance of the application a horror. Without saying that it is impractical to keep the base up to date.
I thought of starting to use an API like Google’s, only when users ask for a location in the API, the results come in the user’s language. So it is possible that I have in the base New York, New York and other versions, which complicates the generation of reports.
I would like a help to shape the data in a way that I can store and research, without having to have a list of all the names in the world. I’m using Django/Postgresql.