Via the Workers API, there should be no imposed limits, just the limits inherent to running SQLite i
Via the Workers API, there should be no imposed limits, just the limits inherent to running SQLite in a single thread
env.DB.exec(), I get an error. It can only parse multiple queries if each query is only a single line.db.exec() db.exec() npx wrangler deployD1.getById function
migrations folder do have some unapplied .sql files, but it fails to find themdatabase_id of remote database in [[d1_databases]] section. I thought, when we supply --remote parater, it picks the [[env.production.d1_databases]] section. I am struggling to understand wrangler.toml file structure.npx drizzle-kit push command. Anyone know what's going on?env.DB.exec()db.exec()db.exec()Error: Failed to publish your Function. Got error: binding MYAPP_DB of type d1 failed to generate. Please try again later or contact support.npx wrangler deployD1.getById[[d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
preview_database_id = "LOCAL-MY-DB" # Required for Pages local development
migrations_dir = "migrations"
[vars]
[[env.production.d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "8someguid63a"
migrations_dir = "migrations"migrations database_id[[d1_databases]][[env.production.d1_databases]]npx drizzle-kit push[✓] Pulling schema from database...
Error: 7500: not authorized: SQLITE_AUTH-- Migration number: 0000 2024-10-18T05:40:01.544Z
CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL);
INSERT INTO hub_migrations (name) values ('0000_create-todos');-- Migration number: 0000 2024-10-18T05:40:01.544Z
CREATE TABLE todos (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
);
INSERT INTO hub_migrations (name) values ('0000_create-todos');d1_databases = [
{ binding = "configs", database_name = "configs", database_id = "f1e42435-758a-4abf-842d-2303131a96a1" },
]