A few questions re Valentina compared with SQLite

[Ruslan Zasukhin]

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]