Cloudflare Developers•3y ago

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

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)OP•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?

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

yea that's what I saw

DDeleted User considering this, what would prevent people from doing this once latency is simi...

Max (@rozenmd)OP•3/18/23, 8:31 PM

scale for one, KV runs huge workloads in prod

micromashor•3/18/23, 11:21 PM

is there a way to add REGEXP check constraints on a column? currently I get the following:

CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+'))

ERROR 9009: SQL prepare error: no such function: REGEXP in CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+')) at offset 54

CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+'))

ERROR 9009: SQL prepare error: no such function: REGEXP in CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+')) at offset 54

meow•3/19/23, 3:51 AM

Is there a way to use Prisma with D1?

Original message was deleted

micromashor•3/19/23, 4:06 AM

yeah, I saw that in the documentation, but it sure would be nice to have that

Mmeow Is there a way to use Prisma with D1?

meyer•3/19/23, 5:07 AM

i used it to generate a schema and then dumped the schema using the sqlite CLI

meyer•3/19/23, 5:08 AM

but it made some sense for me because i was already experimenting with prisma and postgres

meyer•3/19/23, 5:08 AM

you can aim it at the local sqlite DB in the .wrangler folder

Original message was deleted

Max (@rozenmd)OP•3/19/23, 8:46 AM

MMax (@rozenmd)?

Advany•3/19/23, 9:03 AM

Nevermind... I just read "D1 will create read-only clones of your data and distribute across Cloudflare global network — close to where your users are — and constantly keep them up-to-date with changes."

zegevlier•3/19/23, 10:01 AM

There hasn't been a focus on performance for D1 yet, as it is still in alpha. Benchmarks made right now likely wont reflect the speeds when it goes GA

zegevlier•3/19/23, 10:16 AM

Yup

Max (@rozenmd)OP•3/19/23, 1:40 PM

yeah we were more focused on just getting it out into people's hands than performance for the alpha

justaname•3/19/23, 4:35 PM

d1 has a limit in storage right now

justaname•3/19/23, 4:41 PM

i imagine its going to be price competitve but time will tell. If you are just starting a project i wouldn't really worry about which Database you chose as you can just manually copy over the tables and stuff when you are ready to release to the public with the database you want

DDeleted User starting off a project and any of the cloudflare storage product options can eas...

Advany•3/19/23, 4:52 PM

seems like they are always cheaper than the competition. Like Bit.io is $1 per 100M operations... so cloudflare might be like like 25% of that if I compare KV and other products how they are priced?

DDeleted User Has there been any small pricing talk with D1? any clues as to if writes would b...

micromashor•3/19/23, 7:58 PM

nothing official from what I've seen, but my guess based on the models of KV and D1, is that D1 writes will be much cheaper than KV writes. I think of KV as behaving like a config file - frequent, simple reads, occasional writes, whereas D1 is a database, meant for complex queries, frequently, all the time

micromashor•3/19/23, 8:00 PM

my guess is that the pricing model will be similar to R2, with operations being split up into classes (class A might be CREATE, DROP, ALTER etc, class B might be INSERT, DELETE, UPDATE, class C might be SELECT) depending on complexity and cost, which would depend on the internals of sqlite

micromashor•3/19/23, 8:02 PM

depends on the scale of your project

micromashor•3/19/23, 8:04 PM

I'm creating an experimental branch of my website on D1 to see how well it works, and when D1 goes GA and official pricing info comes out, I'll probably switch over to D1 entirely, but on the off-chance that D1 is prohibitively expensive, I'll just cut the experimental branch and keep us on our current solution

micromashor•3/19/23, 8:05 PM

either way, remember D1 is still in alpha and shouldn't be used in production yet

micromashor•3/19/23, 8:06 PM

yeah

micromashor•3/19/23, 8:07 PM

I've encountered some odd/buggy behavior and HTTP 500 errors coming back from the API

CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+')) ERROR 9009: SQL prepare error: no such function: REGEXP in CREATE TABLE my_table (my_column TEXT CHECK(my_column REGEXP '\w+')) at offset 54

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

Similar Threads

Similar Threads

Similar Threads