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 ... 

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 ... 

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 ... 

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 ... 

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 Tcl interface to the SQLite library 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 ... 

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 ... 

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 ... 

1. Overview  ... The implementation found in SQLite is a refinement of Guttman's original idea, commonly called "R*Trees", that was described by Norbert Beckmann, Hans-Peter Kriegel, Ralf Schneider, Bernhard Seeger: The R*-Tree: An Efficient and Robust Access Method for ... 

PRAGMA Statements The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for internal (non-table) data. The PRAGMA statement is issued using the ...