@Ryan : Thanks for you reply i tried your way got some linkage error but I figured it out the final command which work was:
*gcc -O2 -lpthread -ldl sqlite3.c shell.c -o sqlite3 * The object file is ready for use but, I can figure out where the database is actually getting stored. I mean that when, I run the sqlite3 object file and then the command: *.database* I get these database: seq name file --- --------------- ---------------------------------------------------------- 0 main 1 temp If, I enter some records here it gets into temp table and after exit when, I tired to see those records they are gone. How to build permanent database and add records to it. Thanks in advance.. Thanks & Regards ---------------------------- Pratik Patodi On 21 March 2013 21:30, Ryan Johnson <ryan.john...@cs.utoronto.ca> wrote: > On 21/03/2013 11:47 AM, Simon Slavin wrote: > >> On 21 Mar 2013, at 4:43am, Pratik Patodi <pratik.patod...@gmail.com> >> wrote: >> >> I want to install sqlite 3.7.11 in my ubuntu 10.04. >>> Got the source code but no the makefile/config file. >>> >>> From where can ,I Download the set-up and how to install it. >>> >> SQLite is not something you install into your computer, where it is then >> used by lots of programs. Instead the person writing each program which >> needs it includes it as part of their sourcecode. >> > Perhaps OP conflated the stand-alone sqlite CLI shell with sqlite itself? > Installing the CLI should be as simple as: > > 1. Download the source amalgam > 2. gcc -O2 sqlite3.c shell.c -o sqlite3 > 3. Copy the `sqlite3' binary to wherever it will be most convenient to use > > Ryan > > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<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