What is SQLite ?

[kex]

This is an extension for the SQLite Embeddable SQL Database Engine. SQLite is a C library that implements an embeddable SQL database engine. Programs that link with the SQLite library can have SQL database access without running a separate RDBMS process.

The program uses SQLite's functionality through simple function calls, which reduces latency in database access as function calls within a single process are more efficient than inter-process communication.

The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite.

[Samir_1]

SQLite implements most of the SQL-92 standard for SQL. For example it has partial support for triggers and supports most complex queries, but it silently ignores referential integrity constraints (foreign key constraints) unless one uses the .genfkey command of the sqlite3 shell tool to compile them into triggers. SQLite uses an unusual type system for an SQL-compatible DBMS. Instead of assigning a type to a column as in most SQL database systems, types are assigned to individual values; in language terms it is dynamically typed. Moreover, it is weakly typed in some of the same ways that Perl is: one can insert a string into an integer column (although SQLite will try to convert the string to an integer first, if the column's preferred type is integer).

[hayeden]

The SQLite extension is enabled by default as of PHP 5. Before that time the SQLite library is needed.
SQLite Methods :

query - Execute a query

sqlite_query -- SQLiteDatabase->query — Executes a query against a given database and returns a result handle.

resource sqlite_query ( resource $dbhandle , string $query [, int $result_type [, string &$error_msg ]] )

resource sqlite_query ( string $query , resource $dbhandle [, int $result_type [, string &$error_msg ]] )

sqlite_query() returns a buffered, seekable result handle. This is useful for reasonably small queries where you need to be able to randomly access the rows. Buffered result handles will allocate memory to hold the entire result and will not return until it has been fetched. If you only need sequential access to the data, it is recommended that you use the much higher performance sqlite_unbuffered_query() instead.

SQLiteDatabase

SQLiteResult query ( string $query [, int $result_type [, string &$error_msg ]] )

Executes an SQL statement given by the query against a given database handle.

[KACY]

It can be very handy to use a database like storage when you have no access to a database service. SQLite uses in iphone for call history, contacts, SMS and other data.