Hi Peter. Thanks for responding. We have application running on Heroku. and we need to implement full text search. The features in PostgreSQL pretty much meet our needs and the performance is more than satisfactory. However we will need to use custom dictionaries etc..
The word stemming on the standard dictionary doesn't really work for us. Our application is a recruitment platform and the standard dictionary makes matches on roles that are stemmed from the same word, but should be completely different. ie: "*Party* Planner" and "Chef de *Partie*" both match the stem word "*parti*" So we want to add some key words and word combinations to the dictionary. and we need to be able to tweak this on a weekly/monthly basis. we also need synonyms so that a "Sandwich artist" is the same as a "Sandwich maker", and "Bar Staff" and "Bar Attendant" are the same. Then we have qualifications.... BE is - Bachelor of Engineering, but every where else it is just "be" (a stop word) We also want to add our own rating functions, so that we can evaluate a candidates qualifications, skills and work history, against a role. - but I don't think that this will be a problem. The issue we face right now is how do we get a custom dictionary / stop word / thesaurus loaded in our add hosted on Heroko. We would need to do this for our production, staging, and demo systems. I have looked at the elastic search options like Lucene, but there is a lot of modifications to our application to be able to use solutions like that. and we will probably lose some functionality. We are currently investigating to see if we can get a "workable" solution even without the ability to control the dictionary's by just changing the ranking algorithm only. On Thu, Jun 12, 2014 at 4:39 AM, Peter van Hardenberg <p...@heroku.com> wrote: > Hi Chris, > > can you elaborate on the use-case? What problem are you trying to solve? > > > On Tue, Jun 10, 2014 at 6:48 PM, <ch...@workible.com.au> wrote: > >> Hi Peter >> >> I have been searching for a solution to this same problem, So I am very >> interested in where you got with support for custom dictionaries. >> I can see three ways to support it >> (1) Modify postgress so that the dictionary is keep in a table rather >> than a file. - obviously you don't want to modify postgress >> (2) The custom dictionary is in a table, but is exported to a file (in >> the correct location) for use with standard postgress >> (3) The custom dictionary is maintained outside postgress and is up >> loaded using a heroku CLI extension (or via the website) >> >> >> >> >> On Sunday, March 3, 2013 10:16:31 AM UTC+11, Peter van Hardenberg wrote: >> >>> Hi Nickolay, >>> >>> we haven't figured this out yet. Assuming you're on a production plan, >>> you could email me the requisite dictionary and I can try dropping it in >>> place for you on an experimental basis. Coming up with a better mechanism >>> for this is an interesting project. Ideally, it should be something you can >>> do yourself through some built-in mechanism in Postgres. >>> >>> >>> On Sat, Mar 2, 2013 at 2:56 PM, Nickolay Kolev <nmk...@gmail.com> wrote: >>> >>>> Hi all, >>>> >>>> is there a way of adding a text search dictionary and configuration to >>>> a Heroku Postgres DB? One cannot access $SHAREDIR in order to put the >>>> dictionary files there, so an alternative is required. >>>> >>>> I would not mind putting the dictionary files in migrations if required. >>>> >>>> I am very happy with the performance and results of the TSearch2 German >>>> Compound dictionary and would like to use it in a Heroku-hosted project. >>>> >>>> Best, >>>> Nickolay >>>> >>>> -- >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Heroku" group. >>>> >>>> To unsubscribe from this group, send email to >>>> heroku+un...@googlegroups.com >>>> >>>> For more options, visit this group at >>>> http://groups.google.com/group/heroku?hl=en_US?hl=en >>>> >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "Heroku Community" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to heroku+un...@googlegroups.com. >>>> >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> -- >> -- >> You received this message because you are subscribed to the Google >> Groups "Heroku" group. >> >> To unsubscribe from this group, send email to >> heroku+unsubscr...@googlegroups.com >> For more options, visit this group at >> http://groups.google.com/group/heroku?hl=en_US?hl=en >> >> --- >> You received this message because you are subscribed to the Google Groups >> "Heroku Community" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to heroku+unsubscr...@googlegroups.com. >> For more options, visit https://groups.google.com/d/optout. >> > > -- > -- > You received this message because you are subscribed to the Google > Groups "Heroku" group. > > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/heroku?hl=en_US?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "Heroku Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to heroku+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Cheers Available on the App Store <https://www.google.com/url?q=https%3A%2F%2Fitunes.apple.com%2Fau%2Fapp%2Fworkible%2Fid626140962%3Fmt%3D8%26ign-mpt%3Duo%3D4&sa=D&sntz=1&usg=AFrqEzfOZtxdQT6B6EY_u9_Td_ALICFpLg> and Google Play <https://play.google.com/store/apps/details?id=au.com.hiremeup.workible> Chris Martin PO Box 554, Drummoyne NSW 2047 Australia m: +61.419.812.371 e: ch...@workible.com.au | w: www.workible.com.au <http://www.google.com/url?q=http%3A%2F%2Fwww.workible.com.au%2F&sa=D&sntz=1&usg=AFrqEzfrEI7ku162UhibLHOmtDjlE_uVmQ> facebook <https://www.google.com/url?q=https%3A%2F%2Fwww.facebook.com%2FWorkible&sa=D&sntz=1&usg=AFrqEzdoq3uP4h-iSOXPqnuI0fepVawdXQ> | twitter <https://www.google.com/url?q=https%3A%2F%2Ftwitter.com%2FWorkible&sa=D&sntz=1&usg=AFrqEzfwloI7bKFSRcTHFrWfWybA_4j-Pw> | pinterest <http://pinterest.com/workible/> | linkedin <http://www.google.com/url?q=http%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fhiremeup%2Fproducts%3Ftrk%3Dtop_nav_products&sa=D&sntz=1&usg=AFrqEzdGoO31SS3bks6-LeOhOFp2bVokxw> . The information contained in this message may be privileged and confidential. Any dissemination, distribution, copying of or taking of any action in reliance upon this message, other than to/by the addressee, is strictly prohibited -- -- You received this message because you are subscribed to the Google Groups "Heroku" group. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en_US?hl=en --- You received this message because you are subscribed to the Google Groups "Heroku Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to heroku+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
