Re: Restaurant availability from database

2013-05-28 Thread Chris Hostetter
: I've created a custom ValueSourceParser and ValueSource that retrieve the : availability information from a MySQL database. An example query is as : follows. : : http://localhost:8983/solr/collection1/select?q=restaurant_id:*&fl=*,available:availability(2013-05-23, : 2, 1700, 2359) : : This r

Re: Restaurant availability from database

2013-05-24 Thread David Smiley (@MITRE.org)
Use this reference: http://wiki.apache.org/solr/SpatialForTimeDurations Alexandre Rafalovitch wrote > On Thu, May 23, 2013 at 6:47 PM, Amit Nithian < > anithian@ > > wrote: >> Hossman did a presentation on something similar to this using spatial >> data >> at a Solr meetup some months ago. >> >

Re: Restaurant availability from database

2013-05-24 Thread Alexandre Rafalovitch
On Thu, May 23, 2013 at 6:47 PM, Amit Nithian wrote: > Hossman did a presentation on something similar to this using spatial data > at a Solr meetup some months ago. > > http://people.apache.org/~hossman/spatial-for-non-spatial-meetup-20130117/ This presentation rocks (I like examples too). I wou

Re: Restaurant availability from database

2013-05-23 Thread Amit Nithian
Hossman did a presentation on something similar to this using spatial data at a Solr meetup some months ago. http://people.apache.org/~hossman/spatial-for-non-spatial-meetup-20130117/ May be helpful to you. On Thu, May 23, 2013 at 9:40 AM, rajh wrote: > Thank you for your answer. > > Do you m

Re: Restaurant availability from database

2013-05-23 Thread rajh
Thank you for your answer. Do you mean I should index the availability data as a document in Solr? Because the availability data in our databases is around 6,509,972 records and contains the availability per number of seats and per 15 minutes. I also tried this method, and as far as I know it's on

Re: Restaurant availability from database

2013-05-23 Thread Alexandre Rafalovitch
Check out Gilt's presentation. It might give you some ideas, including possibly on refactoring your entities around 'availability' as a document: http://www.lucenerevolution.org/sites/default/files/Personalized%20Search%20on%20the%20Largest%20Flash%20Sale%20Site%20in%20America.pdf Regards, Alex