A few questions re Valentina compared with SQLite

[bigbird]

Hi Ruslan,

Thank you for all the information - it is early Sunday morning here,  
and I am going to sleep on all the information you have given me - it  
sounds as though Valentina will do everything I want.

Thanks again for your very speedy replies - if Valentina is as fast  
as you are it should be very good - Thanks.

Cheers

Greg Olson-Hyde
Sydney Australia

RB 2007r5 Pro, Mac OS X 10.4.11



On 20.04.2008, at 12:56am, Ruslan Zasukhin wrote:
> On 4/19/08 5:47 PM, "bigbird" <greg at hawkmount.com> wrote:
>
>> Hi Ruslan,
>>
>> Just to clarify, I have a column that could contain the following
>> dummy text records:
>>
>> 1 The man had a HAT.
>> 2 The HAT was on his head.
>> 3 HAT day at the school was a great success.
>> 4 We all saw tHAT the beach was crowded.
>> 5 He was as mad as a HATter.
>> 6 He did not know wHAT he was talking about.
>> 7 HATs are very popular this year.
>>
>> If the user types 'HAT' into the search field, I would like to return
>> records 1, 2 and 3 but NOT records 4, 5, or 6.
>>
>> There will never be just a single word in the column, so '= hat'
>> won't work (as far as I know) - the column may contain well over a
>> hundred words.
>
> Right,
>
> But IndexbyWords split our string to 100 words and add each of them  
> into
> index.
>
>> Ideally, also I would like to be able to return simple 'plurals' like
>> record 7 when 'HAT' was the word searched for.
>
> Valentina not support this directly because this is language  
> dependable.
>
>
>> I would also like to offer an option to the user that would find HAT
>> on its own OR embedded in another word like wHAT if they chose to do
>> so (SQLite ONLY offers this choice, as far as I can see).
>
> I doubt ...
>
> Try in SqlLite this also   fld LIKE 'hat'
>
>
>>> IndexbyWords build special index that keep separate WORDS.
>>>     then search as  WHERE fld = 'hat'  should find EXACT matches
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina