This is stunning. I assume (hope) that the DO sqlite is functionally equivalent to D1 (including FTS

This is stunning.
I assume (hope) that the DO sqlite is functionally equivalent to D1 (including FTS5 and Json modules)?

BBen Yea seems like a great fit for this, could also maybe enable embedded replicas a...

oof2win2•9/26/24, 5:07 PM

that's probably out of scope and libsql server would mean that there would need to be a connection url - which is not the way cloudflare has it sorted out now

oof2win2•9/26/24, 5:07 PM

just adds overhead, instead an easier way is to make a separate worker that connects via the libsql c/rust client internally

Ooof2win2 that's probably out of scope and libsql server would mean that there would need ...

Ben•9/26/24, 6:08 PM

sorry I thought I was in the durable object channel xD - there are now two sqlite services

Mmarko.333 This is stunning. I assume (hope) that the DO sqlite is functionally equivalent ...

Acе•9/27/24, 12:02 AM

It’s the same stuff that D1 is built on apparently, so those should be there. You could even build your own D1 service with this

DDeep @qo7ems @Acе @Isaac | AS213339 thanks everyone! i have a unique use case for D...

stibbs•9/27/24, 6:05 AM

Is it even possible to specify the region for the db? I assumed if you had regulated data sovereignty concerns D1 was simply not an option? The closest control I'm aware of on this is providing a "location hint" but the docs say

Warning: Providing a location hint does not guarantee that D1 runs in your preferred location. Instead, it will run in the nearest possible location (by latency) to your preference.

Warning: Providing a location hint does not guarantee that D1 runs in your preferred location. Instead, it will run in the nearest possible location (by latency) to your preference.

(source)

Jikyu•9/27/24, 12:58 PM

Would it be possible to use drizzle / run drizzle migrations against the new DO sql database, like we can for D1?

Sstibbs Is it even possible to specify the region for the db? I assumed if you had regul...

Acе•9/27/24, 12:58 PM

Location hints aren’t guaranteed to be spawned in that location because of capacity, datacenter downtime or failures, but very often they will be. You can’t rely on that though. However, now that we have SQL in Durable Objects we can specify a jurisdiction which will always be respected because Durable Objects have that feature.

shixzie•9/27/24, 1:19 PM

no d1 announcements :nootlikethis:

bennycondon•9/27/24, 1:59 PM

I was hoping we’d get an update on dynamic bindings for D1 this week

Bbennycondon I was hoping we’d get an update on dynamic bindings for D1 this week

boop•9/27/24, 2:25 PM

Same, it's been over 2 years since D1 was announced and still no way to use it with workers the way it was intended

shixzie•9/27/24, 2:42 PM

yup, i guess turso will be the choice for multi-tenant apps rn

LordSilver•9/27/24, 2:42 PM

Is D1 a closed-source fork of SQLite, something similar to libSQL? Is it 100% compatible with SQLite? If you wanted to export your D1 db and move it to any other SQLite hosting, would you be able to do that?

LLordSilver Is D1 a closed-source fork of SQLite, something similar to libSQL? Is it 100% co...

Hard@Work•9/27/24, 2:43 PM

The runtime component of it should be in https://github.com/cloudflare/workerd

GitHub

GitHub - cloudflare/workerd: The JavaScript / Wasm runtime that pow...

The JavaScript / Wasm runtime that powers Cloudflare Workers - cloudflare/workerd

Hard@Work•9/27/24, 2:43 PM

Somewhere

Sshixzie yup, i guess turso will be the choice for multi-tenant apps rn

kooliebwoykg•9/27/24, 2:44 PM

I switched and couldn't believe how easy it was and how beautiful multi-tenant works with Turso.

Sstibbs Is it even possible to specify the region for the db? I assumed if you had regul...

Deep•9/27/24, 3:08 PM

you're right. i've dropped D1 as an option for me for other reasons as well.

AAcе Location hints aren’t guaranteed to be spawned in that location because of capac...

lambrospetrou•9/27/24, 4:24 PM

Just to clarify on this, location hints in D1 work in similar way to location hints in DOs, since D1 uses SQLite-in-DOs under the hood.

Jurisdictions is a different thing, making sure your DO is within a specific broader area, with only

eu

eu

and

fedramp

fedramp

as possible values right now (see docs).

Bboop Same, it's been over 2 years since D1 was announced and still no way to use it w...

lambrospetrou•9/27/24, 4:36 PM

Can't share timelines yet, but we are working on some exciting features to improve this that will be coming over the next few months!

Llambrospetrou Can't share timelines yet, but we are working on some exciting features to impro...

boop•9/27/24, 5:55 PM

Is "exciting features" dynamic bindings? I'm bored of waiting for a feature that is a requirement to using D1 properly. Redeploying my worker every time I get a new customer to get past the 10gb limitation using an external service is just plain stupid. The D1 team should probably ask the DO team if they can borrow their binding code

Bboop Is "exciting features" dynamic bindings? I'm bored of waiting for a feature that...

o7•9/27/24, 6:51 PM

Both teams are obviously already working together, D1 is built on SQLite for DO. Also, I don't want to get too schizo, but I am 100% sure that they're releasing it in the next few days given the context clues

o7•9/27/24, 6:55 PM

if im wrong i will delete my account and never be seen here again

Oo7 if im wrong i will delete my account and never be seen here again

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

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.

shixzie•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.333OP•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.333OP•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.

This is stunning. I assume (hope) that the DO sqlite is functionally equivalent to D1 (including FTS

Similar Threads