CC
ZCZCCCCCZZCZ
P
F
R
batch is the solution to this, but can I send 10k sql inserts in one batch? Is there a limit to batch?
HCR
C
. So I had to scrap that whole beautiful development I made, and now it's exclusive to our own company (where we are gladly paying for Workers Paid), since none of our clients want to pay every month for things that get called once per week or something similar.
DCD
F
SS
BS
D
몰몰DDDDCDC
CD
V
K
wrangler d1 insights command: https://developers.cloudflare.com/d1/observability/metrics-analytics/#query-insightsV
I--timePeriod flag like in the last example on that page.I--timePeriod=7d etc.V
Cbatchwrangler d1 insights--timePeriod--timePeriod=7d-- Create a simple table
DROP TABLE IF EXISTS test_table;
CREATE TABLE IF NOT EXISTS test_table (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
-- Drop any existing trigger
DROP TRIGGER IF EXISTS test_trigger;
-- Create a simple trigger
CREATE TRIGGER test_trigger
AFTER UPDATE ON test_table
FOR EACH ROW
BEGIN
UPDATE test_table
SET updated_at = CURRENT_TIMESTAMP
WHERE id = OLD.id;
END;