--local--local--remote# This will yell Unknown argument: local
wrangler d1 create SUBSCRIPTIONS --local
# That's OK, it's local by default so I try
wrangler d1 create SUBSCRIPTIONS
# Then migrate...
wrangler d1 migrations apply SUBSCRIPTIONS
# Then run the app and got...
Uncaught (async) Error: D1_ERROR: Error: SqliteError: no such table: Subscriptions
# So i realized that I will need --local for migration (Took me an hour)
wrangler d1 migrations apply SUBSCRIPTIONS --local# local
wrangler d1 create SUBSCRIPTIONS
wrangler d1 migrations apply SUBSCRIPTIONS
# remote
wrangler d1 create SUBSCRIPTIONS --remote
wrangler d1 migrations apply SUBSCRIPTIONS --remote
M
SS
SM
M
wrangler d1 execute: (some details redacted)MMerror.cause.message as well - https://developers.cloudflare.com/d1/platform/client-api/#errorsMMINSERT operation with fewer than 20 rows, so I can't imagine it was failing due to any kind of size limitMM
M
Error: D1_ERROR: Error: Network connection lost. errors with fairly simple (yet critical) queries my worker is running. The DB is using the experimental d1 backend. Is there a tried and true way to get to the bottom of why this is happening?MMM
IIII
wrangler d1 execute), which allows more granular control than the Ui in the dashboard, and repeatable creations.IM
L
CL
MM
SSS
T
VV
TTM
USSS
-- Create a table. And an external content fts5 table to index it.
CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a');
-- Triggers to keep the FTS index up to date.
CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
END;
CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
S
M
C"@cloudflare/workers-types": "^4.20230710.1"Cfirst return Record<string, T> but not T
C4.20230518.0:CM
wrangler d1 executewrangler d1 execute✘ [ERROR] A request to the Cloudflare API (/accounts/<ACCOUNT_ID>/d1/database/<DATABASE_ID>/query) failed.
Internal error: Error sending request to D1 for database <DATABASE_ID>
[code: 7501]error.cause.messageINSERTError: D1_ERROR: Error: Network connection lost.d1
-- Create a table. And an external content fts5 table to index it.
CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a');
-- Triggers to keep the FTS index up to date.
CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
END;
CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b, old.c);
INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
"@cloudflare/workers-types": "^4.20230710.1"firstRecord<string, T>4.20230518.0declare abstract class D1PreparedStatement {
bind(...values: any[]): D1PreparedStatement;
first<T = unknown>(colName: string): Promise<T | null>;
first<T = unknown>(): Promise<Record<string, T> | null>;
run<T = unknown>(): Promise<D1Result<T>>;
all<T = unknown>(): Promise<D1Result<T[]>>;
raw<T = unknown>(): Promise<T[]>;
}declare abstract class D1PreparedStatement {
bind(...values: any[]): D1PreparedStatement;
first<T = unknown>(colName?: string): Promise<T>;
run<T = unknown>(): Promise<D1Result<T>>;
all<T = unknown>(): Promise<D1Result<T>>;
raw<T = unknown>(): Promise<T[]>;
}