<html><head><title>SQLite Documentation</title></head> <body bgcolor="white" link="#50695f" vlink="#508896"> <table width="100%" border="0"> <tr><td valign="top"> <a href="index.html"><img src="sqlite.gif" border="none"></a></td> <td width="100%"></td> <td valign="bottom"> <ul> <li><a href="http://www.sqlite.org/cvstrac/tktnew">bugs</a></li> <li><a href="changes.html">changes</a></li> <li><a href="contrib">contrib</a></li> <li><a href="download.html#cvs">cvs repository</a></li> <li><a href="docs.html">documentation</a></li> </ul> </td> <td width="10"></td> <td valign="bottom"> <ul> <li><a href="download.html">download</a></li> <li><a href="faq.html">faq</a></li> <li><a href="index.html">home</a></li> <li><a href="support.html">mailing list</a></li> <li><a href="index.html">news</a></li> </ul> </td> <td width="10"></td> <td valign="bottom"> <ul> <li><a href="quickstart.html">quick start</a></li> <li><a href="support.html">support</a></li> <li><a href="lang.html">syntax</a></li> <li><a href="http://www.sqlite.org/cvstrac/timeline">timeline</a></li> <li><a href="http://www.sqlite.org/cvstrac/wiki">wiki</a></li> </ul> </td> </tr></table> <table width="100%"> <tr><td bgcolor="#80a796"></td></tr> </table> <h2>Available Documentation</h2> <table width="100%" cellpadding="5"> <tr><td valign="top" align="right"> <a href="whentouse.html">Appropriate Uses For SQLite</a></td> <td width="10"></td> <td valign="top" align="left"> This document describes situations where SQLite is an approriate database engine to use versus situations where a client/server database engine might be a better choice. </td></tr> <tr><td valign="top" align="right"> <a href="different.html">Distinctive Features</a></td> <td width="10"></td> <td valign="top" align="left"> This document enumerates and describes some of the features of SQLite that make it different from other SQL database engines. </td></tr> <tr><td valign="top" align="right"> <a href="quickstart.html">SQLite In 5 Minutes Or Less</a></td> <td width="10"></td> <td valign="top" align="left"> A very quick introduction to programming with SQLite. </td></tr> <tr><td valign="top" align="right"> <a href="lang.html">SQL Syntax</a></td> <td width="10"></td> <td valign="top" align="left"> This document describes the SQL language that is understood by SQLite. </td></tr> <tr><td valign="top" align="right"> <a href="capi3ref.html">Version 3 C/C++ API<br>Reference</a></td> <td width="10"></td> <td valign="top" align="left"> This document describes each API function separately. </td></tr> <tr><td valign="top" align="right"> <a href="sharedcache.html">Sharing Cache Mode</a></td> <td width="10"></td> <td valign="top" align="left"> Version 3.3.0 and later supports the ability for two or more database connections to share the same page and schema cache. This feature is useful for certain specialized applications. </td></tr> <tr><td valign="top" align="right"> <a href="tclsqlite.html">Tcl API</a></td> <td width="10"></td> <td valign="top" align="left"> A description of the TCL interface bindings for SQLite. </td></tr> <tr><td valign="top" align="right"> <a href="pragma.html">Pragma commands</a></td> <td width="10"></td> <td valign="top" align="left"> This document describes SQLite performance tuning options and other special purpose database commands. </td></tr> <tr><td valign="top" align="right"> <a href="version3.html">SQLite Version 3</a></td> <td width="10"></td> <td valign="top" align="left"> A summary of of the changes between SQLite version 2.8 and SQLite version 3.0. </td></tr> <tr><td valign="top" align="right"> <a href="capi3.html">Version 3 C/C++ API</a></td> <td width="10"></td> <td valign="top" align="left"> A description of the C/C++ interface bindings for SQLite version 3.0.0 and following. </td></tr> <tr><td valign="top" align="right"> <a href="datatype3.html">Version 3 DataTypes </a></td> <td width="10"></td> <td valign="top" align="left"> SQLite version 3 introduces the concept of manifest typing, where the type of a value is associated with the value itself, not the column that it is stored in. This page describes data typing for SQLite version 3 in further detail. </td></tr> <tr><td valign="top" align="right"> <a href="lockingv3.html">Locking And Concurrency<br>In SQLite Version 3</a></td> <td width="10"></td> <td valign="top" align="left"> A description of how the new locking code in version 3 increases concurrancy and decreases the problem of writer starvation. </td></tr> <tr><td valign="top" align="right"> <a href="optoverview.html">Overview Of The Optimizer</a></td> <td width="10"></td> <td valign="top" align="left"> A quick overview of the various query optimizations that are attempted by the SQLite code generator. </td></tr> <tr><td valign="top" align="right"> <a href="nulls.html">Null Handling</a></td> <td width="10"></td> <td valign="top" align="left"> Different SQL database engines handle NULLs in different ways. The SQL standards are ambiguous. This document describes how SQLite handles NULLs in comparison with other SQL database engines. </td></tr> <tr><td valign="top" align="right"> <a href="copyright.html">Copyright</a></td> <td width="10"></td> <td valign="top" align="left"> SQLite is in the public domain. This document describes what that means and the implications for contributors. </td></tr> <tr><td valign="top" align="right"> <a href="omitted.html">Unsupported SQL</a></td> <td width="10"></td> <td valign="top" align="left"> This page describes features of SQL that SQLite does not support. </td></tr> <tr><td valign="top" align="right"> <a href="c_interface.html">Version 2 C/C++ API</a></td> <td width="10"></td> <td valign="top" align="left"> A description of the C/C++ interface bindings for SQLite through version 2.8 </td></tr> <tr><td valign="top" align="right"> <a href="datatypes.html">Version 2 DataTypes </a></td> <td width="10"></td> <td valign="top" align="left"> A description of how SQLite version 2 handles SQL datatypes. Short summary: Everything is a string. </td></tr> <tr><td valign="top" align="right"> <a href="changes.html">Release History</a></td> <td width="10"></td> <td valign="top" align="left"> A chronology of SQLite releases going back to version 1.0.0 </td></tr> <tr><td valign="top" align="right"> <a href="speed.html">Speed Comparison</a></td> <td width="10"></td> <td valign="top" align="left"> The speed of version 2.7.6 of SQLite is compared against PostgreSQL and MySQL. </td></tr> <tr><td valign="top" align="right"> <a href="arch.html">Architecture</a></td> <td width="10"></td> <td valign="top" align="left"> An architectural overview of the SQLite library, useful for those who want to hack the code. </td></tr> <tr><td valign="top" align="right"> <a href="vdbe.html">VDBE Tutorial</a></td> <td width="10"></td> <td valign="top" align="left"> The VDBE is the subsystem within SQLite that does the actual work of executing SQL statements. This page describes the principles of operation for the VDBE in SQLite version 2.7. This is essential reading for anyone who want to modify the SQLite sources. </td></tr> <tr><td valign="top" align="right"> <a href="opcode.html">VDBE Opcodes</a></td> <td width="10"></td> <td valign="top" align="left"> This document is an automatically generated description of the various opcodes that the VDBE understands. Programmers can use this document as a reference to better understand the output of EXPLAIN listings from SQLite. </td></tr> <tr><td valign="top" align="right"> <a href="compile.html">Compilation Options</a></td> <td width="10"></td> <td valign="top" align="left"> This document describes the compile time options that may be set to modify the default behaviour of the library or omit optional features in order to reduce binary size. </td></tr> <tr><td valign="top" align="right"> <a href="formatchng.html">Backwards Compatibility</a></td> <td width="10"></td> <td valign="top" align="left"> This document details all of the incompatible changes to the SQLite file format that have occurred since version 1.0.0. </td></tr> </table> <table width="100%"> <tr><td bgcolor="#80a796"></td></tr> </table> <small><i>This page last modified on 2006/01/30 16:20:30</i></small> </body></html>
