📄 requirements.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"><html><head><title>SQLite Requirements</title><style type="text/css">body { margin: auto; font-family: "Verdana" "sans-serif"; padding: 8px 1%;}a { color: #45735f }a:visited { color: #734559 }.logo { position:absolute; margin:3px; }.tagline { float:right; text-align:right; font-style:italic; width:240px; margin:12px; margin-top:58px;}.toolbar { font-variant: small-caps; text-align: center; line-height: 1.6em; margin: 0; padding:1px 8px;}.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }.toolbar a:visited { color: white; }.toolbar a:hover { color: #80a796; background: white; }.content { margin: 5%; }.content dt { font-weight:bold; }.content dd { margin-bottom: 25px; margin-left:20%; }.content ul { padding:0px; padding-left: 15px; margin:0px; }/* rounded corners */.se { background: url(images/se.png) 100% 100% no-repeat #80a796}.sw { background: url(images/sw.png) 0% 100% no-repeat }.ne { background: url(images/ne.png) 100% 0% no-repeat }.nw { background: url(images/nw.png) 0% 0% no-repeat }</style><meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head><body><div><!-- container div to satisfy validator --><a href="index.html"><img class="logo" src="images/SQLite.gif" alt="SQLite Logo" border="0"></a><div><!-- IE hack to prevent disappearing logo--></div><div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div><table width=100% style="clear:both"><tr><td> <div class="se"><div class="sw"><div class="ne"><div class="nw"> <div class="toolbar"> <a href="about.html">About</a> <a href="sitemap.html">Sitemap</a> <a href="docs.html">Documentation</a> <a href="download.html">Download</a> <a href="copyright.html">License</a> <a href="news.html">News</a> <a href="http://www.sqlite.org/cvstrac/index">Developers</a> <a href="support.html">Support</a> </div></div></div></div></div></td></tr></table> <p>This document contains the text of all requirements that definethe operation of SQLite.</p><p>This document is currently a work in progress. It is incompleteand inaccurate. Check back later for further updates.</p><h2>Requirements</h2><table border="0" cellpadding="5" cellspacing="0"><tr><td valign="top">F10010</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_VERSION "3.5.8"#define SQLITE_VERSION_NUMBER 3005008</pre></blockquote></td></tr><tr><td valign="top">F10011</td><td valign="top">The SQLITE_VERSION #define in the sqlite3.h header fileevaluates to a string literal that is the SQLite versionwith which the header file is associated.</td></tr><tr><td valign="top">F10014</td><td valign="top">The SQLITE_VERSION_NUMBER #define resolves to an integerwith the value (X*1000000 + Y*1000 + Z) where X, Y, andZ are the major version, minor version, and release number.</td></tr><tr><td valign="top">F10020</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>SQLITE_EXTERN const char sqlite3_version[];const char *sqlite3_libversion(void);int sqlite3_libversion_number(void);</pre></blockquote></td></tr><tr><td valign="top">F10021</td><td valign="top">The <a href="c3ref/libversion.html">sqlite3_libversion_number()</a> interface returns an integerequal to <a href="c3ref/c_version.html">SQLITE_VERSION_NUMBER</a>.</td></tr><tr><td valign="top">F10022</td><td valign="top">The <a href="c3ref/libversion.html">sqlite3_version</a> string constant contains the text of the<a href="c3ref/c_version.html">SQLITE_VERSION</a> string.</td></tr><tr><td valign="top">F10023</td><td valign="top">The <a href="c3ref/libversion.html">sqlite3_libversion()</a> function returnsa pointer to the <a href="c3ref/libversion.html">sqlite3_version</a> string constant.</td></tr><tr><td valign="top">F10100</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>int sqlite3_threadsafe(void);</pre></blockquote></td></tr><tr><td valign="top">F10101</td><td valign="top">The <a href="c3ref/threadsafe.html">sqlite3_threadsafe()</a> function returns nonzero ifSQLite was compiled with its mutexes enabled or zeroif SQLite was compiled with mutexes disabled.</td></tr><tr><td valign="top">F10200</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#ifdef SQLITE_INT64_TYPE typedef SQLITE_INT64_TYPE sqlite_int64; typedef unsigned SQLITE_INT64_TYPE sqlite_uint64;#elif defined(_MSC_VER) || defined(__BORLANDC__) typedef __int64 sqlite_int64; typedef unsigned __int64 sqlite_uint64;#else typedef long long int sqlite_int64; typedef unsigned long long int sqlite_uint64;#endiftypedef sqlite_int64 sqlite3_int64;typedef sqlite_uint64 sqlite3_uint64;</pre></blockquote></td></tr><tr><td valign="top">F10201</td><td valign="top">The <a href="c3ref/int64.html">sqlite_int64</a> and <a href="c3ref/int64.html">sqlite3_int64</a> types specify a64-bit signed integer.</td></tr><tr><td valign="top">F10202</td><td valign="top">The <a href="c3ref/int64.html">sqlite_uint64</a> and <a href="c3ref/int64.html">sqlite3_uint64</a> types specifya 64-bit unsigned integer.</td></tr><tr><td valign="top">F10210</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_OK 0 /* Successful result *//* beginning-of-error-codes */#define SQLITE_ERROR 1 /* SQL error or missing database */#define SQLITE_INTERNAL 2 /* Internal logic error in SQLite */#define SQLITE_PERM 3 /* Access permission denied */#define SQLITE_ABORT 4 /* Callback routine requested an abort */#define SQLITE_BUSY 5 /* The database file is locked */#define SQLITE_LOCKED 6 /* A table in the database is locked */#define SQLITE_NOMEM 7 /* A malloc() failed */#define SQLITE_READONLY 8 /* Attempt to write a readonly database */#define SQLITE_INTERRUPT 9 /* Operation terminated by sqlite3_interrupt()*/#define SQLITE_IOERR 10 /* Some kind of disk I/O error occurred */#define SQLITE_CORRUPT 11 /* The database disk image is malformed */#define SQLITE_NOTFOUND 12 /* NOT USED. Table or record not found */#define SQLITE_FULL 13 /* Insertion failed because database is full */#define SQLITE_CANTOPEN 14 /* Unable to open the database file */#define SQLITE_PROTOCOL 15 /* NOT USED. Database lock protocol error */#define SQLITE_EMPTY 16 /* Database is empty */#define SQLITE_SCHEMA 17 /* The database schema changed */#define SQLITE_TOOBIG 18 /* String or BLOB exceeds size limit */#define SQLITE_CONSTRAINT 19 /* Abort due to constraint violation */#define SQLITE_MISMATCH 20 /* Data type mismatch */#define SQLITE_MISUSE 21 /* Library used incorrectly */#define SQLITE_NOLFS 22 /* Uses OS features not supported on host */#define SQLITE_AUTH 23 /* Authorization denied */#define SQLITE_FORMAT 24 /* Auxiliary database format error */#define SQLITE_RANGE 25 /* 2nd parameter to sqlite3_bind out of range */#define SQLITE_NOTADB 26 /* File opened that is not a database file */#define SQLITE_ROW 100 /* sqlite3_step() has another row ready */#define SQLITE_DONE 101 /* sqlite3_step() has finished executing *//* end-of-error-codes */</pre></blockquote></td></tr><tr><td valign="top">F10220</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_IOERR_READ (SQLITE_IOERR | (1<<8))#define SQLITE_IOERR_SHORT_READ (SQLITE_IOERR | (2<<8))#define SQLITE_IOERR_WRITE (SQLITE_IOERR | (3<<8))#define SQLITE_IOERR_FSYNC (SQLITE_IOERR | (4<<8))#define SQLITE_IOERR_DIR_FSYNC (SQLITE_IOERR | (5<<8))#define SQLITE_IOERR_TRUNCATE (SQLITE_IOERR | (6<<8))#define SQLITE_IOERR_FSTAT (SQLITE_IOERR | (7<<8))#define SQLITE_IOERR_UNLOCK (SQLITE_IOERR | (8<<8))#define SQLITE_IOERR_RDLOCK (SQLITE_IOERR | (9<<8))#define SQLITE_IOERR_DELETE (SQLITE_IOERR | (10<<8))#define SQLITE_IOERR_BLOCKED (SQLITE_IOERR | (11<<8))#define SQLITE_IOERR_NOMEM (SQLITE_IOERR | (12<<8))</pre></blockquote></td></tr><tr><td valign="top">F10223</td><td valign="top">The symbolic name for an extended result code always containsa related primary result code as a prefix.</td></tr><tr><td valign="top">F10224</td><td valign="top">Primary result code names contain a single "_" character.</td></tr><tr><td valign="top">F10225</td><td valign="top">Extended result code names contain two or more "_" characters.</td></tr><tr><td valign="top">F10226</td><td valign="top">The numeric value of an extended result code contains thenumeric value of its corresponding primary result code inits least significant 8 bits.</td></tr><tr><td valign="top">F10230</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_OPEN_READONLY 0x00000001#define SQLITE_OPEN_READWRITE 0x00000002#define SQLITE_OPEN_CREATE 0x00000004#define SQLITE_OPEN_DELETEONCLOSE 0x00000008#define SQLITE_OPEN_EXCLUSIVE 0x00000010#define SQLITE_OPEN_MAIN_DB 0x00000100#define SQLITE_OPEN_TEMP_DB 0x00000200#define SQLITE_OPEN_TRANSIENT_DB 0x00000400#define SQLITE_OPEN_MAIN_JOURNAL 0x00000800#define SQLITE_OPEN_TEMP_JOURNAL 0x00001000#define SQLITE_OPEN_SUBJOURNAL 0x00002000#define SQLITE_OPEN_MASTER_JOURNAL 0x00004000</pre></blockquote></td></tr><tr><td valign="top">F10240</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_IOCAP_ATOMIC 0x00000001#define SQLITE_IOCAP_ATOMIC512 0x00000002#define SQLITE_IOCAP_ATOMIC1K 0x00000004#define SQLITE_IOCAP_ATOMIC2K 0x00000008#define SQLITE_IOCAP_ATOMIC4K 0x00000010#define SQLITE_IOCAP_ATOMIC8K 0x00000020#define SQLITE_IOCAP_ATOMIC16K 0x00000040#define SQLITE_IOCAP_ATOMIC32K 0x00000080#define SQLITE_IOCAP_ATOMIC64K 0x00000100#define SQLITE_IOCAP_SAFE_APPEND 0x00000200#define SQLITE_IOCAP_SEQUENTIAL 0x00000400</pre></blockquote></td></tr><tr><td valign="top">F10250</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_LOCK_NONE 0#define SQLITE_LOCK_SHARED 1#define SQLITE_LOCK_RESERVED 2#define SQLITE_LOCK_PENDING 3#define SQLITE_LOCK_EXCLUSIVE 4</pre></blockquote></td></tr><tr><td valign="top">F10260</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_SYNC_NORMAL 0x00002#define SQLITE_SYNC_FULL 0x00003#define SQLITE_SYNC_DATAONLY 0x00010</pre></blockquote></td></tr><tr><td valign="top">F10265</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_INTEGER 1#define SQLITE_FLOAT 2#define SQLITE_BLOB 4#define SQLITE_NULL 5#ifdef SQLITE_TEXT# undef SQLITE_TEXT#else# define SQLITE_TEXT 3#endif#define SQLITE3_TEXT 3</pre></blockquote></td></tr><tr><td valign="top">F10267</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>#define SQLITE_UTF8 1#define SQLITE_UTF16LE 2#define SQLITE_UTF16BE 3#define SQLITE_UTF16 4 /* Use native byte order */#define SQLITE_ANY 5 /* sqlite3_create_function only */#define SQLITE_UTF16_ALIGNED 8 /* sqlite3_create_collation only */</pre></blockquote></td></tr><tr><td valign="top">F10280</td><td valign="top">The sqlite3.h header file defines the following interfaces:<blockquote><pre>typedef void (*sqlite3_destructor_type)(void*);#define SQLITE_STATIC ((sqlite3_destructor_type)0)#define SQLITE_TRANSIENT ((sqlite3_destructor_type)-1)</pre></blockquote></td></tr><tr><td valign="top">F10310</td><td valign="top">The sqlite3.h header file defines the following interfaces:⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -