Here you can find the Mac Example Source Code and the iPhone Example Source Code.
This is a simple usage example:
Sqlite *sqlite = [[Sqlite alloc] init]; NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES); NSString *documentsDirectory = [paths objectAtIndex:0]; NSString *writableDBPath = [documentsDirectory stringByAppendingPathComponent:@"SQLiteTest.db"]; if (![sqlite open:writableDBPath]) return; [sqlite executeNonQuery:@"CREATE TABLE test (key TEXT NOT NULL, value TEXT);"]; [sqlite executeNonQuery:@"DELETE FROM test;"]; [sqlite executeNonQuery:@"INSERT INTO test VALUES (?, ?);", [Sqlite createUuid], @"PROVA"]; [sqlite executeNonQuery:@"INSERT INTO test VALUES (?, ?);", [Sqlite createUuid], @"PROVA 2"]; [sqlite executeNonQuery:@"INSERT INTO test VALUES (?, ?);", [Sqlite createUuid], @"PROVA 3"]; NSArray *results = [sqlite executeQuery:@"SELECT * FROM test;"]; for (NSDictionary *dictionary in results) { NSLog(@"Row"); for (NSString *key in [dictionary keyEnumerator]) NSLog(@" - %@ %@", key, [dictionary objectForKey:key]); } [results release]; [sqlite release];