Quick question, are there any issues happening in d1 right now (legacy alpha db)? I just noticed a b

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

HHasi but running a code like this ```js const result = req.context.db.prepare("SELEC...

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

umm, sorry, but can someone take a look at this?

AAdi Quick question, are there any issues happening in d1 right now (legacy alpha db)...

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

Scroll immediately up.

AdiOP•8/9/23, 1:25 PM

Oh whoops, sorry my eyes glanced over that...

HHasi umm, *sorry*, but can someone take a look at this?

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

You're definitely hitting the wrong DB. Can you please share what

wrangler

wrangler

commands you're invoking? Here's a working Remix demo app: https://github.com/elithrar/remix-plus-d1

GitHub

GitHub - elithrar/remix-plus-d1: An example app for combining Cloud...

An example app for combining Cloudflare's D1 database with Remix loader functions. - GitHub - elithrar/remix-plus-d1: An example app for combining Cloudflare's D1 database with Remi...

HHasi umm, *sorry*, but can someone take a look at this?

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

Also: https://developers.cloudflare.com/d1/examples/d1-and-remix/

Query D1 from Remix · Cloudflare D1 docs

Remix is a full-stack web framework that operates on both client and server. You can query your D1 database(s) easily from Remix with Remix’s data …

MMatt Silverlock You're definitely hitting the wrong DB. Can you please share what `wrangler` com...

Hasi•8/9/23, 1:26 PM

Basically wrangler d1 execute adoptdb

Hasi•8/9/23, 1:26 PM

I have only 1 db

HHasi Basically wrangler d1 execute adoptdb

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

Is that it - exactly? No

--local

--local

flag? Please be precise

MMatt Silverlock Is that it - exactly? No `--local` flag? Please be precise 🙂

Hasi•8/9/23, 1:33 PM

sorry I used local of course

Hasi•8/9/23, 1:33 PM

I both uploaded to local and prod

Hasi•8/9/23, 1:33 PM

the shema

Hasi•8/9/23, 1:33 PM

and checked that they present there

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

AdiOP•8/9/23, 1:35 PM

Can confirm this worked for me too

As Arthie mentioned, this was necessary when D1 first came out, I too had the binding setup ever since then, never updated it. Issue for ref - https://github.com/cloudflare/workers-sdk/issues/2402

HHasi *sorry* I used local of course

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

See the steps here: d1-database

AAdi Can confirm this worked for me too 👍 As Arthie mentioned, this was necessary w...

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

https://github.com/cloudflare/cloudflare-docs/pull/10298

changelog entry here

GitHub

[D1] Update changelog.md by elithrar · Pull Request #10298 · cloudf...

This PR adds a new changelog entry that:

highlights the new dash binding support
recommends users upgrade to wrangler 3.5.0
provides migration advice for legacy alpha users with D1_BETA prefixes

MMatt Silverlock See the steps here: https://discord.com/channels/595317990191398933/992060581832...

Hasi•8/9/23, 2:15 PM

mhm did it

Hasi•8/9/23, 2:15 PM

still same error

MMatt Silverlock Try `npx wrangler@3.4 <your commands>` and report back

akazwz•8/9/23, 2:48 PM

3.4 works

MMatt Silverlock For the record, I _just_ upgraded to 3.5.0 to do this, and re-deployed my test D...

akazwz•8/9/23, 2:55 PM

i can get this prefix too, in toml and dashboard, i set DB binding, but when i log the env, there is a prefix __D1BETA , i use wrangler@3.4 solved problem

akazwz•8/9/23, 3:03 PM

https://github.com/cloudflare/workers-sdk/commit/c302bec639c0eec10d07d6b950c0a2d3e16eab1e#diff-80a0404f59f781e58a6e6892e5457ca6bd1c7b7e5687155159bde57f6cc65452

GitHub

Removing D1 Shim (#3595) · cloudflare/workers-sdk@c302bec

Tried to remove all traces of the D1 shim
Fixing lint errors
Fixing deploy & middleware tests
Changing tests to expect absence of D1 shim, not presence
Adding changese...

chientrm.com•8/10/23, 1:41 AM

can you make wrangler D1 client interactive like other terminal sql client?

chientrm.com•8/10/23, 1:41 AM

I don't want to go to dash web everytime to run query.

Cyb3r-Jak3•8/10/23, 1:50 AM

Can run a query through wrangler with

wrangler d1 execute <database name> --command <SQL here>

wrangler d1 execute <database name> --command <SQL here>

CCyb3r-Jak3 Can run a query through wrangler with `wrangler d1 execute <database name> --com...

chientrm.com•8/10/23, 1:51 AM

I know but an interactive-like would be better.

chientrm.com•8/10/23, 1:52 AM

although it doesn't have to be a stateful connection.

chientrm.com•8/10/23, 1:52 AM

wrangler connect <database name>

wrangler connect <database name>

Cchientrm.com I know but an interactive-like would be better.

James•8/10/23, 1:56 AM

There’s an awesome community project from @Isaac McFadyen | YYZ01 which might interest you: https://github.com/isaac-mcfadyen/d1-console

GitHub

GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudf...

A full query console for Cloudflare's D1 database product. - GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudflare's D1 database product.

JJames There’s an awesome community project from @Isaac McFadyen | YYZ01 which might in...

chientrm.com•8/10/23, 1:56 AM

oh, I realize that a Vscode extension for cloudflare would be best

JJames There’s an awesome community project from @Isaac McFadyen | YYZ01 which might in...

chientrm.com•8/10/23, 2:28 AM

it can't find the database with name.

Cchientrm.com it can't find the database with name.

Hello, I’m Allie!•8/10/23, 7:13 AM

That’s what

d1-console -d <Name>

d1-console -d <Name>

is for

HHello, I’m Allie!That’s what `d1-console -d <Name>` is for

chientrm.com•8/10/23, 7:13 AM

Yep it can't find the db

HHasi still same error

lll-QWQ•8/10/23, 8:15 AM

same here
Trace: Error: D1_ERROR: SqliteError: no such table: test
at D1Database._sendOrThrow (cloudflare-internal:d1-api:66:19)
at async D1PreparedStatement.all (cloudflare-internal:d1-api:175:29)
at async linksqlget (index.js:16078:15)
at async index.js:8061:50
at async jsonError (index.js:16094:12) {
stack: Error: D1_ERROR: SqliteError: no such table: test
…061:50
at async jsonError (index.js:16094:12),
message: D1_ERROR: SqliteError: no such table: test,
cause: Error: SqliteError: no such table: test
at D1Database._sendOrThrow (cloudflare-internal:d1-api:…
}

Llll-QWQ same here Trace: Error: D1_ERROR: SqliteError: no such table: test at D1Data...

Hasi•8/10/23, 8:16 AM

Yup

lll-QWQ•8/10/23, 8:16 AM

my wrangler.toml looks something like this
name = ""
compatibility_date = "2023-01-01"
main = "src/index.js"

[[d1_databases]]
binding = "DB"
database_name = "test"
database_id = ""

[vars]
...

Hasi•8/10/23, 8:16 AM

I think it going to a different db

Llll-QWQ my wrangler.toml looks something like this name = "" compatibility_date = "2023-...

Hasi•8/10/23, 8:16 AM

Do you have d1 set up?

HHasi Do you have d1 set up?

lll-QWQ•8/10/23, 8:17 AM

yes

lll-QWQ•8/10/23, 8:18 AM