Cloudflare Developers•3y ago

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

CCole Xemi My binding variable was called `DB`

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

Right, ok then I have no clue haha.
Btw is the issue you made

? You likely want to give a bit more detail. A minimal reproduction repository is key.

Matt Silverlock•8/14/23, 2:59 PM

FYI: you can now bind D1 databases to Workers and Pages projects directly via the dashboard. More details here: https://developers.cloudflare.com/d1/changelog/#bind-d1-from-the-cloudflare-dashboard

Changelog · Cloudflare D1 docs

You can now bind a D1 database to your Workers directly in the Cloudflare dashboard . To bind D1 from the Cloudflare dashboard, select your Worker …

chientrm.com•8/14/23, 6:18 PM

do we have transaction?

Behunin•8/14/23, 9:37 PM

I am getting

Error: D1_ERROR: RangeError: Too many parameter values were provided

Error: D1_ERROR: RangeError: Too many parameter values were provided

with a query that had 24 values

Behunin•8/14/23, 9:37 PM

The docs say the limit is 100

Behunin•8/14/23, 9:38 PM

Did I miss something?

kika•8/14/23, 11:56 PM

I'm trying to add a column to the database with

alter table

alter table

and it fails with

Error code 23: Authorization denied

Error code 23: Authorization denied

. Reading the table works. Tried both through wranger and through the web console. I'm the only admin in the org, there's noone more powerful. Any ideas?