Hello everyone, do you know how many writes per second can a single user perform over D1?

C

I know D1 is SQLite behind the scenes and I already tested this functionality on SQLite, just want to confirm if D1 has no additional restriction layer on that matter

CCosmic Ternurin Hello everyone, do you know how many writes per second can a single user perform...

H

Hello, I’m Allie!•10/20/24, 6:37 PM

Via the Workers API, there should be no imposed limits, just the limits inherent to running SQLite in a single thread

H

Hello, I’m Allie!•10/20/24, 6:37 PM

Via the HTTP API, there is the normal Cloudflare API Ratelimit

H

Hello, I’m Allie!•10/20/24, 6:37 PM

Which IIRC is 1200 requests / 5 minutes

HHello, I’m Allie!Via the Workers API, there should be no imposed limits, just the limits inherent...

C

Cosmic TernurinOP•10/20/24, 6:37 PM

C

Cosmic TernurinOP•10/20/24, 6:38 PM

Thanks, have a nice day/evening

FFriday Candour What about the API?

H

Hello, I’m Allie!•10/21/24, 5:23 PM

That is the API?

H

hectorruizlaph•10/21/24, 8:04 PM

Hi there, Im a developer having a client, I ask them to create an account on cloudflare buy a domain and invite me with admin privileges but now I only have access to some stuff but not all of the stuff like workers, D1 etc. why? or how should I onvoard new clients where I can deploy every service on ther end?

R

Rihan•10/21/24, 8:40 PM

I'm trying to run multiple SQL statements at once.
- When running multiple multi-line queries via D1 REST API everything works.
- When running multiple multi-line queries via

env.DB.exec()

env.DB.exec()

env.DB.exec()

env.DB.exec(), I get an error. It can only parse multiple queries if each query is only a single line.

works via

db.exec()

db.exec()

db.exec()

db.exec()

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

doesn't via

db.exec()

db.exec()

db.exec()

db.exec()

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

-- Migration number: 0000       2024-10-18T05:40:01.544Z
CREATE TABLE todos (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL
);
INSERT INTO hub_migrations (name) values ('0000_create-todos');

J

jLynx•10/22/24, 9:31 PM

There seems to be an issue with functions or D1. All of a sudden our deployments have started failing with

Error: Failed to publish your Function. Got error: binding MYAPP_DB of type d1 failed to generate. Please try again later or contact support.

Error: Failed to publish your Function. Got error: binding MYAPP_DB of type d1 failed to generate. Please try again later or contact support.

Error: Failed to publish your Function. Got error: binding MYAPP_DB of type d1 failed to generate. Please try again later or contact support.

Error: Failed to publish your Function. Got error: binding MYAPP_DB of type d1 failed to generate. Please try again later or contact support.

JjLynx There seems to be an issue with functions or D1. All of a sudden our deployments...

J

jLynx•10/22/24, 9:36 PM

pages-discussions

A

Alexander•10/22/24, 9:40 PM

Same here: binding DB of type d1 failed to generate. Please try again later or contact support. [code: 10021]

B

Baya•10/22/24, 9:42 PM

The same issue here too: DB binding is throwing error

J

jLynx•10/22/24, 9:45 PM

Check the link above, support are onto it

R

Ramstik•10/22/24, 10:00 PM

D1 team is asking what endpoint/function you are trying to work with?

RRamstik D1 team is asking what endpoint/function you are trying to work with?

I

itsmatteomanf•10/22/24, 10:00 PM

It's listed here

I

itsmatteomanf•10/22/24, 10:00 PM

general-discussions

R

Romeu Palos•10/22/24, 10:03 PM

We are also seeing this error.
We are trying to deploy the code using

npx wrangler deploy

npx wrangler deploy

npx wrangler deploy

npx wrangler deploy

Partial toml file

d1_databases = [
    { binding = "configs", database_name = "configs", database_id = "f1e42435-758a-4abf-842d-2303131a96a1" },
]

d1_databases = [
    { binding = "configs", database_name = "configs", database_id = "f1e42435-758a-4abf-842d-2303131a96a1" },
]

d1_databases = [
    { binding = "configs", database_name = "configs", database_id = "f1e42435-758a-4abf-842d-2303131a96a1" },
]

d1_databases = [
    { binding = "configs", database_name = "configs", database_id = "f1e42435-758a-4abf-842d-2303131a96a1" },
]

Deployments fail 100% of the time. and running the worker remotely also does not work.

RRamstik D1 team is asking what endpoint/function you are trying to work with?

J

jLynx•10/22/24, 10:03 PM

Not sure what you mean exactly here. Just a standard function that's linked to a d1 DB

RRamstik D1 team is asking what endpoint/function you are trying to work with?

B

Baya•10/22/24, 10:04 PM

I am seeing errors when binding in both Workers and Pages.

JjLynx Not sure what you mean exactly here. Just a standard function that's linked to a...

J

jLynx•10/22/24, 10:04 PM

J

jLynx•10/22/24, 10:04 PM

This is on a pages deployment

J

jLynx•10/22/24, 10:11 PM

Should probably put an update on https://www.cloudflarestatus.com/

Cloudflare Status

Welcome to Cloudflare's home for real-time and historical data on system performance.

JjLynx Should probably put an update on https://www.cloudflarestatus.com/

I

Isaac McFadyen•10/22/24, 10:15 PM

Being actively worked on (status page I mean), thank you.

W

Walshy•10/22/24, 10:38 PM

And fixed - https://www.cloudflarestatus.com/incidents/f907j39814l7

Errors Deploying Workers with D1 Database Bindings

J

James•10/23/24, 1:35 PM

Drizzle works fine w d1.

A

ac•10/23/24, 5:38 PM

Are there any plans to make it possible to have dynamic service bindings for D1? E.g. for single-tenant DB situations. It seems the only options to make those work right now are either fill wrangler.toml with a ton of service bindings, or use D1's REST API instead of service bindings. Would prefer to avoid both of those....

Aac Are there any plans to make it possible to have dynamic service bindings for D1?...

A

ac•10/23/24, 5:46 PM

I found this related post, but mainly checking on whether this is still planned or if we need to go a different direction. The 10gb-per-DB limit means multitenant isn't a great plan with d1 either

Aac Are there any plans to make it possible to have dynamic service bindings for D1?...

H

Hello, I’m Allie!•10/23/24, 5:49 PM

Like with the new DO SQLite storage?

HHello, I’m Allie!Like with the new DO SQLite storage?

A

ac•10/23/24, 5:51 PM

Not very familiar with DOs, but looking at the docs/syntax, probably yes? Mainly a way to have a generic D1 binding and a

D1.getById

D1.getById

D1.getById

D1.getById function

Aac Not very familiar with DOs, but looking at the docs/syntax, probably yes? Mainly...

H

Hello, I’m Allie!•10/23/24, 5:54 PM

Yeah, that sounds right, though note that a DO by default doesn't expose the SQL interface to the calling Worker

A

ac•10/23/24, 6:10 PM

Yeah, I'm not using Durable Objects, just D1, so just wondering if this functionality is truly planned for D1 (and maybe coming soon?)

S

Sheraz•10/23/24, 8:28 PM

Anyone else getting "D1_ERROR: D1 is overloaded. Too many requests queued" more than usual today?

Aac Are there any plans to make it possible to have dynamic service bindings for D1?...

J

John Spurlock•10/23/24, 11:21 PM

yep, it is on their roadmap

https://blog.cloudflare.com/making-full-stack-easier-d1-ga-hyperdrive-queues/

J

Jadugar_Jaggu•10/25/24, 6:16 AM

Facing perfromance issues with D1 today, taking some time to retrive data

A

anand248•10/26/24, 3:00 AM

wrangler d1 migrations apply remote failing to find pending migrations to apply, ends without applying anything.
wrangler.toml

[[d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
preview_database_id = "LOCAL-MY-DB" # Required for Pages local development
migrations_dir = "migrations"

[vars]

[[env.production.d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "8someguid63a"
migrations_dir = "migrations"

[[d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
preview_database_id = "LOCAL-MY-DB" # Required for Pages local development
migrations_dir = "migrations"

[vars]

[[env.production.d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "8someguid63a"
migrations_dir = "migrations"

[[d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
preview_database_id = "LOCAL-MY-DB" # Required for Pages local development
migrations_dir = "migrations"

[vars]

[[env.production.d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "8someguid63a"
migrations_dir = "migrations"

[[d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"
preview_database_id = "LOCAL-MY-DB" # Required for Pages local development
migrations_dir = "migrations"

[vars]

[[env.production.d1_databases]]
binding = "DB"
database_name = "name-db"
database_id = "8someguid63a"
migrations_dir = "migrations"

My

migrations

migrations

migrations

migrations folder do have some unapplied

.sql

.sql

.sql

.sql files, but it fails to find them

 ~/tess-fs/web/ [main] npx wrangler d1 migrations list name-db

wrangler 3.83.0
-------------------

No migrations to apply!
 ~/tess-fs/web/ [main] npx wrangler d1 migrations list name-db --remote

wrangler 3.83.0
-------------------

 ~/tess-fs/web/ [main*]
-------------------

Aanand248 wrangler d1 migrations apply remote failing to find pending migrations to apply,...

A

anand248•10/26/24, 3:12 AM

found the solution, I am suppose to use the actual

database_id

database_id

database_id

database_id of remote database in

[[d1_databases]]

[[d1_databases]]

[[d1_databases]]

[[d1_databases]] section. I thought, when we supply --remote parater, it picks the

[[env.production.d1_databases]]

[[env.production.d1_databases]]

[[env.production.d1_databases]]

[[env.production.d1_databases]] section. I am struggling to understand

wrangler.toml

wrangler.toml

wrangler.toml

wrangler.toml file structure.

F

fry69•10/26/24, 9:11 PM

May be better placed here -> #what-i-built

N

nullptr•10/26/24, 10:42 PM

Is there a way to mirror prod d1 to local? All the examples i've seen online were doing migrations.

S

Shinebayar G•10/27/24, 5:21 AM

Hello. I'm getting this error when running

npx drizzle-kit push

npx drizzle-kit push

npx drizzle-kit push

npx drizzle-kit push command. Anyone know what's going on?

[✓] Pulling schema from database...
Error: 7500: not authorized: SQLITE_AUTH

[✓] Pulling schema from database...
Error: 7500: not authorized: SQLITE_AUTH

[✓] Pulling schema from database...
Error: 7500: not authorized: SQLITE_AUTH

[✓] Pulling schema from database...
Error: 7500: not authorized: SQLITE_AUTH

S

Shinebayar G•10/27/24, 5:22 AM

API token has edit permission on D1 resource.

Edit: It seems something is broken on Drizzle Kit.

Ssilentdevnull Does D1 support the FTS5 Extension of SQLite? I'm trying to figure out if D1 can...

F

fry69•10/27/24, 9:34 PM

Looks like it does? -> https://community.cloudflare.com/t/d1-support-for-virtual-tables/607277/3?u=fry69

Ssilentdevnull Does D1 support the FTS5 Extension of SQLite? I'm trying to figure out if D1 can...

L

lambrospetrou•10/28/24, 11:25 AM

Yes: https://developers.cloudflare.com/d1/reference/sql-statements/#sqlite-extensions

Hello everyone, do you know how many writes per second can a single user perform over D1?

Similar Threads

Similar Threads

Similar Threads