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

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?

UnsmartOP•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.

UnsmartOP•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?

UnsmartOP•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?

UnsmartOP•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...

Zuma•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?