I working on the database structure for my app and I will need users to be able to search by location by map and by text (i.e., Miami or Spain). I will need them to be able to search by city , state, country. How do I set this up in the databases? Do I use the “geographic address” option even though this means the user will need to input their address instead of just their city / country? Will I be able to extract the relevant parts of that address later? Or is it better that I collect city and country individually? If so, how do I connect this to an updated list of cities or countries?
Just to be clear, I never want the inputed address to show for other users (other than the one who inputed it) but I do want the city /country to show.