Cloudflare Developers•3y ago

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...

HasiOP•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]
...

HasiOP•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-...

HasiOP•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

HasiOP•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

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

mhm

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

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

oh ye

HasiOP•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

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

oh sorry I missed that

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

d1-database
d1-database

HasiOP•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

HasiOP•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

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

okeee

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

Matt Silverlock•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 Silverlock•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.

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

but KV doesn't guaranteed available, does it?

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

It should be fine assuming you arent reading the key before its uploaded. KV should also be faster especially since it is replicated... but more expensive.

UUnsmart It should be fine assuming you arent reading the key before its uploaded. KV sho...

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

but the 60s thingy.

still same error

Similar Threads

Similar Threads

Similar Threads