H
M
H
is the only answer we can provide atm
WMWMW
N
PP
B
AB
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 statementsMK
CCKGLOB should already be limited, as LIKE & GLOB are supposed to be controlled by SQLITE_LIMIT_LIKE_PATTERN_LENGTH which is set to 50.CKCKGLOB is limited to 50 bytes as documented for me
CCKKD
U/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()select id,
content_url,
json(frontmatter) as frontmatter,
slug,
title,
website_ref_id,
created_at
from blogGLOBGLOBGLOBLIKESQLITE_LIMIT_LIKE_PATTERN_LENGTH/*
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
*/d1.prepare('select * from abc where id in(?,?)').bind(1,2)