First snapshoot of iV4CC = Valentina from iPhone :-)

[gary hayenga]

The main advantage I see of using Valentina as a the local database on  
the iPhone as well, is that you would be able to use the exact same  
syntax, and possibly the exact same code, for writing data locally and  
to the database server.  I suppose that if you're using strictly SQL  
to do it, which I usually do, then the differences will be quite small  
if you're using an SQLite cocoa wrapper like FMDB on the iPhone.  So  
the major feature that SQLite is missing, other than a database server  
you can talk to natively, would be Foreign Key Constraints.  Things  
like full text indexing aren't available in the version of SQLite that  
ships on the iPhone, but you can compile and install the most recent  
version yourself, which does have it.

Possibly multi-line inserts, SQLite won't let me do "insert into  
myTable (int1, int2) values (1,1), (2,2), (3,3);"  and it won't let me  
do "insert into myTable (int1, int2) values (1,1);insert into myTable  
(int1, int2) values (2,2);insert into myTable (int1, int2) values  
(3,3);" it will only execute the insert before the first semicolon.  I  
seem to recall that Valentina *would* let me do both of those, and  
inserting or updating large amounts of data over a network is always  
faster when you can send it all as one string instead of thousands of  
separate ones.


On Jan 30, 2009, at 5:26 PM, valentina-request at lists.macserve.net wrote:

>
> Date: Fri, 30 Jan 2009 22:53:44 +0200
> From: Ruslan Zasukhin <sunshine at public.kherson.ua>
> Subject: Re: First snapshoot of iV4CC = Valentina from iPhone :-)
> To: "valentina at lists.macserve.net" <valentina at lists.macserve.net>
> Message-ID: <C5A93578.B685A%sunshine at public.kherson.ua>
> Content-Type: text/plain;	charset="US-ASCII"
>
> On 1/30/09 10:42 PM, "gary hayenga" <vandg at speakeasy.org> wrote:
>
> Hi Gary,
>
>> Excellent!
>>
>> And can you also use a local valentina database on the iPhone also?
>
> Not yet.
>
> This will be the second step
>
> It requires much more job I think, because require implement in  
> special way
>     File class
>     Pictures
>
> File May be is not hard ... Few days.
> Pictures may be also few days :)
>
> But since much more huge amount of sources in kernel -- hundreds  
> files --
> can be surprises.
>
>
> Tell me please what advantage you sees?
> To get better understanding for me
>