A few questions re Valentina compared with SQLite

[bigbird]

Hi Ruslan,

Thank you for your speedy reply - you have a fantastic reputation for  
your support - that speed was amazing!

You said I could use IndexbyWords then mentioned REGEX, does  
IndexbyWords have limitations that would necessitate using REGEX?

Does IndexbyWords make for slow searches or does it just make the  
datafile larger? Or neither.

This search capability is vital for my project so I would like to  
know as much detail as possible - thanks - do you have a document I  
could look at about this?

> You can use in Valentina IndexbyWords for this.
> Also possible to use REGEX I think specifying word boundary flags  
> around.


Are you talking about development or deployment platforms here?

> Valentina is royalty free.
> You need Valentina for REALBasic option
>       199 for single platform
>       299 for 2 platform
>       399 for 3 platforms


I would assume you mean deployment platforms - so to deploy for Mac,  
Win and Linux would be 399?

Thanks again for your speedy reply - I am very impressed!!

Cheers

Greg Olson-Hyde
Sydney Australia

RB 2007r5 Pro, Mac OS X 10.4.11



On 19.04.2008, at 11:16pm, Ruslan Zasukhin wrote:
> On 4/19/08 4:02 PM, "bigbird" <greg at hawkmount.com> wrote:
>
> Hi Greg,
>
>> I am currently using RB 2007r5 and the built in SQLite db - I have
>> struck a problem and need to know if Valentina is a solution.
>>
>> The things I need to know about Valentina are:
>>
>> 1. I have a db with 50,000 records - I need to search and find, say,
>> just the whole word 'HAT' in a long string, SQLite also finds 'tHAT',
>> 'wHAT' and 'HATter' - how would Valentina handle this?
>
> You can use in Valentina IndexbyWords for this.
>
> Also possible to use REGEX I think specifying word boundary flags  
> around.
>
>
>> 2. The current SQLite db is compiled inside the RB app - how is the
>> Valentina db compiled? Will my end user see any difference?
>
> You mean "SQLite engine" I think...
>
> Well, with Valentina you will bundle few dlls, but they will go  
> inside of
>     MyApp.app  package, like do any modern app from Apple for example.
>
> So for end user you still give single solid app.
>
>
>> 3. The current SQLite datafile is 30 MB containing two tables - one
>> with 5,000 records and 15 columns the other 50,000 records and 8
>> columns, is the Valentina datafile likely to be larger or smaller?
>
> Valentina keep strings as UTF16, so strings can take longer, on the  
> other
> hand index files can be more compact...so it needs see special case.
>
>
>> 4. I have only just started to come to grips with SQLite (being a
>> refugee from FMP), how different is the implementation of a Valentina
>> db?
>
> Different from SqlLite ??
>
> Well, you can use similar way you have see there, but exists also  
> few other
> ways of development with Valentina. You can read this in sections  
> Valentina
> WIKI -> Articles
>
>
>> 5. I want to sell my first single user shareware product for around
>> $30, how does the Valentina pricing fit? Which Valentina option would
>> best suit? I have looked at the website and can't figure it out -  
>> sorry!
>
> Valentina is royalty free.
> You need Valentina for REALBasic option
>     199 for single platform
>     299 for 2 platform
>     399 for 3 platforms
>
>
>> 6. Can I upscale to a network solution at a later date?
>
> Yes, easy
>
>> If so, how
>> much does the code change?
>
> 1-2 lines of code.
>
>> How much would it cost:   a. Me?
>
> You will need upgrade to VDN, about $400
>
>> b. The end user?
>
> If you okay with VSERVER with 5 connections -- you get it royalty  
> free.
>     i.e. ZERO for end user.
>
>
>> Cheers
>>
>> Greg Olson-Hyde
>>
>> Sydney Australia
>>
>> RB 2007r5 Pro, Mac OS X 10.4.11
>>
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> -- 
> 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