Hello, I've seen that dumping a DB to an sqlite file was supported during the alpha, but not now dur

Hello, I've seen that dumping a DB to an sqlite file was supported during the alpha, but not now during the beta. Are there plans to add this (or something similar) back in later?

ZZuma Hello, I've seen that dumping a DB to an sqlite file was supported during the al...

yeehow•1/10/24, 10:45 PM

This what you are looking for? https://developers.cloudflare.com/d1/learning/backups/#downloading-a-backup-locally

Backups (Legacy) · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

GGagan Suie im using miniflare via `const env = getMiniflareBindings()`

Gagan Suie•1/10/24, 11:07 PM

found this, but its not working for ESM
https://www.npmjs.com/package/@miniflare/d1

npm

@miniflare/d1

Workers D1 module for Miniflare: a fun, full-featured, fully-local simulator for Cloudflare Workers. Latest version: 2.14.1, last published: 5 months ago. Start using @miniflare/d1 in your project by running

npm i @miniflare/d1

npm i @miniflare/d1

. There are 3 other projects in the npm registry using @miniflare/d1.

Original message was deleted

yeehow•1/10/24, 11:23 PM

Trying this example right now and running into weird issues when changing the

database_id

database_id

in the

wrangler.toml

wrangler.toml

file.

Only able to get it to work when

binding

binding

and

database_id

database_id

are the same...

Confused why the ID would effect anything. Shouldn't it grab the database based on the binding?

Original message was deleted

yeehow•1/10/24, 11:26 PM

Yeah that works for me, but would like to use the actual DB id for migrations and stuff

kian•1/10/24, 11:29 PM

are you using wrangler dev or miniflare

Kkian are you using wrangler dev or miniflare

yeehow•1/10/24, 11:33 PM

Miniflare. Basically using this repo except changed the

database_id

database_id

in the wrangler file

https://github.com/jculvey/svelte-cf-bindings-poc

GitHub

GitHub - jculvey/svelte-cf-bindings-poc

Contribute to jculvey/svelte-cf-bindings-poc development by creating an account on GitHub.

kian•1/10/24, 11:34 PM

d1Databases in the Miniflare constructor needs to be changed to a Record<string, string> where its binding: id

kian•1/10/24, 11:34 PM

otherwise it’ll assume the id is the binding name

Kkian d1Databases in the Miniflare constructor needs to be changed to a Record<string,...

yeehow•1/10/24, 11:36 PM

That worked! thank you

Kkian otherwise it’ll assume the id is the binding name

yeehow•1/10/24, 11:38 PM

Is this documented anywhere? (if not i can make a PR)

All I see is https://miniflare.dev/storage/d1
Looks like the example there has the same problem

💾 D1 · Miniflare

Fun, full-featured, fully-local simulator for Cloudflare Workers

kian•1/10/24, 11:39 PM

probably just at https://github.com/cloudflare/workers-sdk/blob/4a925629238c9244d0fcf058301f46fc8fb64da2/packages/miniflare/README.md?plain=1#L510

Kkian probably just at <https://github.com/cloudflare/workers-sdk/blob/4a925629238c924...

yeehow•1/10/24, 11:41 PM

Ahh missed that, thanks

kian•1/11/24, 1:11 AM

The message will start with D1_ and that’s about it

kian•1/11/24, 1:12 AM

You can see them in https://github.com/cloudflare/workerd/blob/main/src/cloudflare/internal/d1-api.ts

Leo_C•1/11/24, 2:20 AM

Hello, why can't I load the table page?
Is the data stored in d1 too large? There are no such issues in another smaller database.

Original message was deleted

Tony Leung•1/11/24, 8:40 AM

Hope they will create a native api to dump/load the D1 db to/from local machine or R2 soon. Sometimes we need databases dumped from staging environment for some database debug since D1 query debugging (especially when migrating database) is very limited. D1 DB is nice to work with, but dealing with altering table and migration is not a pleasant experience. Thankfully they released time traveling feature so I can go back to a point of time if my migration's gone wrong

Original message was deleted

Tony Leung•1/11/24, 8:51 AM

Original message was deleted

Leo_C•1/11/24, 11:24 AM

my database id is 0c148108-729d-4796-be8b-25a27dead6b8 MeowHeartCloudflare

Yyeehow This what you are looking for? https://developers.cloudflare.com/d1/learning/bac...

ZumaOP•1/11/24, 11:40 AM

This is "legacy" unfortunately, meaning it only works on alpha databases (were in the beta now). Thanks for your help though.

Original message was deleted

ZumaOP•1/11/24, 11:40 AM

Brilliant, thank you

yesmeno•1/11/24, 3:46 PM

I'm trying out D1 and like it but am wondering if I should just use it for all my data needs or if KV still has an advantage sometimes.

Yyesmeno I'm trying out D1 and like it but am wondering if I should just use it for all m...

Unsmart•1/11/24, 3:51 PM

KV is not in beta so if you are doing something production KV should be used over D1.

D1 also does not replicate data yet, KV does.
KV can store larger values.
KV can handle way more load.

Max (@rozenmd)•1/11/24, 3:52 PM

KV has replication lag, which might trip you up

UUnsmart KV is not in beta so if you are doing something production KV should be used ove...

yesmeno•1/11/24, 3:52 PM

Thanks! So I'm building a sort of keynote / pitch deck viewer. My idea was to use D1 to store which users have access to which pitch decks. And then I would store the actual pitch deck data (markdown) in a KV. Does that sound reasonable?

yesmeno•1/11/24, 3:53 PM

Or would it actually be easier to simply store everything in KV?

yesmeno•1/11/24, 3:54 PM

Like...

decks-{userId}

decks-{userId}

as key, and the value would just be a list of deck ids?

Unsmart•1/11/24, 3:54 PM

Just depends what you want to do

If you want my personal preference I would store authorization data in durable objects and store the markdown in R2.

Unsmart•1/11/24, 3:55 PM

Theres a million way to solve the same problem so its mostly personal preference in the end

yesmeno•1/11/24, 4:00 PM

R2 even if the markdown ist going to be edited a lot, by multiple users?

burguês•1/11/24, 4:09 PM

Hello,

Is there any chance someone here help with the D1 port to Prisma ORM? There is a issue with a lot of interactions and a start code with this integration. Take a look https://github.com/prisma/prisma/issues/13310#issuecomment-1880028618

Thanks

GitHub

Support for Cloudflare's new SQLite database D1 · Issue #13310 · pr...

Cloudflare have just announced their first relational DB D1 which is based on SQLite. https://blog.cloudflare.com/introducing-d1/ Would be awesome if Prisma could support it one day..

Yyesmeno R2 even if the markdown ist going to be edited a lot, by multiple users?

Unsmart•1/11/24, 4:17 PM

Yes

UUnsmart Yes

yesmeno•1/11/24, 4:19 PM

The reason being that the size is going to exceed my KV storage limits otherwise, right?

Unsmart•1/11/24, 4:20 PM

No I would use R2 because its cheaper. KV is way too expensive of a service imo

ZZuma This is "legacy" unfortunately, meaning it only works on alpha databases (were i...

yeehow•1/11/24, 5:59 PM

Yeah my bad. Saw that in the docs a few minutes after I sent it...

Yyeehow Yeah my bad. Saw that in the docs a few minutes after I sent it...

ZumaOP•1/11/24, 6:49 PM

No problem, still thanks for looking

Gagan Suie•1/11/24, 10:21 PM

why am i getting this error??

"Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'"

"Error: D1_TYPE_ERROR: Type 'boolean' not supported for value 'true'"

i thought booleans get converted to D1 integers 1 or 0?

kian•1/11/24, 10:28 PM

Documentation seems to imply it should, but it isn't.

kian•1/12/24, 1:36 AM

results.error

results.error

isn't really a thing

kian•1/12/24, 1:36 AM

you need to

try/catch

try/catch

the

.all()

.all()

call

kian•1/12/24, 1:53 AM

What is the issue you're having with the code?

kian•1/12/24, 1:53 AM

Which part in particular isn't working

kian•1/12/24, 2:00 AM

What part of your retry logic doesn't work though, which line do you get to before it fails?

Hello, I've seen that dumping a DB to an sqlite file was supported during the alpha, but not now dur

Similar Threads