Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
SQLite Backup API
(backup.html)
1. Using the SQLite Online Backup API
Historically, backups (copies) of SQLite databases have been created
using the following method:
Establish a shared lock on the database file using the SQLite API (i.e.
the shell tool).
Copy the database file using an external tool (for example ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
1. Introduction
The SQLite library is designed to be very easy to use from
a Tcl or Tcl/Tk script. SQLite
began as a Tcl extension
and the primary test suite for SQLite is written in Tcl and uses
the SQLite extension ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
Automatic Undo/Redo Using SQLite
This page demonstrates how to use triggers to implement undo/redo
logic for an application that uses SQLite as its
application file format.
Object-Oriented Design
This design note considers the database to be a ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
This document was originally created in early 2004 when SQLite version 2
was still in widespread use and was written to introduce
the new concepts of SQLite version 3 to readers who were already familiar
with SQLite version 2. But ...
|
|
The SQLite Zipfile Module
(zipfile.html)
1. Overview
The zipfile module provides read/write access to simple
ZIP archives.
The current implementation has the following restrictions:
Does not support encryption.
Does not support ZIP archives that span multiple files.
Does not support zip64 extensions.
The only compression algorithm ...
|
|
Datatypes In SQLite
(datatype3.html)
1. Datatypes In SQLite
Most SQL database engines (every SQL database engine other than SQLite,
as far as we know) uses static, rigid typing. With static typing, the datatype
of a value is determined by its container - the particular column in
which the value ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
1. Executive Summary
... But with SQLite, 200 or more SQL statement per webpage is not a problem.
SQLite can also do large and complex queries efficiently, just like
client/server databases. But SQLite can do many smaller queries
efficiently too. Application developers can ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
1. Introduction
A virtual table is an object that is registered with an open SQLite
database connection. From the perspective of an SQL statement,
the virtual table object looks like any other table or view.
But behind the scenes, queries and updates ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
1. Introduction
This document provides an overview of how the query planner and optimizer
for SQLite works.
Given a single SQL statement, there might be dozens, hundreds, or even
thousands of ways to implement that statement, depending on the complexity
of the ...
|
Page generated by FTS5 in about 667.63 ms.