> The first one does not include any source files. Are you sure about that? First archive should contain one source file - sqlite3.c which is enough to compile SQLite at least in standard configuration. And btw, if you run Linux then I believe SQLite can be compiled and work right away without any additional platform-specific tuning and learning of internal magic. ;-)
Pavel On Tue, Mar 23, 2010 at 8:47 AM, Navaneeth Sen B <navanee...@tataelxsi.co.in> wrote: > 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 >> <navanee...@tataelxsi.co.in> 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 >>> sqlite-users@sqlite.org >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >>> >>> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users