Re: [sqlite] [Spellfix] Avoiding exact duplicates

2014-07-23 Thread Klaas V
Philip wrote:

>Is it possible to tell the spellfix extension not to accept duplicate 
>words if the rank and langid are exactly the same? I am collecting words 
>from many different sources and after inserting them I very often get 
>the same word back several times.

Add a 'unique' constraint in your create table statement for the column word so 
you can't have double words unless the same word has more meanings.
In that case you need to add e.g. (verb), (noun), [1], [2] or whatever you find 
applicable storing words in a table. 

I don't know if the extension allows you to make changes. 

Kind regards | Cordiali saluti | Vriendelijke groeten | Freundliche Grüsse,
Klaas `Z4us` V  - OrcID -0001-7190-2544
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] [Spellfix] Avoiding exact duplicates

2014-07-23 Thread Philip Bennefall

Hi all,

Is it possible to tell the spellfix extension not to accept duplicate 
words if the rank and langid are exactly the same? I am collecting words 
from many different sources and after inserting them I very often get 
the same word back several times.


Thanks in advance for any tips.

Kind regards,

Philip Bennefall
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users