SQLite Features You Didn’t Know It Had: JSON, text search, CTE, STRICT, generated columns, WAL
Working with JSON data
SQLite ships with a JSON extension that lets you store and query JSON documents directly in tables.
You can keep your schema flexible while still using SQL to slice and dice structured data.
Example: extracting fields from a JSON column:
CREATE TABLE events (
id INTEGER PRIMARY KEY,
payload TEXT NOT NULL -- JSON
);
SELECT
json_extract(payload, '$.user.id') AS user_id,
json_extract(payload, '$.action') AS action,
json_extract(payload, '$.metadata') AS metadata
FR...
Read more at slicker.me
© News Score score the news, sort the news, rewrite the headlines