Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Version 3 Overview
(version3.html)
... When data is inserted into a column, that column will make an attempt
to convert the data format into the column's declared type. All SQL
database engines do this. The difference is that SQLite 3.0 will
still store ...
|
|
Command Line Shell For SQLite
(cli.html)
21. Using sqlite3 in a shell script
... For example:
$ sqlite3 ex1 'select * from tbl1' \
> | awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }'
<tr><td>hello<td>10
<tr><td ...
|
|
Quality Management
(qmplan.html)
3. Software Development Environment
... A C99 compiler such as GCC (including MinGW variants for Windows),
Clang, or MSVC
A text editor of the user's choice supporting UTF-8 text.
Tcl version 8.6 or later.
The "make" utility, or optionally "nmake" on Windows ...
|
|
SQL Language Expressions
(lang_expr.html)
... Each keyword in (BETWEEN IN GLOB LIKE MATCH REGEXP) may be prefixed
by NOT, retaining the bare operator's precedence and associativity.
The COLLATE operator is a unary postfix
operator that assigns a collating sequence to an expression ...
|
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
1. Introduction
SQLite is designed to meet most developer's needs without any
changes or customization. When changes are needed, they can normally
be accomplished using start-time (1)
or runtime
(2)
(3)
(4) configuration methods
or via compile-time options. It ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
2.3. Two processes using different locking protocols
... If one application is using POSIX advisory locks and another application
is using dot-file locking, then the two applications will not see each
other's locks and will not be able to coordinate database access, possibly
leading to database ...
|
|
Implementation Limits For SQLite
(limits.html)
... During part of SQLite's INSERT and SELECT processing, the complete
content of each row in the database is encoded as a single BLOB.
So the SQLITE_MAX_LENGTH parameter also determines the maximum
number of bytes in a row.
The maximum ...
|
|
SELECT
(lang_select.html)
... During the early years of SQLite, the lead developer sought to follow
Postel's Law and to
be forgiving and flexible in what input was accepted.
There were bugs in early SQLite parsers that accepts some strange inputs.
The lead ...
|
|
Window Functions
(windowfunctions.html)
2. Aggregate Window Functions
... All of SQLite's aggregate functions may
be used as aggregate window functions. It is also possible to
create user-defined aggregate window functions.
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... So let's jump right in and
start looking as some code.
Inserting Records Into The Database
We begin with a problem that can be solved using a VDBE program
that is only a few instructions long. Suppose we have ...
|
Page generated by FTS5 in about 67.78 ms.