W
A
W
F
N
M
MMMMW
C
J
A
M
HM
H
is the only answer we can provide atmWMWMWN
PP
BAB
CM
/accounts/{account-identifier}/d1/database)WNAM region but I'd prefer Europe 
KM
M
N
JJ
J
MM
SC
DB.prepare('select * from blog').all() But the stored frontmatter is returning json as string instead of automatically parsing it out as json. MC
JSON.parse() or is there any way to do this automatically ? I read somewhere, that libraries like kysley or drizzle does this automatically, but I dont want to add extra layer of code and stick to prepare statementsM[[d1_databases]]
binding = "DB"
database_name = "mydb"
database_id = "main-id"
preview_database_id = "preview-id"next dev/accounts/{account-identifier}/d1/databaseWNAM binding __D1_BETA__DB of type d1 failed to generate. Please try again later or contact support.
[code: 10021]CREATE TABLE blog (
id TEXT PRIMARY KEY,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
content_url TEXT,
frontmatter JSON,
slug TEXT UNIQUE,
title TEXT,
website_ref_id TEXT,
FOREIGN KEY (website_ref_id) REFERENCES website(id)
);DB.prepare('select * from blog').all()JSON.parse()/*
SQLite does not support "Changing existing column type" out of the box, we do not generate automatic migration for that, so it has to be done manually
Please refer to: https://www.techonthenet.com/sqlite/tables/alter_table.php
https://www.sqlite.org/lang_altertable.html
https://stackoverflow.com/questions/2083543/modify-a-columns-type-in-sqlite3
Due to that we don't generate migration automatically and it has to be done manually
*/