... 2.1 Opening and closing a database typedef struct sqlite3 sqlite3; int sqlite3_open(const char*, sqlite3**); int sqlite3_open16(const void*, sqlite3**); int sqlite3_close(sqlite3*); const char *sqlite3_errmsg(sqlite3*); const void *sqlite3_errmsg16(sqlite3*); int sqlite3_errcode(sqlite3*); The sqlite3_open() routine returns an ... 

SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ... 

 ... This opcode cannot be used to detect transactions opened by clients within the current process, only within other processes. The SQLITE_FCNTL_CKSM_FILE opcode is for use internally by the checksum VFS shim only. If there is currently no transaction open on ... 

 ... If the SQLITE_ENABLE_8_3_NAMES=1 option is used, then SQLite is capable of using 8+3 filenames but that capabilities is disabled and must be enabled separately for each database connection by using using URI filenames when opening or ATTACH-ing ... 

sqlite3_stmt_busy()

 ... This can be used, for example, in diagnostic routines to search for prepared statements that are holding a transaction open. See also lists of Objects, Constants, and Functions.

sqlite3_enable_load_extension()

So as not to open security holes in older applications that are unprepared to deal with extension loading, and as a means of disabling extension loading while evaluating user-entered SQL, the following API is provided to turn the sqlite3_load_extension ... 

3. The Tcl interface to the SQLite library  ... With other arguments, the sqlite3 command opens the database named in the second non-option argument, or named "" if there is no such. If the open succeeds, a new Tcl command named by the first argument is created and "" is ... 

sqlite3_db_filename()

 ... In other words, the filename will be an absolute pathname, even if the filename used to open the database originally was a URI or relative pathname. If the filename pointer returned by this routine is not NULL, then it can ... 

 ... Or, if the application keeps a single database connection open for a long time, then it should run "PRAGMA optimize=0x10002" when the connection is first opened and run "PRAGMA optimize;" periodically thereafter, perhaps once per day or even once ... 

 ... Default builds of SQLite contain appropriate VFS objects for talking to underlying operating system, and those VFS objects will contain operating system calls such as open(), read(), write(), fsync(), and so forth. All of these interfaces are readily available on ... 

 ... The traditional File/Open operation calls sqlite3_open() to attach to the database file. Updates happen automatically as application content is revised so the File/Save menu option becomes superfluous. The File/Save_As menu option can be implemented using the backup ...