We're going to let folks write Workers that act as custom sqlite extensions eventually
We're going to let folks write Workers that act as custom sqlite extensions eventually
wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local, and a slqite3 file with path .wrangler/state/d1/TEST_DB.sqlite3 was created. When I try to quey with d1 I got error:
resellers (id string PRIMARY KEY,email string NOT NULL,name string NOT NULL,created datetimeagencies (id string PRIMARY KEY,reseller_id string NOT NULL,name string NOT NULL,location string,created datetimereseller_id) REFERENCES resellers(id),
wrangler pages dev ./public --kv=TEST_KV --d1=TEST_DB --persist --local.wrangler/state/d1/TEST_DB.sqlite3 handle request
Error: D1_ERROR
at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:148:13)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
... 7 lines matching cause stack trace ...
at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15) {
[cause]: Error: Error: SqliteError: file is not a database
at D1Database._send (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:149:16)
at processTicksAndRejections (node:internal/process/task_queues:95:5)
at D1PreparedStatement.raw (/home/jokcy/workspace/remix-cloudflare-test/node_modules/@miniflare/d1/src/d1js.ts:248:7)
at callRouteLoaderRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4292:16)
at callLoaderOrAction (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3531:16)
at async Promise.all (index 0)
at loadRouteData (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3303:19)
at queryImpl (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3184:20)
at Object.query (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:3136:18)
at handleDocumentRequestRR (/home/jokcy/workspace/remix-cloudflare-test/functions/[[path]].js:4468:15)resellersresellersidididemailnamenamecreatedcreatedagenciesreseller_idreseller_idlocation