H
Y
MHHHHH
npx wrangler pages dev --d1=my_d1HHnpx wrangler d1 migrations apply -e staging my_d1 --localH[env.staging]
d1_databases = [
{ binding = "my_d1", database_name = "my_d1_preview", database_id = <UUID> }
]HMHM
Mpages dev
HHMwrangler d1pages dev
Kwrangler.tomlpages dev
H
IIII
II
city in the city column, date
IIIIIIIdatetime() functions which allow you to filter if needed IMM-> and ->>SELECT incidents ->> '$.incident.year' FROM … returns plain SQL instead of JSON.M
npx wrangler pages dev --d1=my_d1npx wrangler d1 migrations apply -e staging my_d1 --local[env.staging]
d1_databases = [
{ binding = "my_d1", database_name = "my_d1_preview", database_id = <UUID> }
]citycitydatetime()SELECT
json_extract(incidents, '$.incident.city') as city
FROM
…
WHERE
city = "CHI"->SELECT incidents ->> '$.incident.year' FROM …env.mydb.prepare('SELECT * FROM incidents').all()env.mydb.prepare("SELECT * FROM incidents WHERE year = '2017'").all()