GeoNames Forum

I am in the process of putting together a directory of organisations, along with their postal addresses. I also want to be able to render the addresses in the appropriate locale. For example, take this address:

10 avenue du Castel,
Brussels,
Belgium

where the city name and country names can be displayed differently according to the visitor, for example: Bruxelles, Brussel and Brussels.

Does anyone have any suggestions on the best way of going about this, so that it is both accurate and fast (I know I'm asking a lot). Some things I have considered:
- using geoname id in the record
- converting the values to use the corresponding name in the geoname table, and then looking up as necessary in the alternatenames table
The question still remains what is the fastest approach to substitute the names when I ask for a result list?

I think the tricky part is how to maintain your data (how to add or change addresses) and how to search. Do you have full text search on all locales?
Joining two tables over the primary key is usually fast and not problematic.

Best

Marc