Can it be done with couch base ?
this is more a question if i can use couchbase doc to store and query based on my specs.
I am trying to create a Doc which will store information about a business with address
in fr\orm of geo info like lat and long. Also i would like to store in the json doc
the opening hrs of the buisness. like monday 800 thru 1700 , tuesday 800 thru 1700 and
so on. Now i would like to be able to query all docs of type business where the distance
to a given location is 1000 meter and which is open on Monday at 1400 hrs ?
i know i can do this in mysql where i can create a complex query, but not sure if couchbase
can handle it effectively. I would prefer to store all data in couchbase directly and not
have to store geo info and opening hrs in mysql and then get the doc id to retrive the json from couchbase
Any design tips for query or doc would be quite helpfull