Here is what you do to start experimenting with SQLite without having +to do a lot of tedious reading and configuration:
+ +Get a copy of the prebuilt binaries for your machine, or get a copy +of the sources and compile them yourself. Visit +the download page for more information.
At a shell or DOS prompt, enter: "sqlite3 test.db". This will +create a new database named "test.db". (You can use a different name if +you like.)
Enter SQL commands at the prompt to create and populate the +new database.
Additional documentation is available here
Below is a simple TCL program that demonstrates how to use +the TCL interface to SQLite. The program executes the SQL statements +given as the second argument on the database defined by the first +argument. The commands to watch for are the sqlite3 command +on line 7 which opens an SQLite database and creates +a new TCL command named "db" to access that database, the +invocation of the db command on line 8 to execute +SQL commands against the database, and the closing of the database connection +on the last line of the script.
+ +
+#!/usr/bin/tclsh
+if {$argc!=2} {
+ puts stderr "Usage: %s DATABASE SQL-STATEMENT"
+ exit 1
+}
+load /usr/lib/tclsqlite3.so Sqlite3
+sqlite3 db [lindex $argv 0]
+db eval [lindex $argv 1] x {
+ foreach v $x(*) {
+ puts "$v = $x($v)"
+ }
+ puts ""
+}
+db close
+Below is a simple C program that demonstrates how to use +the C/C++ interface to SQLite. The name of a database is given by +the first argument and the second argument is one or more SQL statements +to execute against the database. The function calls to pay attention +to here are the call to sqlite3_open() on line 22 which opens +the database, sqlite3_exec() on line 27 that executes SQL +commands against the database, and sqlite3_close() on line 31 +that closes the database connection.
+ +
+#include <stdio.h>
+#include <sqlite3.h>
+
+static int callback(void *NotUsed, int argc, char **argv, char **azColName){
+ int i;
+ for(i=0; i<argc; i++){
+ printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
+ }
+ printf("\n");
+ return 0;
+}
+
+int main(int argc, char **argv){
+ sqlite3 *db;
+ char *zErrMsg = 0;
+ int rc;
+
+ if( argc!=3 ){
+ fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
+ exit(1);
+ }
+ rc = sqlite3_open(argv[1], &db);
+ if( rc ){
+ fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
+ sqlite3_close(db);
+ exit(1);
+ }
+ rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
+ if( rc!=SQLITE_OK ){
+ fprintf(stderr, "SQL error: %s\n", zErrMsg);
+ sqlite3_free(zErrMsg);
+ }
+ sqlite3_close(db);
+ return 0;
+}
+