Hi Pavel, You are right it contains sqlite3.c and sqlite3.h. "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. ;-)"
My ultimate aim is not to program using SQLite. I just want to know the internals of it? How it works? How i can make a new wrapper around it so that my exsisting applications can use it without huge changes.. Regards, *Navaneeth Sen B.* On 3/23/2010 6:22 PM, Pavel Ivanov wrote: >> 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 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users