What technology to choose the web service and database?

Good day! They needed to develop a web application in which will be search street, house, apartment.
The question arises which technology to use on the server, and most importantly what kind of database choose SQL or NoSQL? And there is still no small task. What about when the address. used highway, lane, thoroughfare, street name 2,3,4 words. Example:Big torch lane,Sheep street, passage and alley - the name of the street and alley or that 1-I street of Izmailovo Menagerie. Example standard: ul Lenina d. 56, kV. 125.
But there are also: St. Nikolskaya St., 27/2 VC. 16
Rossoshanskaya str., d. 17A kV 78
Road street, d. 25, str. 1 kV 55
street Dnepropetrovsk, d. 34, korp. 2 VC 6
As such to break and store? And how to search??
July 9th 19 at 10:43
3 answers
July 9th 19 at 10:45
Look at the database and FIAS KLADR fias.nalog.ru/Updates.aspx
They have a relational structure, DBF easy to do the export to mysql.
In fact almost no one writes their bikes and use them.
July 9th 19 at 10:47
Do you think that vyberesh the right tool and you'll resolve itself?
Yes you can, although trivial to implement MySQL.
Decides not a selection tool. And the ability of the tool to use.

To get ready and not to soar brains.
https://habrahabr.ru/post/214945/

There are many pitfalls.
https://habrahabr.ru/company/hflabs/blog/301014/

If you're asking how to choose a database, it is unlikely to pass these stones.
July 9th 19 at 10:49
Under DB unable to use Elastic. Score addresses in the semi automatic mode: if the address of the standard
(ul|PR-t|PR|...). (Address street/Avenue/...), doctor (letters/numbers), square (letters/digits) - to break the regular season, and to drive automatically, otherwise manually.

There is an alternative - to try to find the address through Google, then try to address through its API

Find more questions by tags ProgrammingDatabasesWeb Development