openstreetmap-carto english names

This is the best solution. A more primitive approach is to simply replace queries for the "name" column with COALESCE(tags->'name:en', tags->'int_name', name) AS name which will then replace the local name with the name:en or int_name where these are set. Note that this, like the above osml10n solution, depends on having imported with --hstore, otherwise these names would not even be there.

Another option, that requires minimal changes to the map style, is using database views that incorporate the aforementioned COLAESCE statement, i.e. the view looks exactly like e.g. planet_osm_point only that its name column has a different content.

Awesome thanks! That looks exactly like what I need.

I was looking into how it works a little bit, and I compared it with the master branch here: https://github.com/gravitystorm/openstreetmap-carto/compare/master...giggls:upstream+l10n

There's a lot of references to localized_name_second but don't see it defined anywhere. Is that a field that exists in the planet.osm file?