I could have sworn I once saw a repo that was doing some replication across DOs
I could have sworn I once saw a repo that was doing some replication across DOs
batch is the solution to this, but can I send 10k sql inserts in one batch? Is there a limit to batch?
wrangler d1 insights command: https://developers.cloudflare.com/d1/observability/metrics-analytics/#query-insights
--timePeriod flag like in the last example on that page.--timePeriod=7d etc.-- 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;--timePeriod--timePeriod=7d