Can run a query through wrangler with `wrangler d1 execute <database name> --command <SQL here>`

Can run a query through wrangler with

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

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

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

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

thats only if you read the key before its uploaded

UUnsmart thats only if you read the key before its uploaded

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

My flow is upload file -> worker forward formData to my external service -> return base64 encoded string -> worker create D1 row -> worker set KV value to encoded string.

MMatt Silverlock Something the Pages team is working on improving. In the meantime (and this is n...

Hasi•8/10/23, 7:16 PM

not working : /

HHasi not working : /

lll-QWQ•8/11/23, 6:51 AM

it's working for me

lll-QWQ•8/11/23, 6:52 AM

execute sql with --local flag

lll-QWQ•8/11/23, 6:52 AM

I believe it will execute sql locally and create a database, that's enough for debugging

Can run a query through wrangler with `wrangler d1 execute <database name> --command <SQL here>`

Similar Threads

Similar Threads

Similar Threads