Hi all, I'm about to develop a travel website and am wondering if Solr might fit to be used as the search solution. Being quite the opposite of a db guru and new to Solr, it's hard for me to judge if for my use-case a relational db should be used in favor of Solr(or similar indexing server). Maybe some of you guys would share their opinion on this?
The products being searched for would be travel packages. That is: hotel room + flight combined into one product. I receive the products via a csv file, where each line defines a travel package with concrete departure/return, accommodation and price data. For example one csv row might represent: Hotel Foo in Paris, flight departing 10/10/09 from London, ending 10/20/09, mealplan Bar, pricing $300 ..while another one might look like: Hotel Foo in Paris, flight departing 10/10/09 from Amsterdam, ending 10/30/09, mealplan Eggs :), pricing $400 Now searches should show results in 2 steps: first step showing results grouped by hotel(so no hotel appears twice) and second one all date-airport-mealplan combinations for the hotel selected by the user in step 1. >From some first little tests, it seems to me as if I at least would need the collapse patch(SOLR-236) to be used in step 1 above?! What do you think? Does Solr fit into this scenario? Thoughts? Sorry for the lengthy post & thanks a lot for any pointer! Carsten
