MBy default, data in local development is not persisted. This means if you write a value into KV, for example, the next time you start local dev, it will no longer exist. Enable persistence with the --persist flag.
M
M
--local--localwrangler pages dev—d1=DB as the docs direct? I haven’t seen you post a full command invocation and am wondering…
M
M
wrangler d1 execute DBNAME --command "SELECT * FROM attempts" results in:wrangler 2.12.3M
M
M
BBBBMM
M
H
—d1=DBwrangler d1 execute DBNAME --command "SELECT * FROM attempts"Mapping SQL input into an array of statements
🌀 Parsing 1 statements
🌀 Executing on DBNAME (DBID):
🚣 Executed 1 command in 4.764229000080377ms
value of stdout.lastframe() is undefinedwrangler 2.12.3wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local --persist-to=./.wranglerERROR: Can't find a DB with name/binding 'DB' in local config. Check info in wrangler.toml...wrangler pages dev ./public --d1=DB --local --persist-to=./.wranglerDROP TABLE IF EXISTS attempts;
CREATE TABLE attempts (pathname TEXT NOT NULL, correct_answer TEXT NOT NULL, user_answer TEXT);await DB.prepare("INSERT INTO attempts (pathname, correct_answer, user_answer) VALUES (?1, ?2, ?3)").bind(route.pathname, route.correctAnswer, userAnswer).run();
// All 3 variables are strings