ok found the issue: in the `svelte.config.js` file i had to set `platformProxy.environment` to `'pro

ok found the issue: in the

svelte.config.js

svelte.config.js

file i had to set

platformProxy.environment

platformProxy.environment

platformProxy.environment

platformProxy.environment to

'production'

'production'

'production'

'production' inside the adapter's config

Vveeque ok found the issue: in the `svelte.config.js` file i had to set `platformProxy.e...

Hello, I’m Allie!•8/20/24, 12:12 PM

Good you figured it out! I’d kind of stumped myself on that one

Leif•8/21/24, 8:16 AM

Hey guys, I want to use the 'database per tenant' architecture, but I'm a little blocked with how to implement it with D1. (I'm using Pages with the SvelteKit adapter).

My current understanding of D1 is that upon a worker creation, it creates a read only replica of the Sqlite file inside the instance, and upon writes it calls back to the main D1 instance with eventual consistency inside workers replicas.

This architecture is fine because my application will never have multiple users writing to the same row, so no concurrency issues for my app.

I have users creating 'communities', and I would like each community to be it's own database (mainly for data ownership and D1 storage constraint reasons).

But here are my current issues that I would really appreciate help with understanding (I haven't found much documentation on this):

1) How to dynamically create databases with the same schema (a community schema, but I can create hundreds of these databases).
2) How to handle migrations across all the databases of the same schema.
3) Most importantly, how to efficiently bind these potentially hundreds of databases with my workers.

I might be heading in the wrong direction with this architecture. I'd love some correction if necessary. Thanks in advance for your help!

Original message was deleted

Leif•8/21/24, 8:34 AM

Oh wow! I guess my entire understanding of D1 is just wrong then! Is there any documentation for dynamic bindings? Thanks for the response.

Leif•8/21/24, 8:35 AM

Ohhh thank you. So out of curiosity, how are people actually using D1 in production? The limitations seem pretty unfavorable for most production applications.

EvanPiro•8/21/24, 6:52 PM

Is there support for functions? I know the feature isn't available in sqlite but I have a codebase that is full of repeated queries in nodejs and would love to call them directly from the db.

Jose•8/21/24, 9:58 PM

Hello, i am getting this error in my D1, Internal error while starting up D1 storage caused object to be reset. [code: 7500], and returns the info failed to reach database, any ideias?

LLeif Ohhh thank you. So out of curiosity, how are people actually using D1 in product...

Dean•8/22/24, 1:58 AM

Right now using workers with svelte and binding via the API. Will eventually hit problems as I can only bind 5000 ish databases. Dynamic bindings should solve the problem before we get there.

JJose Hello, i am getting this error in my D1, Internal error while starting up D1 sto...

Max (@rozenmd)•8/22/24, 5:33 AM

what's your database id?

oof2win2•8/22/24, 6:47 AM

is there an intended usage path for local dev when binding two workers to the same db?

andreasb•8/22/24, 6:51 AM

Any plans from Cloudflare to do a bitemporal/immutable database offering, akin to XTDB, SQL Server 2022 Ledger, ImmuDB or similar?

Softbear•8/22/24, 8:19 AM

Hello I see some discrepancy in my D1 usage.

When I query my stats I see that this query is reading a lot of rows

But when I run it it works as expected (I have an index on the column)

Same for the explain query plan

It's 2B rows/day of reads ...

Fernando Barroso•8/22/24, 8:10 PM

Hello all! Has anyone here ever built an event store (for the purpose of event sourcing) on top of D1 by chance?

ian•8/23/24, 9:04 PM

why are metrics queries on D1 limited to 1 week?

Iian why are metrics queries on D1 limited to 1 week?

Max (@rozenmd)•8/23/24, 9:48 PM

looks like a bug

Aamcclosky Any updates on when there might be updates around cloning databases? or spinning...

Max (@rozenmd)•8/23/24, 9:48 PM

it becomes possible after read replication is released

DDean Right now using workers with svelte and binding via the API. Will eventually hit...

Leif•8/24/24, 5:57 AM

I'm very curious by what you mean by problems. Are you referring to memory constraints on your worker, D1 instance, or both?

Also another big question I have: When a worker binds with a D1 database, is it performing any edge specific optimizations, or just making network calls against a crntral database. I ask this question because if I'm always going to be making db calls to a centeal DB, whats the purpose of having my functions on the edge?

LLeif I'm very curious by what you mean by problems. Are you referring to memory const...

Dean•8/24/24, 5:58 AM

I’m talking about the max 5000 db binding limit on a worker.

Leif•8/24/24, 5:59 AM

Okay makes sense

LLeif I'm very curious by what you mean by problems. Are you referring to memory const...

Max (@rozenmd)•8/24/24, 1:29 PM

when your worker talks to D1, everything is in the edge

when you use the API/wrangler/dash, it involves a round trip to a core DB. there's work in progress to move the API to the edge

MMax (@rozenmd)when your worker talks to D1, everything is in the edge when you use the API/wr...

Leif•8/24/24, 1:31 PM

Thanks for the response! Just out of curiosity, how is that mechanism working? Does D1 create a read only replica on the edge, and all writes goto a centralized DB, with eventual consistency?

LLeif Thanks for the response! Just out of curiosity, how is that mechanism working? D...

Max (@rozenmd)•8/24/24, 1:34 PM

the D1 binding lets us skip the db

Leif•8/24/24, 1:43 PM

So there's just some cloudflare proprietary magic keeping the edge sqlite files in sync, and I can just use the D1 binding like I'm talking to a single database? If so thats pretty awesome.

Max (@rozenmd)•8/24/24, 2:41 PM

D1 dbs are on the edge

James•8/24/24, 3:54 PM

Yeah I think the biggest confusion here is around what most people associate the ‘edge’ with - which for most people means being close to all of your users, all the time, all at once, like Workers. With D1, that’s simply not the case with the DB in a single location.
Marketing and terminology is hard

James•8/24/24, 3:55 PM

‘Core’ also has a very specific cf meaning so probably isn’t that helpful in describing stuff to end-users honestly

JJames Yeah I think the biggest confusion here is around what most people associate the...

Max (@rozenmd)•8/24/24, 8:24 PM

ah right, for now

MMax (@rozenmd)ah right, for now

Dean•8/25/24, 5:47 AM

birthday week announcements hopefully

Max (@rozenmd)•8/25/24, 12:32 PM

personally I'm in raw SQL gang

boop•8/25/24, 1:07 PM

At a young age my parents taught me the importance of always using protection, and this is why I use Drizzle

HHello, I’m Allie!Preview runs against a real D1 DB

0xwei_hup•8/25/24, 3:14 PM

totally missed this. but thanksss

Ashish Rawat•8/26/24, 7:55 AM

Seems like D1 doesn't support

ATTACH DATABASE

ATTACH DATABASE

command to aggregate from multiple D1.

AAshish Rawat Seems like D1 doesn't support `ATTACH DATABASE` command to aggregate from multip...

Max (@rozenmd)•8/26/24, 9:07 AM

correct

Yo•8/26/24, 2:08 PM

Yo•8/26/24, 2:12 PM

When i insert data "row_written": 3

YYo When i insert data "row_written": 3

Matt Silverlock•8/26/24, 2:14 PM

https://developers.cloudflare.com/d1/platform/pricing/#definitions

Indexes will add an additional written row when writes include the indexed column, as there are two rows written: one to the table itself, and one to the index. The performance benefit of an index and reduction in rows read will, in nearly all cases, offset this additional write.

MMatt Silverlock https://developers.cloudflare.com/d1/platform/pricing/#definitions > Indexes wi...

Yo•8/26/24, 9:25 PM

Thank

Yo•8/26/24, 9:26 PM

What is your cpu time limit for cloudflare page?

YYo What is your cpu time limit for cloudflare page?

boop•8/26/24, 9:51 PM

D1 query duration? 30 seconds
Pages functions duration? Free: 10ms, Paid: 30 seconds

Bboop D1 query duration? 30 seconds Pages functions duration? Free: 10ms, Paid: 30 sec...

Yo•8/26/24, 9:58 PM

I use free plan for test it show cpu time over 10ms but But it can still be used normally

YYo I use free plan for test it show cpu time over 10ms but But it can still be used...

boop•8/26/24, 10:03 PM

https://developers.cloudflare.com/workers/platform/limits/#cpu-time

"Each isolate has some built-in flexibility to allow for cases where your Worker infrequently runs over the configured limit. If your Worker starts hitting the limit consistently, its execution will be terminated according to the limit configured."

Cloudflare Docs

Limits | Cloudflare Workers docs

Cloudflare Workers plan and platform limits.

Chaika•8/26/24, 10:08 PM

there's a more in-depth explanation of it here: How are CPU limits enforced in the free tier?

Bboop https://developers.cloudflare.com/workers/platform/limits/#cpu-time "Each isola...

Yo•8/26/24, 10:28 PM

I use Page but I dont sure limit cpu time for Page

YYo I use Page but I dont sure limit cpu time for Page

boop•8/26/24, 10:29 PM

Any functions you perform on your Pages project is just a worker, so the same limits apply

Bboop Any functions you perform on your Pages project is just a worker, so the same li...

Yo•8/26/24, 10:31 PM

I use nuxt3 for SPA but i dont use server on nuxt. I'm not sure which part is calling the function

boop•8/26/24, 10:32 PM

This isn't the channel for that, try coding-help

louiek22•8/27/24, 12:28 AM

Is it possible to use the results of a previous query in a

d1.batch

d1.batch

call in the next query? I'm worried that sending a read query to find a specific row, waiting for the results in JS, and then sending a write query may end up with 2 workers trying to edit the same row.

Llouiek22 Is it possible to use the results of a previous query in a `d1.batch` call in th...

louiek22•8/27/24, 12:53 AM

Solved this by combing my

SELECT

SELECT

query into my

UPDATE

UPDATE

query and using

LIMIT 1

LIMIT 1

so I can do everything in a single query.

ok found the issue: in the `svelte.config.js` file i had to set `platformProxy.environment` to `'pro

Similar Threads

Similar Threads

Similar Threads