如何创建数据类型jsonblob

Question

表：

id	filejson
1	data1.json
2	data2.json

以下是一些入门知识。更多详细信息，请访问https://www.sqlite.org/json1.html#:~：text=SQLite%20将%20JSON%20存储为%20normal，一个%20binary%20编码%20of%20JSON。

create table json_example (
id      int primary key,
json    text);

insert into json_example
values
(1, '{"name": "jason", "gender": "m"}'),
(2, '{"name": "catherine", "gender": "f"}');
select id,
json,
json_extract(json,'$.name') as name,
json_extract(json,'$.gender') as gender
from json_example;

id|json                                |name     |gender|
--+------------------------------------+---------+------+
1|{"name": "jason", "gender": "m"}    |jason    |m     |
2|{"name": "catherine", "gender": "f"}|catherine|f     |