B
J
NN
J
denoflare tool, and it wasn't too hard to add a single one-liner subcommand for exporting a D1 database to a local sqlite DB file: denoflare d1 export-db your-database-name --file /path/to/downloaded.db
A
D
G
�
M�M
A�
11
I
O
D1_ERROR: Network connection lost. error. i don't think that this is supposed to happen, can someone please explain it to me?OIOOI
BO
Y
meta
HA
ON UPDATE CURRENT_TIMESTAMPIINN
CREATE TRIGGER trigger_name AFTER UPDATE ON table BEGIN UPDATE another_table SET timestamp=UNIXEPOCH('NOW') WHERE column=some_val; END
C
C
S
AO
H
—persist-toA
Pdenoflaredenoflare d1 export-db your-database-name --file /path/to/downloaded.dbD1_ERROR: Network connection lost.ON UPDATE CURRENT_TIMESTAMPCREATE TRIGGER trigger_name AFTER UPDATE ON table BEGIN UPDATE another_table SET timestamp=UNIXEPOCH('NOW') WHERE column=some_val; END—persist-toconst stmt = env.DB.prepare(
"INSERT OR IGNORE INTO topic_queue (topic_id) VALUES (?)"
).bind(parentTopicId);
await stmt.run();