Hi! I just started exploring D1 in a Nuxt 3 project. Could someone explain me what exactly is the be

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

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-QWQ•8/12/23, 6:26 AM

maybe you should bind a local database on it?

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

like with --local

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

is your D1 working with pages without any tweak?

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

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

lll-QWQ•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"

JureOP•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 37563756? 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 providedError: 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 tablealter table and it fails with Error code 23: Authorization deniedError 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?

BBehunin I am getting `Error: D1_ERROR: RangeError: Too many parameter values were provid...

Matt Silverlock•8/15/23, 12:34 AM

Are you using the new backend? Refer to https://developers.cloudflare.com/d1/changelog/#new-default-storage-subsystem for how to check

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 …

Kkika I'm trying to add a column to the database with `alter table` and it fails with ...

Matt Silverlock•8/15/23, 12:34 AM

What specific ALTER TABLEALTER TABLE statement are you trying to run? (Post the query)

Kkika I'm trying to add a column to the database with `alter table` and it fails with ...

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

For clarity, all of this works per our tests: https://github.com/cloudflare/workerd/blob/26f0498e303eead759ab4ca9f8767841618eace7/src/workerd/api/sql-test.js#L630-L660

GitHub

workerd/src/workerd/api/sql-test.js at 26f0498e303eead759ab4ca9f876...

The JavaScript / Wasm runtime that powers Cloudflare Workers - cloudflare/workerd

MMatt Silverlock What specific `ALTER TABLE` statement are you trying to run? (Post the query)

kika•8/15/23, 12:42 AM

alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));alter table emailsignups add column source TEXT CHECK(source IN ('A','B'));

kika•8/15/23, 12:42 AM

it works with

--local

--local

kika•8/15/23, 12:43 AM

assuming the local sqlite engine is the same as "remote"

kika•8/15/23, 12:43 AM

very recent, lemme check

kika•8/15/23, 12:44 AM

wrangler usually tells me that it's up for update

kika•8/15/23, 12:44 AM

3.5.0

kika•8/15/23, 12:45 AM

whooops

kika•8/15/23, 12:45 AM

so quazi-enums are verboten?

kika•8/15/23, 12:46 AM

appreciate it

Ggeelen i happened to be exactly inside that test right now so easy for me to dig

Matt Silverlock•8/15/23, 12:50 AM

Probably need to authorize that + allow the associated PRAGMA ignore_check_constraintsPRAGMA ignore_check_constraints

? https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints
- https://www.sqlite.org/lang_createtable.html#check_constraints

Hi! I just started exploring D1 in a Nuxt 3 project. Could someone explain me what exactly is the be

Similar Threads

Similar Threads

Similar Threads