Re: Using custom tsearch dictionaries

[daviddlowe . flimm]

I also would like to be able to load custom files into Heroku Postgres 
full-text search configuration. As far as I can tell, this is currently not 
possible.

On Monday, 29 February 2016 08:59:46 UTC+1, Bernard Łabno wrote:
>
> Any update on this? I also need full-text search with custom synonyms.
>
> W dniu czwartek, 12 czerwca 2014 08:32:54 UTC+2 użytkownik Chris Martin 
> napisał:
>>
>> 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  
>> 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,  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  
> 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.
>>  
>>  
>>
>
>>>

Re: Using custom tsearch dictionaries

[Bernard Łabno]

Any update on this? I also need full-text search with custom synonyms.

W dniu czwartek, 12 czerwca 2014 08:32:54 UTC+2 użytkownik Chris Martin 
napisał:
>
> 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  > 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, > 
>> 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  
 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+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 b

Re: Using custom tsearch dictionaries

[Chris Martin]

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 
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,  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  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 u

Re: Using custom tsearch dictionaries

[Peter van Hardenberg]

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,  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  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.

Re: Using custom tsearch dictionaries

[chris]

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  > 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.

Re: Using custom tsearch dictionaries

[Peter van Hardenberg]

Hey there,

I'd rather not muck around with the hosts running the free tier. We don't
know a whole lot about what kinds of problems that might cause and any
issues would potentially impact a lot of users. We're quite strict about
not modifying Postgres for our own needs in general, but if you find a way
to get it done which you think we might be cool with, I'm happy to discuss
rolling that out. I've also forwarded your question on to some Postgres
hackers I know to see if they have any bright ideas.

-p


On Sat, Mar 2, 2013 at 3:28 PM, Nickolay Kolev  wrote:

> Hi Peter,
>
> thank you for your offer! I am not on a production plan (yet). Still using
> the free tier.
>
> I guess it boils down to getting the data to the DB and having "CREATE
> TEXT SEARCH DICTIONARY ..." and "CREATE TEXT SEARCH CONFIGURATION ..."
> take that data from somewhere else than files in $SHAREDIR.
>
> The first part is not that hard (one can access the DB with psql after all
> and dump the data in a table) but the second one depends on Postgres
> support. So far  have found nothing in the docs that suggests that Postgres
> can read dictionary data from anywhere else than $SHAREDIR, let alone use
> data in a table.
>
> Best,
> Nickolay
>
> On Sunday, March 3, 2013 12:16:31 AM UTC+1, 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  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/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/groups/opt_out.

Re: Using custom tsearch dictionaries

[Nickolay Kolev]

Hi Peter,

thank you for your offer! I am not on a production plan (yet). Still using 
the free tier.

I guess it boils down to getting the data to the DB and having "CREATE TEXT 
SEARCH DICTIONARY ..." and "CREATE TEXT SEARCH CONFIGURATION ..." take that 
data from somewhere else than files in $SHAREDIR.

The first part is not that hard (one can access the DB with psql after all 
and dump the data in a table) but the second one depends on Postgres 
support. So far  have found nothing in the docs that suggests that Postgres 
can read dictionary data from anywhere else than $SHAREDIR, let alone use 
data in a table.

Best,
Nickolay

On Sunday, March 3, 2013 12:16:31 AM UTC+1, 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 
> > 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/groups/opt_out.

Re: Using custom tsearch dictionaries

[Peter van Hardenberg]

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  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+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/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/groups/opt_out.

Using custom tsearch dictionaries

[Nickolay Kolev]

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+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/groups/opt_out.