I'm testing D1 and I followed the comments API example but I'm getting `no such table` error. `wrang

MMatt Silverlock I've never said it's built on top of DO. How they store data is entirely distinc...

R

rotator•8/8/23, 4:22 PM

I see, thanks for clarifying this.

I can infer that for overlapping use cases D1 is heavily encouraged, unless prices change before D1 is generally available.

Mmarko I'm testing D1 and I followed the comments API example but I'm getting `no such ...

M

markoOP•8/8/23, 4:32 PM

Just noticed that

wrangler dev --remote

wrangler dev --remote

works, so I'm guessing that this is related to local env.

M

markoOP•8/8/23, 4:36 PM

But now with --remote the worker doesn't connect via websocket, uhm.

GGuillaumeLakano It's not a stupid idea, and it's add a strong security layer, it's currently wha...

C

cyan•8/8/23, 6:19 PM

That’s great thanks!

Rrotator Any comment regarding this? https://discord.com/channels/595317990191398933/9920...

D

Dahoom•8/8/23, 6:26 PM

How did you get syntax highlighting on that example code?

DDahoom How did you get syntax highlighting on that example code?

C

cyan•8/8/23, 6:27 PM

https://gist.github.com/matthewzring/9f7bbfd102003963f9be7dbcf7d40e51#syntax-highlighting

Gist

A guide to Markdown on Discord.

A guide to Markdown on Discord. GitHub Gist: instantly share code, notes, and snippets.

C

cyan•8/8/23, 6:27 PM

its a discord syntax highlighting block

D

Dahoom•8/8/23, 6:28 PM

test test

test test

D

Dahoom•8/8/23, 6:28 PM

interesting, I didnt know highlightjs comes with discord

MMatt Silverlock I've never said it's built on top of DO. How they store data is entirely distinc...

A

Adi•8/8/23, 9:43 PM

Follow up question on this. I remember reading somewhere that DO will soon have an sqlite store connected as part of it's storage layer. Would this be using the same backend as D1?

S

sty•8/8/23, 10:06 PM

is kv still faster than d1 for query? or is d1 catching up/on par now?

Ggeelen Of course, you _can_ use the Cache API yourself (https://developers.cloudflare.c...

C

Chaika•8/8/23, 11:33 PM

unless I'm missing something or something changed recently, you couldn't use Cache API to match KV's new architecture, since KV 2.0 is something more close to Tiered Caching with generic + regional tier (which is Enterprise), and the Cache API doesn't interact with tiered caching at all.
KV would be faster over D1 if eventual consistency is fine/if you can have data cached for a while (and your data fits it), especially with its recent improvements.
(It would be cool if Cache API got Tiered caching one day

)

CChaika unless I'm missing something or something changed recently, you couldn't use Cac...

C

Codename_404•8/9/23, 2:11 AM

It would be great if they allowed caching with r2 custom domain. Then we could use fetch with custom domain on r2 with worker. Which would enable tired caching by default.

The r2 domain could be as part of a zone, just like worker route.

Would make things much easier.

G

Greg•8/9/23, 6:20 AM

Has anybody used the kysely adapter for d1 and run into this error?

Do not know how to serialize a BigInt

Do not know how to serialize a BigInt

more info here https://github.com/aidenwallis/kysely-d1/issues/21

G

Greg•8/9/23, 6:45 AM

Also unrelated, I'm created a table with this query:

CREATE TABLE Casts (
    id int8 NOT NULL PRIMARY KEY,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at timestamp,
    timestamp timestamp NOT NULL,
    fid int8 NOT NULL,
    hash bytea NOT NULL,
    parent_hash bytea,
    parent_fid int8,
    parent_url text,
    text text NOT NULL,
    embeds text NOT NULL DEFAULT '{}',
    mentions int8 NOT NULL DEFAULT '{}',
    mentions_positions int2 NOT NULL DEFAULT '{}'
);

CREATE TABLE Casts (
    id int8 NOT NULL PRIMARY KEY,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at timestamp,
    timestamp timestamp NOT NULL,
    fid int8 NOT NULL,
    hash bytea NOT NULL,
    parent_hash bytea,
    parent_fid int8,
    parent_url text,
    text text NOT NULL,
    embeds text NOT NULL DEFAULT '{}',
    mentions int8 NOT NULL DEFAULT '{}',
    mentions_positions int2 NOT NULL DEFAULT '{}'
);

CREATE TABLE Casts (
    id int8 NOT NULL PRIMARY KEY,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at timestamp,
    timestamp timestamp NOT NULL,
    fid int8 NOT NULL,
    hash bytea NOT NULL,
    parent_hash bytea,
    parent_fid int8,
    parent_url text,
    text text NOT NULL,
    embeds text NOT NULL DEFAULT '{}',
    mentions int8 NOT NULL DEFAULT '{}',
    mentions_positions int2 NOT NULL DEFAULT '{}'
);

CREATE TABLE Casts (
    id int8 NOT NULL PRIMARY KEY,
    created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    deleted_at timestamp,
    timestamp timestamp NOT NULL,
    fid int8 NOT NULL,
    hash bytea NOT NULL,
    parent_hash bytea,
    parent_fid int8,
    parent_url text,
    text text NOT NULL,
    embeds text NOT NULL DEFAULT '{}',
    mentions int8 NOT NULL DEFAULT '{}',
    mentions_positions int2 NOT NULL DEFAULT '{}'
);

I know it has some less common data types but the table seems to create just fine and I can add data from the Cloudflare dashboard.

Only problem is when I try to read it from a worker, I always gets

D1_ERROR: SqliteError: no such table: Casts

D1_ERROR: SqliteError: no such table: Casts

A

akazwz•8/9/23, 6:57 AM

look like than cloudflare pages with d1 binding has some problems, my account id is a275d70ec37a6046e6778c77d65dd38b, i am using remix with pages, the DB binding will be D1_BETADB and do not work.

Aakazwz look like than cloudflare pages with d1 binding has some problems, my account id...

F

forslunds•8/9/23, 10:20 AM

im using Remix/Pages/D1 without problems, atleast on Dev/Local. Were are you struggling? Get any errors?

H

Hasi•8/9/23, 10:41 AM

Hi

H

Hasi•8/9/23, 10:41 AM

I'm building a remix app

H

Hasi•8/9/23, 10:41 AM

And

H

Hasi•8/9/23, 10:41 AM

I've set up d1

H

Hasi•8/9/23, 10:41 AM

I'm using the local db for development

H

Hasi•8/9/23, 10:43 AM

but running a code like this

const result = req.context.db.prepare("SELECT * from accounts");
  const rows = await result.all();
  console.log(rows);

const result = req.context.db.prepare("SELECT * from accounts");
  const rows = await result.all();
  console.log(rows);

const result = req.context.db.prepare("SELECT * from accounts");
  const rows = await result.all();
  console.log(rows);

const result = req.context.db.prepare("SELECT * from accounts");
  const rows = await result.all();
  console.log(rows);

Results in:

Error: D1_ERROR
    at D1Database._send (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:148:13)
    at D1PreparedStatement.all (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:242:7)
    ... 7 lines matching cause stack trace ...
    at C:\Users\hasx\AppData\OneDrive\Dokumentumok\Rókales\foxadopt\functions\[[path]].js:3446:92 {
  [cause]: Error: Error: SqliteError: no such table: accounts

Error: D1_ERROR
    at D1Database._send (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:148:13)
    at D1PreparedStatement.all (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:242:7)
    ... 7 lines matching cause stack trace ...
    at C:\Users\hasx\AppData\OneDrive\Dokumentumok\Rókales\foxadopt\functions\[[path]].js:3446:92 {
  [cause]: Error: Error: SqliteError: no such table: accounts

Error: D1_ERROR
    at D1Database._send (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:148:13)
    at D1PreparedStatement.all (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:242:7)
    ... 7 lines matching cause stack trace ...
    at C:\Users\hasx\AppData\OneDrive\Dokumentumok\Rókales\foxadopt\functions\[[path]].js:3446:92 {
  [cause]: Error: Error: SqliteError: no such table: accounts

Error: D1_ERROR
    at D1Database._send (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:148:13)
    at D1PreparedStatement.all (C:\Users\hasx\OneDrive\Dokumentumok\Rókales\foxadopt\node_modules\@miniflare\d1\src\d1js.ts:242:7)
    ... 7 lines matching cause stack trace ...
    at C:\Users\hasx\AppData\OneDrive\Dokumentumok\Rókales\foxadopt\functions\[[path]].js:3446:92 {
  [cause]: Error: Error: SqliteError: no such table: accounts

When I have the tables set up

Aakazwz look like than cloudflare pages with d1 binding has some problems, my account id...

M

Matt Silverlock•8/9/23, 10:45 AM

Are you using wrangler 3.5.0? https://github.com/cloudflare/workers-sdk/releases/tag/wrangler%403.5.0

if not, please upgrade.

GitHub

Release wrangler@3.5.0 · cloudflare/workers-sdk

Minor Changes

#3703 e600f029 Thanks @jspspike! - Added --local option for r2 commands to interact with local persisted r2 objects

#3704 8e231afd Thanks @JacobMGEvans! - secret:bulk exit 1 on fa...

Fforslunds im using Remix/Pages/D1 without problems, atleast on Dev/Local. Were are you str...

A

akazwz•8/9/23, 11:24 AM

local dev is ok, something wrong in prod, the error is about the DB binding is undefined: "Cannot read properties of undefined (reading 'prepare')"

MMatt Silverlock Are you using wrangler 3.5.0? https://github.com/cloudflare/workers-sdk/releases...

A

akazwz•8/9/23, 11:25 AM

i am using 3.5.0, local dev is ok ,something wrong in pages

A

akazwz•8/9/23, 12:22 PM

maybe, i have another project deployed some days ago, it works

Ggeelen it's late here now but I'll jump on and investigate tomorrow, just curious if it...

M

Matt Silverlock•8/9/23, 12:27 PM

Let me repro on my Remix project this morning when I’m in

Aakazwz i am using 3.5.0, local dev is ok ,something wrong in pages

M

Matt Silverlock•8/9/23, 12:27 PM

Try

npx wrangler@3.4 <your commands>

npx wrangler@3.4 <your commands>

and report back

AArthie I'm also getting this error on 3.5.0: `this.client.prepare is not a function` do...

M

Matt Silverlock•8/9/23, 12:28 PM

In Pages or a Worker? Please share the code that triggers it.

AArthie Looking in my server.js **Worker** source code this is were it fails: ```ts /// ...

M

Matt Silverlock•8/9/23, 12:41 PM

What is client? A

D1Database

D1Database

?

AArthie My database name is still prefixed with `env.__D1_BETA__db` looks like this migh...

M

Matt Silverlock•8/9/23, 12:45 PM

Right - 3.5.0 moved the binding code to our side. If you haven’t done anything custom (like copying code out of wrangler) then it should have been seamless

AArthie yes D1 beta database (latest beta not the legacy alpha)

M

Matt Silverlock•8/9/23, 12:46 PM

Can you help me understand how you got here - e.g. you upgraded to wrangler 3.5.0 and ran

wrangler deploy

wrangler deploy

? Any other changes?

AArthie Ok was able to fix `this.client.prepare is not a function` on 3.5.0: 1) edit `w...

M

Matt Silverlock•8/9/23, 1:15 PM

How did you get that prefix? Did you copy (export) a Worker from the dash?

M

Matt Silverlock•8/9/23, 1:16 PM

For the record, I just upgraded to 3.5.0 to do this, and re-deployed my test D1 project at https://d1.silverlock.workers.dev/wnam/orders/select/

no issues.

AArthie Been using D1 since first public alpha, prefixing your d1 database binding with ...

M

Matt Silverlock•8/9/23, 1:23 PM

Ah, way back. We haven't required that in a very, very long time.

A

Adi•8/9/23, 1:24 PM

Quick question, are there any issues happening in d1 right now (legacy alpha db)? I just noticed a bunch of errors on my app -

this.client.prepare is not a function

this.client.prepare is not a function

this.client.prepare is not a function

this.client.prepare is not a function

I'm testing D1 and I followed the comments API example but I'm getting `no such table` error. `wrang

Similar Threads