Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite OS Interface or "VFS"
(vfs.html)
1. Introduction
This article describes the SQLite OS portability layer or "VFS" - the
module at the bottom of the SQLite implementation stack
that provides portability across operating systems.
|
|
SQLite As An Application File Format
(appfileformat.html)
SQLite As An Application File Format
Executive Summary
An SQLite database file with a defined schema
often makes an excellent application file format.
Here are a dozen reasons why this is so:
Simplified Application Development
Single-File Documents
High-Level ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
SQLite Over a Network,Caveats and Considerations
Introduction
Users of the SQLite library, particularly application developers,
who want to access a SQLite database
from different systems connected by a network are often
tempted to simply open a database connection by ...
|
|
SQLite Autoincrement
(autoinc.html)
1. Summary
... In SQLite, a column with type INTEGER PRIMARY KEY is an alias for the ROWID
(except in WITHOUT ROWID tables) which is always a 64-bit signed integer.
On an INSERT, if the ROWID or INTEGER PRIMARY KEY column is ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
1. SQLite Shared-Cache Mode
Starting with version 3.3.0 (2006-01-11),
SQLite includes a special "shared-cache"
mode (disabled by default) intended for use in embedded servers. If
shared-cache mode is enabled and a thread establishes multiple connections
to the same ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
Overview
... This document provides an overview of dynamic memory allocation within
SQLite. The target audience is software engineers who are tuning their
use of SQLite for peak performance in demanding environments.
Nothing in this document is required knowledge for using SQLite ...
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
1. Introduction
... In SQLite, a prepared statement is an instance of the
sqlite3_stmt object. In other systems, the prepared
statement is usually an internal data structure that is not directly visible to
the application programmer. Developers of other SQL database engines
do ...
|
|
Implementation Limits For SQLite
(limits.html)
Limits In SQLite
"Limits" in the context of this article means sizes or
quantities that can not be exceeded. We are concerned
with things like the maximum number of bytes in a
BLOB or the maximum number of columns in ...
|
|
Database Remote-Copy Tool For SQLite
(rsync.html)
1. Overview
The following command causes REPLICA to become a copy of ORIGIN:
$ sqlite3_rsync ORIGIN REPLICA ?OPTIONS?
Use the --help or -? flag to see the
complete list of options. Option flags may appear before, after, or
between the ORIGIN and REPLICA arguments ...
|
|
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 ...
|
Page generated by FTS5 in about 492.92 ms.