Hi Dariusz, To me this example has one table "user" and I have many tables that connects to one user and that is what I'm unsure how how to do.
/Niklas -----Ursprungligt meddelande----- Från: Dariusz Borowski [mailto:darius...@gmail.com] Skickat: den 11 januari 2013 14:56 Till: solr-user@lucene.apache.org Ämne: Re: configuring schema to match database Hi Niklas, Maybe this link helps: http://www.coderthing.com/solr-with-multicore-and-database-hook-part-1/ D. On Fri, Jan 11, 2013 at 2:19 PM, Niklas Langvig < niklas.lang...@globesoft.com> wrote: > Hi! > I'm quite new to solr and trying to understand how to create a schema > from how our postgres database and then search for the content in solr > instead of querying the db. > > My question should be really easy, it has most likely been asked many > times but still I'm not able to google any answer to it. > > To make it easy, I have 3 columns: users, courses and languages > > Users has columns , userid, firstname, lastname Courses has column > coursename, startdate, enddate Languages has column language, > writingskill, verbalskill > > UserA has taken courseA, courseB and courseC and has writingskill good > verbalskill good for english and writingskill excellent verbalskill > excellent for spanish UserB has taken courseA, courseF, courseG and > courseH and has writingskill fluent verbalskill fluent for english and > writingskill good verbalskill good for italian > > I would like to put this data into solr so I can search for all "users > how have taken courseA and are fluent in english". > Can I do that? > > The problem is I'm not sure how to flatten this database into a schema > It's easy to understand the users column, for example <field > name="userid" type="string" indexed="true" /> <field name="firstname" > type="string" indexed="true" /> <field name="lastname" type="string" > indexed="true" /> > > But then I'm not so sure how the schema should look like for courses > and languages <field name="userid" type="string" indexed="true" /> > <field name="coursename" type="string" indexed="true" /> <field > name="startdate" type="string" indexed="true" /> <field name="enddate" > type="string" indexed="true" /> > > > Thanks for any help > /Niklas >