Cloudflare Developers•3y ago

See the steps here: https://discord.com/channels/595317990191398933/992060581832032316/1128869875792

See the steps here: d1-database

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

Matt SilverlockOP•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

Llll-QWQ yes

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

but on the wrangler config

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

wrangler d1 execute test --file test.sql runs smoothly

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

I'm usuing Hono

Llll-QWQ wrangler d1 execute test --file test.sql runs smoothly

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

mhm

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

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

oh ye

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

are you using remix too?

HHasi are you using remix too?

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

I'm create my app with Hono, it's an API

Llll-QWQ I'm create my app with Hono, it's an API

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

oh sorry I missed that

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

d1-database
d1-database

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

and how are you using d1 trough?

Original message was deleted

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

someone had suggest to run wrangler dev --remote

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

It does work with --remote

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

looks like a bug

Llll-QWQ someone had suggest to run wrangler dev --remote

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

d1-database

Llll-QWQ It does work with --remote

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

sooo I should change my scripts to use mhm oki

HHasi sooo I should change my scripts to use mhm oki

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

try it out, it work on my side

Llll-QWQ try it out, it work on my side

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

okeee

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

Matt SilverlockOP•8/10/23, 10:23 AM

See this post d1-database

chientrm.com•8/10/23, 5:21 PM

I got my image turned into base64 string. Is it good practice to put them in D1 as a column?

Cchientrm.com I got my image turned into base64 string. Is it good practice to put them in D1 ...

Adi•8/10/23, 5:27 PM

Generally no. Images should go in some kind of object storage, like R2.
Once you've stored them externally you can keep a link or the path to the image in your database.

Cchientrm.com I got my image turned into base64 string. Is it good practice to put them in D1 ...

Matt SilverlockOP•8/10/23, 5:28 PM

I would store them in R2 and keep a reference in D1. Your max row size will limit you.

Unsmart•8/10/23, 5:28 PM

or KV

Unsmart•8/10/23, 5:28 PM

if under 25mb at least

UUnsmart if under 25mb at least

chientrm.com•8/10/23, 5:30 PM

it's sure under 25MB.

See the steps here: https://discord.com/channels/595317990191398933/992060581832032316/1128869875792

Similar Threads