What technology to choose a web service and database?

Question

Database

Good afternoon! There was a task to develop a web application in which the search for a street, house, apartment will take place.
The question arises which technology to use on the server, and most importantly, which database to choose SQL or NoSQL? And this is no small task. How to be when in the address. the highway lane, passage, streets with the name of 2,3,4 words are used. Example: Bolshoy torch lane, Cattle drive street, passage and lane - the same name of the street and lane, or such is the 1st street of Izmailovsky Menagerie. Standard example: st. Lenina d. 56, apt. 125.
But there are also such: st. Nikolskaya, d. 27/2 vk. 16
st. Rossoshanskaya, 17a apt 78
st. Dorozhnaya, 25, building 1, 55
st. Dnepropetrovskaya, 34, bldg. 2 VK 6
How to break and store such? And how do you search for them?

Answer 1

Look at the KLADR and FIAS databases fias.nalog.ru/Updates.aspx
They have a relational structure, it is easy to export from DBF to mysql.
Actually, almost no one writes their bikes and uses them.

Answer 2

Do you think that you will choose the right tool and everything will be decided by itself?
Yes, you can even implement it on the most banal MySQL.
It's not the choice of tool that matters. And the ability to use the tool.
Take ready and do not soar brains.
https://habrahabr.ru/post/214945/
There are a lot of pitfalls.
https://habrahabr.ru/company/hflabs/blog/301014/
If you ask which database to choose, then it is hardly able to bypass these stones.

Answer 3

You can use Elastic under the database. You can fill in addresses in a semi-automatic mode: if the address is standard
(str|pr-t|pr|...). (Street/avenue/...), d. (letters/numbers), apt. (letters/numbers) - break with a regular expression, and drive in automatically, otherwise manually.
There is an alternative - try to search for the address through Google, then try to get the address through its API