SQLite is an embeddable SQL Database Engine with an API for C and C++ programs. This is a very small, fast, database...sometimes much faster than MySQL; however, it really
isn't a client server application
Download sqlite-2.x.x.tar.gz and install the program. After the program is installed, you may want to edit the following file: /etc/ld.so.conf
Under Linux, SQLite will install the library files in /usr/local/lib, which should be added to /etc/ld.so.conf. In order for this change to take effect, run $ldconfig
Creating a database and tables is easy from the bash shell.
$sqlite test.db This will create the file test.db in the current directory, and bring up the SQLite interface
SQLite version 2.8.0
Enter ".help" for instructions
Next, create table foo with an AUTOINCREMENT field and populate the table with some records.
sqlite>create table foo(
pkey INTEGER PRIMARY KEY,
sqlite> insert into foo (fname,lname,age) values ('mike','chirico',40);
sqlite> insert into foo (fname,lname,age) values ('zoe','chirico',2);
sqlite> insert into foo (fname,lname,age) values ('abby','chirico',2);
sqlite> insert into foo (fname,lname,age) values ('leah','chirico',2);