Link
Search
Menu
Expand
Document
SQLite SQL Tutorial
Introduction
Metadata and Reflection
Overview
Engine
Basic DB Metadata
Derived DB Metadata and Modular SQL with CTE
Design Patterns
Decoupling SQL
Delimiter-Separated Values
Surrogate Variables
SQL Interface - JSON Input
JSON and DSV Output
Fixed-Width Values
ASCII IDs
Recursive CTEs
RCTEs for Recursive Modify
Materialized Paths
Design Rules
Mock Database
SELECT Descendants
SELECT Ancestors
MPs Modification
CREATE Paths
DELETE Subtrees
MOVE Subtrees
COPY Subtrees
SQLite SQL Tutorial on GitHub
Table of contents
Decoupling SQL
Delimiter-Separated Values
Surrogate Variables
SQL Interface - JSON Input
JSON and DSV Output
Fixed-Width Values
ASCII IDs
Recursive CTEs
RCTEs for Recursive Modify