Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... There are two more aggregates grouped with the JSON SQL functions.
Applications can define custom aggregate functions using the
sqlite3_create_function() interface.
In any aggregate function that takes a single argument, that argument
can be preceded by the keyword DISTINCT. In ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... CREATE TABLE slide(
pageNumber INTEGER, -- The slide page number
slideContent TEXT -- Slide content as XML or JSON
);
CREATE INDEX slide_pgnum ON slide(pageNumber); -- Optional
The content of each slide could still be stored as compressed XML.
But now each page ...
|
|
SQL Language Expressions
(lang_expr.html)
... For an example, see
JSON subcomponent extraction.
The % operator casts both of its operands to type
INTEGER and then computes the remainder after dividing the left integer
by the right integer. The other arithmetic operators perform integer
arithmetic if both ...
|
|
Compile-time Options
(compile.html)
4. Options To Set Default Parameter Values
... SQLITE_JSON_MAX_DEPTH=N
This macro sets the maximum nesting depth for JSON objects and arrays.
The default value is 1000.
The JSON SQL functions use a
recursive descent parser.
This means that deeply nested JSON might require a lot of stack ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... Date & Time functions,
aggregate functions,
window functions,
math functions, and
JSON functions are documented separately. An
application may define additional
functions written in C and added to the database engine using
the sqlite3_create_function() API.
See the functions within expressions ...
|
|
Run-Time Loadable Extensions
(loadext.html)
4.1. Example Extensions
... json1.c —
Implementation of JSON SQL functions and table-valued functions.
This is a larger and more complex extension.
memvfs.c —
Implementation of a new VFS that stores all content in-memory.
rot13.c —
Implementation of a ...
|
|
How SQLite Is Tested
(testing.html)
4.1.3. The dbsqlfuzz and jfuzz fuzzers
... Jfuzz generates corrupt JSONB blobs and feeds
them into the JSON SQL functions to verify that the JSON functions
are able to safely and efficiently deal with corrupt binary inputs.
|
|
Command Line Shell For SQLite
(cli.html)
22.2. Command-line Options
... or memsys5
-help show this message
-html set output mode to HTML
-interactive force interactive I/O
-json set output mode to 'json'
-line set output mode to 'line'
-list set output mode to 'list'
-lookaside SIZE N use N ...
|
|
Vulnerabilities
(cves.html)
3. Status Of Recent SQLite CVEs
... CVE-2024-0232
3.43.2(2023-10-10)
An attacker that can inject arbitrary SQL statements into an application
might be able to provoke a use-after-free bug in SQLite's JSON parser that
can (in theory) lead ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
1.4. Creating New Virtual Table Implementations
... serve as a template for
other custom virtual tables.
series.c
→ Implementation of the generate_series() table-valued function.
json.c →
Contains the sources for the json_each() and json_tree() table-valued
functions.
csv.c →
A virtual table that ...
|
Page generated by FTS5 in about 123.24 ms.