these kind of statements don't help, I myself like what Cloudflare is doing in general and of course

these kind of statements don't help, I myself like what Cloudflare is doing in general and of course would like to have features now, but making a case for why they didn't even show a sneak-peak when they have the resources needed to do whatever it takes to at least keep the hype going is not good.

shixzieOP•9/27/24, 7:59 PM

Personally, I was waiting for the multi-tenant feature or at least a sneak as to how it would be implemented to plan ahead for some future projects. But I can only rely on what's available today, leaving no other choice tbh.

Somepotato•9/27/24, 8:22 PM

This was last asked awhile ago but is there any news about integrating the spatialite extension within D1?

Oo7 Both teams are obviously already working together, D1 is built on SQLite for DO....

boop•9/27/24, 8:32 PM

Yeah I know, that was more a frustrated dig at the D1 team. The “hey it’s coming soon” is getting boring now and just makes it look like an unfinished product

Sshixzie these kind of statements don't help, I myself like what Cloudflare is doing in g...

o7•9/27/24, 8:32 PM

Original message was deleted

o7•9/27/24, 8:40 PM

The 10GB limit is more of an architectural limit (they probably could go a little higher but 10GB is a safe limit per DB)

Llambrospetrou Just to clarify on this, location hints in D1 work in similar way to location hi...

stibbs•9/28/24, 2:45 AM

Jurisdictions is what I need, but more options -- specifically Australia

�

𝓈𝒽𝓎•9/28/24, 8:23 AM

D1 without multi tenancy features and sharding with 10GB limit, regardless what people say about how high it is and whatever, what happens when I get there? do I just shut down the company once I reach 10GB limit?

marko.333•9/28/24, 4:13 PM

Adding transparent sharding (and read replication) across D1 instances would be a great add. But doesn't the new support for D1 backed DO's address (at least some) of the multi-tenancy issues? What is the usecase that is still lacking?

Mmarko.333 Adding transparent sharding (and read replication) across D1 instances would be ...

Hello, I’m Allie!•9/28/24, 4:33 PM

The main thing I’ve seen right now is about the reduced size limits during the beta

HHello, I’m Allie!The main thing I’ve seen right now is about the reduced size limits during the b...

marko.333•9/28/24, 5:05 PM

OK, that seems like a temporary blocker? Some of the recent fired-up threads over dynamic binding in the context of multi-tenancy sound like more than the 1GB limit?

naourass•9/28/24, 6:31 PM

Hi all, is it currently possible to load the Spellfix1 extension, or to register Application-Defined functions in D1?

�𝓈𝒽𝓎 D1 without multi tenancy features and sharding with 10GB limit, regardless what ...

Advany•9/28/24, 7:57 PM

Migrate?

AAdvany Migrate?

�

𝓈𝒽𝓎•9/28/24, 7:58 PM

out of closed-source db?

�𝓈𝒽𝓎 out of closed-source db?

Cyb3r-Jak3•9/28/24, 8:07 PM

D1 is just SQLite and you can export it

dan—1106•9/28/24, 9:01 PM

Hi, I'm running into a problem using

npx prisma migrate diff

npx prisma migrate diff

with my D1 database locally (because I have a qa and prod DB instance and the command can't deal with multiple DBs). Looks like someone else ran into the same problem a few months ago: https://www.answeroverflow.com/m/1266887370653962422

I was wondering if there were any suggested approaches here?

prisma migrations fail if there are multiple databases - Cloudflare...

running migrations throws an error if there are multiple databases.

```
❯ npx prisma migrate diff --from-local-d1 --to-schema-datamodel ./prisma/schema.prisma --script --output migrations/0002_rename_referrer.sql

Error: Multiple Cloudflare D1 databases found in .wrangler/state/v3/d1/miniflare-D1DatabaseObject. Please manually specify the loca...

Original message was deleted

�

𝓈𝒽𝓎•9/29/24, 6:11 AM

The product is just isn’t complete, tired of people bringing workarounds instead of just addressing the real issues while they’re very obvious issues

�

𝓈𝒽𝓎•9/29/24, 6:13 AM

The workaround to your issue is to migrate

akashra•9/29/24, 6:13 AM

No IT product is ever complete

�

𝓈𝒽𝓎•9/29/24, 6:13 AM

Is this a workaround anymore?

�

𝓈𝒽𝓎•9/29/24, 6:14 AM

It’s just a nice way to say the product was not complete and you shouldn’t have used it to begin with

Aakashra No IT product is ever complete 😅

�

𝓈𝒽𝓎•9/29/24, 6:15 AM

I honestly never used a tool that clearly has a dead end

�

𝓈𝒽𝓎•9/29/24, 6:15 AM

Just a giant wall waiting for you when you reach 10GB

akashra•9/29/24, 6:15 AM

I'm trying to see what the issue is from reading to briefly, but what I can see are features WAY outside the scope is expect of a lightweight database.

�

𝓈𝒽𝓎•9/29/24, 6:15 AM

And it call the tool GA is crazy

akashra•9/29/24, 6:18 AM

If you're using this for databases larger than 10gb, you very clearly have picked the wrong tool, and done so knowingly up-front.

�

𝓈𝒽𝓎•9/29/24, 6:18 AM

Okay I agree with you how should I use the tool

�

𝓈𝒽𝓎•9/29/24, 6:22 AM

The tooling to use the tool the way it’s intended it’s not there

Ashish Rawat•9/29/24, 11:13 AM

Now we have to wait for developer day which wil be in 4-5 months for any new updates.

Ashish Rawat•9/29/24, 11:14 AM

Cloudflare ship fast, no doubt, but they have to ship one product completely stable and feature complete instead of shipping lots of products.

hardik043•9/29/24, 11:59 AM

can i use rpc client with D1 database?

Larry•9/29/24, 12:04 PM

@celestial, have you looked into the possibility of moving to Durable Objects? The limit there is actually only 1GB for now but it's going up to 10GB when it goes GA. However, you can create millions of them and not have to specify each instance in your

workers.toml

workers.toml

file. That's the architecture I'm switching to.

Original message was deleted

�

𝓈𝒽𝓎•9/29/24, 4:34 PM

may I ask what other providers you were using and what was the deal breaker for you

Carson•9/29/24, 9:34 PM

Does d1 support transitions at all and if so how would I use them? I see some documentation for the procedures but it doesnt look like thats supported anymore and nothing I find seems to work. And just using normal sqlite transactions dont work.

Original message was deleted

akashra•9/29/24, 11:35 PM

Everything about Grafana is terrible. Used at my previous employer. It's like budget splunk, for those who think they can save a few bucks.

CCarson Does d1 support transitions at all and if so how would I use them? I see some do...

akashra•9/29/24, 11:40 PM

Kinda. Not I. The db. It does JavaScript transactions, so because the code has to run in multiple places it's really difficult to have a tradition transaction. You can call things in a batch though,if you just want SQL.

CCarson Does d1 support transitions at all and if so how would I use them? I see some do...

akashra•9/29/24, 11:40 PM

https://blog.cloudflare.com/whats-new-with-d1/

The Cloudflare Blog

D1: our quest to simplify databases

Get an inside look on the D1 experience today, what the team is currently working on and what’s coming up!

Aakashra Kinda. Not I. The db. It does JavaScript transactions, so because the code has t...

o7•9/30/24, 2:23 AM

it depends on the persons use case also. I sent 10k requests from 3 different countries doing a count + 1 update query, and all 30k requests were added up

pablo•9/30/24, 7:05 AM

is there any guide to setup d1 with drizzle properly

pablo•9/30/24, 7:05 AM

:NotLikeThis:

Ppablo is there any guide to setup d1 with drizzle properly

boop•9/30/24, 8:08 AM

https://orm.drizzle.team/docs/get-started-sqlite#cloudflare-d1

Drizzle ORM - SQLite

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

pablo•9/30/24, 8:22 AM

Migration guide is incomplete

Ppablo Migration guide is incomplete

boop•9/30/24, 8:33 AM

https://sat0shi.dev/posts/drizzle-intro/

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!

Original message was deleted

trace•9/30/24, 10:35 AM

I can understand this. 10gb needs to be fix.

Original message was deleted

akashra•9/30/24, 12:08 PM

It's only free if your time is worth nothing... or if you're happy with a tool that doesn't really do what you want.

Aakashra Kinda. Not I. The db. It does JavaScript transactions, so because the code has t...

Carson•9/30/24, 2:55 PM

I insert a user, grab the auto incremnet pk, and then update the same table with a snowflake I created using the auto incremenet pk.

Right now if the snowflake fails or something else fails then the user will be left with no snowflake and I want to be able to revert changes.

Im guessing this isnt possible with d1 yet?

CCarson I insert a user, grab the auto incremnet pk, and then update the same table with...

o7•9/30/24, 3:06 PM

cant u do that in the same query? since its the same table

Carson•9/30/24, 3:14 PM

no because the snowflake is created using a function,

user is inseted without snowflake, just the email, hash, firstname, lastname, returning pk
funciton to turn pk to snowflake
then I update the user with the snowflake where pk matches

Carson•9/30/24, 3:22 PM

this is the workflow

        const hash = utils.hashPassword(request.json.password);
        const account = await env.DB.prepare("INSERT INTO users (email, password, firstname, lastname) VALUES (?, ?, ?, ?) RETURNING pk;")
            .bind(request.json.email, hash, request.json.firstname, request.json.lastname)
            .run();

        if (!account.success) throw new Error();

        const snowflake = utils.createSnowflake(account.results[0].pk);
        const set_id = await env.DB.prepare("UPDATE users SET id = ? WHERE pk = ?;")
            .bind(snowflake, account.results[0].pk)
            .run();
            
        if (!set_id.success) throw new Error();

        const hash = utils.hashPassword(request.json.password);
        const account = await env.DB.prepare("INSERT INTO users (email, password, firstname, lastname) VALUES (?, ?, ?, ?) RETURNING pk;")
            .bind(request.json.email, hash, request.json.firstname, request.json.lastname)
            .run();

        if (!account.success) throw new Error();

        const snowflake = utils.createSnowflake(account.results[0].pk);
        const set_id = await env.DB.prepare("UPDATE users SET id = ? WHERE pk = ?;")
            .bind(snowflake, account.results[0].pk)
            .run();
            
        if (!set_id.success) throw new Error();

CCarson this is the workflow ```js const hash = utils.hashPassword(request.json....

lambrospetrou•9/30/24, 7:35 PM

Since this is 2 remote calls, they are not connected, and cannot rollback. Is Snowflake just random IDs? If yes, can you create them ahead of time without the exact autoincrement and send them together in one query? Or use some other mechanism to generate your ID like UUID, ULID, Nanoid, etc.

const hash = utils.hashPassword(request.json.password); const account = await env.DB.prepare("INSERT INTO users (email, password, firstname, lastname) VALUES (?, ?, ?, ?) RETURNING pk;") .bind(request.json.email, hash, request.json.firstname, request.json.lastname) .run(); if (!account.success) throw new Error(); const snowflake = utils.createSnowflake(account.results[0].pk); const set_id = await env.DB.prepare("UPDATE users SET id = ? WHERE pk = ?;") .bind(snowflake, account.results[0].pk) .run(); if (!set_id.success) throw new Error();

these kind of statements don't help, I myself like what Cloudflare is doing in general and of course

Similar Threads

Similar Threads

Similar Threads