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 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 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 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 ...
|
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 ...
|
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 ...
|
SQLite's Built-in printf()
(printf.html)
1. Overview
SQLite contains its own implementation of the string formatting routine "printf()",
accessible via the following interfaces:
format() → an SQL function returning the formatted string
sqlite3_mprintf() → Store the formatted string in memory obtained
sqlite3_malloc64().
sqlite3_snprintf() → Store the formatted ...
|
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 ...
|
Page generated by FTS5 in about 263.54 ms.