Any ETA on worker-level support for the per-user DB approach? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

mulch

Mmulch Any ETA on worker-level support for the per-user DB approach?

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 5:31 AM

we don't do ETAs

Original message was deleted

forslunds

F

forslunds•4/4/24, 5:32 AM

True your case need it, good luck

i only have isolated users that dont/cant see other data so it should always be closest to the user

forslunds

Fforslunds Do we really need replicas if we go 1db/user 🤔 if we dont have heavy writes ofc

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 6:06 AM

read replicas are also critical above the 500-1k RPS mark, otherwise the individual DO starts queuing/overloading

Max (@rozenmd)

MMax (@rozenmd)read replicas are also critical above the 500-1k RPS mark, otherwise the individ...

forslunds

F

forslunds•4/4/24, 6:19 AM

Aah right its an DO, valid case! Thanks for heads up. Cant imagine that load per user for my case but better safe than sorry

(especially with that “price”!)

Chaika

CChaika Looks like Oceania/Australia DOs are online! https://where.durableobjects.live/c...

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 8:05 AM

:soontm:

Liudmila

LLiudmila cold start time with D1 appears to be 2sec, my DB is <2MB. Is this expected? Do ...

Matt Silverlock

M

Matt Silverlock•4/4/24, 12:51 PM

This is definitely not expected - we have metrics for cold starts. Are you seeing this repeatedly, or just a one-off?

Lucho

L

Lucho•4/4/24, 2:42 PM

hey, im a beginner with D1 and i was hoping to find some help
I created a model for a DB with prisma and migrated it SQLite. How can i "connect" this DB to Cloudflare D1?

Lucho

LLucho hey, im a beginner with D1 and i was hoping to find some help I created a model ...

Matt Silverlock

M

Matt Silverlock•4/4/24, 3:01 PM

I'd recommend stepping through this guide from beginning to end! https://developers.cloudflare.com/d1/tutorials/d1-and-prisma-orm/

Cloudflare Docs

Query D1 using Prisma ORM · Cloudflare D1 docs

Prisma ORM is a next-generation JavaScript and TypeScript ORM that unlocks a new level of developer experience when working with databases thanks to …

Lucho

L

Lucho•4/4/24, 4:17 PM

thank you!!

Lucho

L

Lucho•4/4/24, 6:05 PM

I was following the guide until this error appeared

Lucho

L

Lucho•4/4/24, 6:06 PM

does someone know how to resolve it?

Lucho

LLucho I was following the guide until this error appeared

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 6:09 PM

whats the contents of that SQL file?

Lucho

L

Lucho•4/4/24, 6:10 PM

just this

Lucho

LLucho just this

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 6:11 PM

out of curiousity, does it work if you remove the comments? -- CreateTable-- CreateTable and -- CreateIndex-- CreateIndex

Lucho

L

Lucho•4/4/24, 6:12 PM

i'll try

Lucho

L

Lucho•4/4/24, 6:12 PM

nope

Lucho

L

Lucho•4/4/24, 6:12 PM

same error

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 6:17 PM

and the contents of that file is now just this?

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

CREATE TABLE "User" ( 
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
    "email" TEXT NOT NULL, 
    "name" TEXT 
);

CREATE UNIQUE INDEX "User_email_key" ON "User"("email");

Lucho

LLucho just this

tsion

T

tsion•4/4/24, 6:33 PM

the loose emoji on line 10 is probably the problem?

tsion

Ttsion the loose emoji on line 10 is probably the problem?

Lucho

L

Lucho•4/4/24, 6:34 PM

it isnt an emoji, it's from copilot

Lucho

L

Lucho•4/4/24, 6:35 PM

it goes away if i tap aywhere else

tsion

T

tsion•4/4/24, 6:35 PM

i see

Max (@rozenmd)

MMax (@rozenmd)and the contents of that file is now just this? ``` CREATE TABLE "User" ( "...

Lucho

L

Lucho•4/4/24, 6:38 PM

thats right

Isaac McFadyen

I

Isaac McFadyen•4/4/24, 6:57 PM

Check your line endings?

Isaac McFadyen

I

Isaac McFadyen•4/4/24, 6:58 PM

The "near ??" error makes it seem like there are some unprintable characters in there somewhere, maybe line endings or empty spaces?

Matt Silverlock

M

Matt Silverlock•4/4/24, 6:58 PM

Runs perfectly for me as copied from @Max (@rozenmd)'s code block:

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

Isaac McFadyen

I

Isaac McFadyen•4/4/24, 7:00 PM

If you're on a Windows system try changing from CRLF to just LF?

Matt Silverlock

M

Matt Silverlock•4/4/24, 7:02 PM

Something is definitely off with your editor here, @Lucho.

The migration (just copy pasted from the docs):

kian

K

kian•4/4/24, 7:09 PM

at offset 0 is weird

kian

K

kian•4/4/24, 7:10 PM

it's pulled from sqlite3_error_offsetsqlite3_error_offset which indicates it's the first character of that given input, but since Wrangler splits the statements you don't really know which one it is

Isaac McFadyen

I

Isaac McFadyen•4/4/24, 7:24 PM

Just tried CRLF vs LF and both work so that's not the issue.

kian

K

kian•4/4/24, 7:28 PM

Usually if it's LF/CRLF you get a "you can't execute multiple statements" error or something like that

kian

K

kian•4/4/24, 7:29 PM

A prepared SQL statement must contain only one statement. even

Matt Silverlock

MMatt Silverlock Something is definitely off with your editor here, @Lucho. The migration (just ...

Lucho

L

Lucho•4/4/24, 7:39 PM

oh okay

Lucho

L

Lucho•4/4/24, 7:39 PM

it might be

Lucho

L

Lucho•4/4/24, 7:41 PM

i'll try doing the entire guide again from scratch

adjlsncm

A

adjlsncm•4/4/24, 8:11 PM

is d1 sqlite or sql? is sqlite worse?

adjlsncm

A

adjlsncm•4/4/24, 8:15 PM

it seems like sqlite is worse for anything potentially large scale from what im reading

mzadz

M

mzadz•4/4/24, 8:23 PM

Is it possible to run a Prisma seed script and apply it to a D1 DB, either locally or remote? It would involve executing a TypeScript file i.e seed.tsseed.ts. Can't seem to find any example of this in the tutorials

adjlsncm

Aadjlsncm it seems like sqlite is worse for anything potentially large scale from what im ...

Max (@rozenmd)

M

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

D1/sqlite fits some use cases, classic DBs fit others - depends what you're trying to do.

adjlsncm

A

adjlsncm•4/4/24, 8:34 PM

social media application similar to letterboxd, bad idea or no? im between using D1 because im already using R2 + Pages for hosting or just using Planetscale

adjlsncm

Aadjlsncm social media application similar to letterboxd, bad idea or no? im between using...

Max (@rozenmd)

M

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

Planetscale would support scaling and replication from the start, D1 is still building it

Original message was deleted

Max (@rozenmd)

M

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

No but cool idea - best is probably logging the prepared query string

wrangler d1 insightswrangler d1 insights could tell you summary stats but it only shows the query string too

Max (@rozenmd)

MMax (@rozenmd)Planetscale would support scaling and replication from the start, D1 is still bu...

adjlsncm

A

adjlsncm•4/4/24, 8:47 PM

regardless of that technically speaking, SQLite would be worse?

adjlsncm

Aadjlsncm regardless of that technically speaking, SQLite would be worse?

Max (@rozenmd)

M

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

there's no better/worse here, It Depends

Max (@rozenmd)

MMax (@rozenmd)there's no better/worse here, It Depends

adjlsncm

A

adjlsncm•4/4/24, 8:50 PM

on?

Original message was deleted

Max (@rozenmd)

M

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

query execution time inside D1, yeah

adjlsncm

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 9:01 PM

expected reads/writes per second and amount of data stored to start with - sqlite can be really good for scaling simple read-heavy use cases really far as there's less to worry about

Max (@rozenmd)

M

Max (@rozenmd)•4/4/24, 9:03 PM

whereas the tech underneath planetscale powers youtube, but you pay a price for that scalability

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms

~/repos/d1 (main) ✗
➜  pbpaste > user_repro_20240404.sql
~/repos/d1 (main) ✗
➜  wrangler d1 execute db-enam --file=user_repro_20240404.sql

🌀 Mapping SQL input into an array of statements
🌀 Parsing 2 statements
🌀 Executing on db-enam (c89db32e-83f4-4e62-8cd7-7c8f97659029):
🚣 Executed 2 commands in 0.4695ms