Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Opening A New Database Connection
(c3ref/open.html)
sqlite3_open(), sqlite3_open16()
... If the database is opened (and/or created) successfully, then
SQLITE_OK is returned. Otherwise an error code is returned. The
sqlite3_errmsg() or sqlite3_errmsg16() routines can be used to obtain
an English language description of the error following a failure of ...
|
|
Date And Time Functions
(lang_datefunc.html)
... Modifiers
For all date/time functions other than timediff(),
the time-value argument can be followed by zero or more modifiers that
alter date and/or time. Each modifier
is a transformation that is applied to the time-value to ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
2. Differences From Ordinary Rowid Tables
... The only advantage of a WITHOUT ROWID
table is that it can sometimes use less disk space and/or perform a little
faster than an ordinary rowid table.
For the most part, ordinary rowid tables and WITHOUT ROWID tables
are ...
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
1.1. How To Provide Feedback
... If you disagree with any of the opinions offered in this document, you are
welcomed to offer corrections and/or contrary views on the
SQLite Forum. Or you can email the author
directly.
|
|
Quality Management
(qmplan.html)
2.1. Software Life Cycle
... Releases occur
when there is a critical mass of feature enhancements and/or
bug fixes. Historically, releases have occurred about 5 or 6
times per year.
Users of SQLite pick up new releases from the website on an
as-needed ...
|
|
UPSERT
(lang_upsert.html)
... The only use for the WHERE clause at
the end of the DO UPDATE is to optionally change the DO UPDATE
into a no-op depending on the original and/or new values.
For example:
CREATE TABLE phonebook2(
name TEXT ...
|
|
Datatypes In SQLite
(datatype3.html)
2.2. Date and Time Datatype
SQLite does not have a storage class set aside for storing
dates and/or times.
Instead, the built-in Date And Time Functions of SQLite are capable of
storing dates and times as TEXT, REAL, or INTEGER values:
TEXT as ...
|
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... Note that when type conversions occur, pointers returned by prior
calls to sqlite3_column_blob(), sqlite3_column_text(), and/or
sqlite3_column_text16() may be invalidated.
Type conversions and pointer invalidations might occur
in the following cases:
The initial content is a BLOB and sqlite3_column_text() or ...
|
|
Defense Against The Dark Arts
(security.html)
1.2. Untrusted SQLite Database Files
... or more
of the techniques below to prevent a maliciously crafted database
schema from surreptitiously running those SQL functions and/or
virtual tables for nefarious purposes:
Invoke sqlite3_db_config(db,SQLITE_DBCONFIG_TRUSTED_SCHEMA,0,0)
on each database connection as soon as it ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... The opening and/or creating of the database file is deferred until the
file is actually needed. This allows options and parameters, such
as the native text representation and default page size, to be
set using PRAGMA statements.
The sqlite3_errcode ...
|
Page generated by FTS5 in about 173.71 ms.