No, I was just trying to study how the whole magic happens when you do
the steps.
My ultimate aim is to port this to a mips platform running linux on it.
I donno whether it will be helpful for my purpose.
Another doubt is that i have downloaded two tar balls from the site.
1. sqlite-amalgamation-3.6.23.tar.gz
<http://www.sqlite.org/sqlite-amalgamation-3.6.23.tar.gz>
2. sqlite-3.6.23.tar.gz <http://www.sqlite.org/sqlite-3.6.23.tar.gz>
Which one should i use, so that i can bring up SQLite in my platform?
The sole reason behind the question is :
The first one does not include any source files.
The second one has the whole set of source files.
Would you please help me with the word "Amalgamation"?
Regards,
*Navaneeth Sen B.*
On 3/23/2010 6:01 PM, Pavel Ivanov wrote:
> Just out of curiosity: what are you need it for? Do you think that
> it's necessary to use SQLite properly?
>
> Pavel
>
> On Tue, Mar 23, 2010 at 8:01 AM, Navaneeth Sen B
> <[email protected]> wrote:
>
>> Hello all,
>>
>> I am new to SQLite software. I have understood the structure of SQLite
>> as described in the "Architecture of SQLite" manual.
>> I am now reading the document named "The Virtual Database Engine of
>> SQLite" which I got from the
>> SQLite site.
>> Currently i am working on Fedora 11 machine with SQLite version 3.6.20.
>> I have a doubt while reading the VDBE program.
>>
>> sqlite> CREATE TABLE sample2(one char, two int, three float);
>> sqlite> EXPLAIN INSERT INTO sample2 VALUES('Sen',685,87.6);
>>
>> addr opcode p1 p2 p3 p4 p5 comment
>> ---- ------------- ---- ---- ---- -------------
>> -- -------------
>> 0 Trace 0 0 0 00
>> 1 Goto 0 11 0 00
>> 2 OpenWrite 0 3 0 3 00
>> 3 NewRowid 0 2 0 00
>> 4 String8 0 3 0 Sen 00
>> 5 Integer 685 4 0 00
>> 6 Real 0 5 0 87.6 00
>> 7 MakeRecord 3 3 6 ade 00
>> 8 Insert 0 6 2 sample2 1b
>> 9 Close 0 0 0 00
>> 10 Halt 0 0 0 00
>> 11 Transaction 0 1 0 00
>> 12 VerifyCookie 0 4 0 00
>> 13 TableLock 0 3 1 sample2 00
>> 14 Goto 0 2 0 00
>>
>> I have many doubts as the vdbe program structure is different from the
>> one explained in the document. The document is for SQLite 2.8.0.
>>
>> Now the area where i need more clarifications are :
>>
>> * OpenWrite
>> * MakeRecord
>> * Stack operations happening when you do a MakeRecord
>> * NewRowid
>> * Insert
>> * TableLock
>>
>> I would like to know the function of each operands in the above stated
>> cases and the related stack operations.
>>
>>
>> --
>> Regards,
>> *Navaneeth Sen B.*
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
