Small. Fast. Reliable.
Choose any three.

Search results 81..90 of 302 for: sqlite

SQLite Backup API
(backup.html)
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 ... 
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 ... 
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 ... 
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 ... 
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 ... 
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 ... 

12345678910

Page generated by FTS5 in about 496.37 ms.