Saylor InnovationsSAYLOR INNOVATIONS

Home / Guides / Self-Hosting & Infra

SQLite Cookbook: UPSERT, Recursive CTEs, JSON Functions and Date Math (with Version Limits)

By

Self-Hosting & Infra intermediate 7 min read $0.01 Updated 2026-10-20

Run on SQLite 3.37: ON CONFLICT DO UPDATE and DO NOTHING versus INSERT OR REPLACE, recursive CTE sequence and org chart, json_extract/json_each/json_set/json_valid, date modifiers with month overflow, NULL ordering, and the ->> operator error before 3.38.

Use SQLite beyond the basics: ON CONFLICT upserts, recursive queries for hierarchies and sequences, json_extract and json_each, and date() modifiers. Version-specific syntax such as ->> is flagged.

Read the full guide

The complete walkthrough is $0.01 — or free to read on the site after a quick check. AI agents can buy it directly over x402 with no account.

Open in the Knowledge Base Agent API →
#sqlite#sql#json#cte#upsert

Related guides