Small. Fast. Reliable.
Choose any three.
Choose any three.
|
JSON Functions And Operators
(json1.html)
1. Overview
By default, SQLite supports thirty functions and two operators for
dealing with JSON values. There are also two table-valued functions
that can be used to decompose a JSON string.
There are twenty-six scalar functions and operators:
json(json ...
|
|
Features Of SQLite
(features.html)
... Full-featured SQL implementation
with advanced capabilities like partial indexes,
indexes on expressions, JSON,
common table expressions, and window functions.
(Omitted features)
A complete database is stored in a
single cross-platform disk file.
Great for use as an application ...
|
|
Query Language Understood by SQLite
(lang.html)
... functions
DELETE
DETACH DATABASE
DROP INDEX
DROP TABLE
DROP TRIGGER
DROP VIEW
END TRANSACTION
EXPLAIN
expression
INDEXED BY
INSERT
JSON functions
keywords
math functions
ON CONFLICT clause
PRAGMA
REINDEX
RELEASE SAVEPOINT
REPLACE
RETURNING clause
ROLLBACK TRANSACTION
SAVEPOINT
SELECT
UPDATE
UPSERT ...
|
|
Full-Featured SQL
(fullsql.html)
... expressions including
recursive common table expressions
Row values
UPSERT
An advanced query planner
Full-text search
R-tree indexes
JSON support
The IS operator
Table-valued functions
REPLACE INTO
VACUUM
REINDEX
The GLOB operator
Hexadecimal integer literals
The ON CONFLICT ...
|
|
LoC Recommended Storage Format
(locrsf.html)
1. Overview
... https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml#local
https://www.loc.gov/preservation/resources/rfs/data.html
As of this writing (2018-05-29) the only other recommended storage formats
for datasets are XML, JSON, and CSV.
|
|
List Of Virtual Tables
(vtablist.html)
2. Virtual Tables
... json_each
A table-valued function for decomposing a JSON string.
json_tree
A table-valued function for decomposing a JSON string.
OsQuery
Hundreds of virtual tables that publish various aspects of the
host computer, such as the process table, user lists ...
|
|
The Geopoly Interface To The SQLite R*Tree Module
(geopoly.html)
1.1. GeoJSON
The GeoJSON standard is syntax for
exchanging geospatial information using JSON. GeoJSON is a rich standard
that can describe nearly any kind of geospatial content.
The Geopoly module only understands
a small subset of GeoJSON, but a critical subset.
In ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.2. The "value" column output from the json_tree virtual tables
The json_tree and json_each table-valued functions that are
built into SQLite both have a "value" column that can hold values of
type INTEGER, REAL, or TEXT depending on the type of the corresponding
JSON field. For example:
SELECT typeof ...
|
|
Recent SQLite News
(news.html)
... The most impactful change is likely enhancements to
the JSON SQL functions such that they are now able to
store their internal JSON parse trees in the database
as BLOB values. This can significantly increase the
performance of applications that ...
|
|
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.
API.
In any aggregate function that takes a single argument, that argument
can be preceded by the keyword DISTINCT ...
|
Page generated by FTS5 in about 25.07 ms.