I'm running the command: ``` wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local

I'm running the command:

wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local --persist-to=./.wrangler

wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local --persist-to=./.wrangler

wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local --persist-to=./.wrangler

wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local --persist-to=./.wrangler

If I don't include a wrangler.toml file with the name/binding for 'DB', I receive the error:

ERROR: Can't find a DB with name/binding 'DB' in local config. Check info in wrangler.toml...

ERROR: Can't find a DB with name/binding 'DB' in local config. Check info in wrangler.toml...

ERROR: Can't find a DB with name/binding 'DB' in local config. Check info in wrangler.toml...

ERROR: Can't find a DB with name/binding 'DB' in local config. Check info in wrangler.toml...

Is it possible to not include a wrangler.toml file, and instead pass the d1 binding directly in the command? For example, we do this with:

wrangler pages dev ./public --d1=DB --local --persist-to=./.wrangler

wrangler pages dev ./public --d1=DB --local --persist-to=./.wrangler

wrangler pages dev ./public --d1=DB --local --persist-to=./.wrangler

wrangler pages dev ./public --d1=DB --local --persist-to=./.wrangler

bennycondonOP•3/15/23, 11:07 PM

I'm on wrangler version 2.12.0

bennycondonOP•3/15/23, 11:08 PM

I'll update to 2.12.3 and see if that fixes it

bennycondonOP•3/15/23, 11:12 PM

Still getting the same error after updating

Original message was deleted

Max (@rozenmd)•3/16/23, 7:14 AM

D1 doesn't have extensions or a way to inject your own logic with a Worker yet, so if native SQLite has it turned on by default, we do too

Original message was deleted

Max (@rozenmd)•3/16/23, 10:11 AM

There's a few: https://developers.cloudflare.com/workers/learning/integrations/databases/

MMozzy Yeah, will do tomorrow

Mozzy•3/16/23, 6:33 PM

https://github.com/cloudflare/workers-sdk/issues/2907

meyer•3/17/23, 7:54 PM

big fan of workers-qb

Nnikitasius Actually it's ~~betatest~~ alpha test. Could i use in for projects or you can wi...

Hello, I’m Allie!•3/17/23, 9:31 PM

AFAIK, the team won’t purposefully wipe your db(or at least warn you first), but you definitely should be ready to have to recover it at some point, since it is still in Alpha

Max (@rozenmd)•3/18/23, 8:21 AM

my totally revolutionary idea for KV stores under 100mb:
(for legal reasons this is a joke)

kian•3/18/23, 10:14 AM

Are you trying this in the Quick Edit preview?

kian•3/18/23, 10:19 AM

D1 won’t work there

MMax (@rozenmd)my totally revolutionary idea for KV stores under 100mb: (for legal reasons this...

Matt Silverlock•3/18/23, 10:54 AM

I literally have a test DB that is the same

SebastiaanYN•3/18/23, 3:14 PM

building a SQL database on a KV store
drake_dope

building a KV store on a SQL database

MMax (@rozenmd)my totally revolutionary idea for KV stores under 100mb: (for legal reasons this...

Advany•3/18/23, 6:47 PM

lol. Only the latency isnt as good as KV

AAdvany lol. Only the latency isnt as good as KV

Max (@rozenmd)•3/18/23, 7:05 PM

It Depends

MMax (@rozenmd)It Depends ™️

Advany•3/18/23, 7:07 PM

Let me make a test worker tomorrow...

Advany•3/18/23, 7:08 PM

I am afraid that on monday cloudflare will unplug @rozenmd from the cloudflare matrix... saying such things...

AAdvany lol. Only the latency isnt as good as KV

Matt Silverlock•3/18/23, 7:27 PM

Alpha is not representative of beta/GA performance. Trust me.

MMatt Silverlock Alpha is not representative of beta/GA performance. Trust me.

Advany•3/18/23, 7:33 PM

Would be something if you guys could offer like similar performance bit.io and planetscale. Like 50-100ms latency for simple queries.

micromashor•3/18/23, 8:03 PM

anyone have any info on what the D1 pricing will look like after the conclusion of the alpha?

I'm running the command: ``` wrangler d1 execute DB --file=./migrations/1673910000_init.sql --local

Similar Threads

Similar Threads

Similar Threads