Cloudflare Developers•3y ago

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

lll-QWQOP•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-QWQOP•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-QWQOP•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-QWQOP•8/10/23, 8:26 AM

someone had suggest to run wrangler dev --remote

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

It does work with --remote

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

looks like a bug

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

lll-QWQOP•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-QWQOP•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-QWQOP•8/11/23, 6:51 AM

it's working for me

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

execute sql with --local flag

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

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

Uuser6251 If I understand it correctly from a technical point of view, Sqlite internally u...

Matt Silverlock•8/11/23, 12:25 PM

Not yet. Focusing on larger DBs and performance/stability first

Uuser6251 Thanks, that makes perfect sense 🙂 can you confirm that `rowid` queries incur m...

Matt Silverlock•8/11/23, 8:53 PM

Likely to be two: one for the index b-tree lookup, one for the table row read

Jure•8/11/23, 10:28 PM

Hi! I just started exploring D1 in a Nuxt 3 project. Could someone explain me what exactly is the best approach using a DB during local development?
I successfully deployed Nuxt 3 project on CF Pages and bind D1 database to it.
This database is used in production... what about during development?
Running

wrangler pages dev -- yarn dev

wrangler pages dev -- yarn dev

also bind the production database, right? Should I have different D1 database for local development? Just sqlite... or what would be the best approach?

JJure Hi! I just started exploring D1 in a Nuxt 3 project. Could someone explain me wh...

lll-QWQOP•8/12/23, 6:26 AM

maybe you should bind a local database on it?

lll-QWQOP•8/12/23, 6:26 AM

like with --local

lll-QWQOP•8/12/23, 6:27 AM

is your D1 working with pages without any tweak?

lll-QWQOP•8/12/23, 6:28 AM

My D1 don't seems to work only with "wrangler dev"

lll-QWQOP•8/12/23, 6:29 AM

--remote can access the remote db, --local can create one locally for testing

Stronk•8/12/23, 10:45 PM

how would I write a jest test that sets values in d1 manualy before running fetch tests?

SStronk how would I write a jest test that sets values in d1 manualy before running fetc...

Matt Silverlock•8/13/23, 12:41 AM

https://developers.cloudflare.com/d1/learning/local-development/#test-programmatically

Local development · Cloudflare D1 docs

D1 has fully-featured support for local development, running the same version of D1 as Cloudflare runs globally. Local development uses Wrangler, the …

Stronk•8/13/23, 1:25 AM

Ah so I can use the execsync function to just run the commands through wrangler cli

Llll-QWQ My D1 don't seems to work only with "wrangler dev"

Jure•8/13/23, 10:04 AM

I found this tutorial very helpful:
https://sat0shi.dev/posts/drizzle-intro/
Especially to understand how to use D1 for local development and how migrations work.

Type-Safely Access Cloudflare D1 with Drizzle ORM

Looking for a ORM to access Cloudflare D1 in a type-safe manner? Look no further than Drizzle ORM!

CCole Xemi I'm having an issue with wrangler version 3.5.0. With that version my worker can...

James•8/13/23, 9:20 PM

I'd recommend filing an issue at https://github.com/cloudflare/workers-sdk with a reproduction

CCole Xemi I'm having an issue with wrangler version 3.5.0. With that version my worker can...

Adi•8/14/23, 1:17 AM

What is the binding name of the variable you're using? A few of us had problems with 3.5.0 when it came out.
Maybe check the yet to be released changelog and see if it's suggestions solve your problem - https://github.com/cloudflare/cloudflare-docs/pull/10298/files

Tldr, if your binding name used the prefix -

__D1_BETA__

__D1_BETA__

it won't work anymore

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

Similar Threads

Similar Threads

Similar Threads