Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The C language interface to SQLite Version 2
(c_interface.html)
... typedef struct sqlite sqlite;
#define SQLITE_OK 0 /* Successful result */
sqlite *sqlite_open(const char *dbname, int mode, char **errmsg);
void sqlite_close(sqlite *db);
int sqlite_exec(
sqlite *db,
char *sql,
int (*xCallback)(void*,int,char**,char**),
void *pArg,
char **errmsg
);
The above ...
|
|
Command Line Shell For SQLite
(cli.html)
1. Getting Started
The SQLite project provides a simple command-line program named
sqlite3 (or sqlite3.exe on Windows)
that allows the user to manually enter and execute SQL
statements against an SQLite database or against a
ZIP archive. This document provides a ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
Moving From SQLite 3.4.2 to 3.5.0
SQLite version 3.5.0 (2007-09-04) introduces a new OS interface layer that
is incompatible with all prior versions of SQLite. In addition,
a few existing interfaces have ...
|
|
Isolation In SQLite
(isolation.html)
Isolation In SQLite
The "isolation" property of a database determines when changes made to
the database by one operation become visible to other concurrent operations.
Isolation Between Database Connections
If the same database is being read and written using two ...
|
|
SQLite Older News
(oldnews.html)
2015-11-02 - Release 3.9.2
SQLite version 3.9.2 is a patch release fixing two obscure bugs.
(Details: (1),
(2)).
Upgrade only if you are having problems.
2015-10-16 - Release 3.9.1
SQLite version 3 ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... An Introduction To The SQLite C/C++ Interface
SQLite C/C++ Reference Guide
C/C++ Interface For SQLite Version 3
1.0 Overview
SQLite version 3.0 is a new version of SQLite, derived from
the SQLite 2.8.13 ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
What If OpenDocument Used SQLite?
Introduction
Suppose the
OpenDocument file format,
and specifically the "ODP" OpenDocument Presentation format, were
built around SQLite. Benefits would include:
Smaller documents
Faster File/Save times
Faster startup times
Less memory used
Document versioning
A ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
1. Introduction
One of the distinctive features of
SQLite is that a database consists of a single disk file.
This simplifies the use of SQLite since moving or backing up a
database is a simple as copying a single file. It also ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
1. Introduction
An important feature of transactional databases like SQLite
is "atomic commit".
Atomic commit means that either all database changes within a single
transaction occur or none of them occur. With atomic commit, it
is as if many different writes to ...
|
|
SQLite Unlock-Notify API
(unlock_notify.html)
... Otherwise, the
** system may become deadlocked.
*/
int sqlite3_blocking_step(sqlite3_stmt *pStmt){
int rc;
while( SQLITE_LOCKED==(rc = sqlite3_step(pStmt)) ){
rc = wait_for_unlock_notify(sqlite3_db_handle(pStmt));
if( rc!=SQLITE_OK ) break;
sqlite3_reset(pStmt);
}
return rc;
}
/*
** This function is a wrapper around the SQLite function sqlite3_prepare_v2().
** It ...
|
Page generated by FTS5 in about 460.89 ms.