https://developers.cloudflare.com/api/resources/d1/

Interact with Cloudflare's products and services via the Cloudflare API

junaid•1/8/25, 7:43 AM

hi anyone can help me to migrate mysql to d1 We are currently attempting to migrate a 20GB MySQL database to Cloudflare D1. However, we’ve encountered challenges with file size limitations and memory constraints when using the wrangler CLI tool. Specifically, we received the following error while trying to execute the SQL file locally:

✘ [ERROR] Could not read file: /path/to/large-file.sql
Cannot create a string longer than 0x1fffffe8 characters

RRúben Fernandes https://developers.cloudflare.com/api/resources/d1/

Max (@rozenmd)•1/8/25, 8:55 AM

This approach would be subject to Cloudflare API's rate limit (1200 requests over 5 minutes)

Mmorning_eagle Can I use cloudflare D1 in an express.js app hosted outside of Cloudflare? In a ...

Max (@rozenmd)•1/8/25, 8:56 AM

You'd want a pass through Worker like https://github.com/elithrar/http-api-d1-example to talk to from Express for best performance

GitHub

GitHub - elithrar/http-api-d1-example: An example HTTP API for Clou...

An example HTTP API for Cloudflare's D1 database: https://developers.cloudflare.com/d1/

elithrar/http-api-d1-example

oscar•1/8/25, 10:26 AM

Hello! we're seeing some "put: We encountered an internal error. Please try again. (10001)" in our logs in the last few minutes. Notifying this because it's something we see more or less on a weekly basis.

Ooscar Hello! we're seeing some "put: We encountered an internal error. Please try agai...

Max (@rozenmd)•1/8/25, 10:41 AM

You're seeing that error thrown when running a D1 Client API function in your Worker?

oscar•1/8/25, 11:33 AM

Yes, this is production remote though, the error was caught and I received it at 11:12AM Barcelona time

Ooscar Yes, this is production remote though, the error was caught and I received it at...

Max (@rozenmd)•1/8/25, 11:35 AM

and you're not calling any other service in that Worker?

kaede•1/8/25, 2:17 PM

Can someone explain this please

Walshy•1/8/25, 2:17 PM

#r2

MMax (@rozenmd)and you're not calling any other service in that Worker?

oscar•1/8/25, 2:18 PM

honestly haven't had the time to dig deeper on that specific call but it's most probably an alarm trigger on a DO in a Worker that also interfaces with R2, KV and other Workers. Each specific DO alarm trigger may or may not interface with each of these services depending on the characteristics of the long running job it's running.

WWalshy #r2

kaede•1/8/25, 2:26 PM

Mb bro

Ooscar honestly haven't had the time to dig deeper on that specific call but it's most ...

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

Worth digging deeper on your side, that's not an error message from D1.

Ooscar Hello! we're seeing some "put: We encountered an internal error. Please try agai...

Chaika•1/8/25, 3:42 PM

I've gotten that exact same error from R2 before, you mention using R2 so probably that, just need to retry

Greenrider•1/8/25, 6:33 PM

Has anyone run into an issue with 504s back from D1 when using Wrangler to do load a .sql migration file remotely? It worked the first time, but now when I want to update the DB, I'm able to upload the .sql to remote and then I immediately get a 504 gateway error before anything in the .sql runs on remote

Billy•1/8/25, 9:38 PM

Is anyone aware of an existing tool that will take a D1 export and save the file directly to R2? I know I can do all this programmatically but I was hoping there was a simpler way or a pre-existing tool for it already. Thanks

Mitya•1/9/25, 2:05 PM

Just got this, in local development with

--remote

--remote

. Should I be concerned? Never happened before; no code changes happened.

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

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

MMitya Just got this, in local development with `--remote`. Should I be concerned? Neve...

Max (@rozenmd)•1/9/25, 3:31 PM

Nah, that error can only occur during deploys (

wrangler dev --remote

wrangler dev --remote

is a special type of deployment) - usually fixes itself when you retry

CChaika I've gotten that exact same error from R2 before, you mention using R2 so probab...

oscar•1/9/25, 4:36 PM

Thanks!

MMax (@rozenmd)Worth digging deeper on your side, that's not an error message from D1.

oscar•1/9/25, 4:38 PM

True, that may be R2. We do get some D1 errors periodically, sent you some examples on DM. Might be just a case of implementing retries?

Ooscar True, that may be R2. We do get some D1 errors periodically, sent you some examp...

Chaika•1/9/25, 4:38 PM

yea sane retries are a good idea: https://github.com/cloudflare/cloudflare-docs/issues/18485

esselungo•1/9/25, 8:55 PM

what would be the best setup for a grid of points being written every minute? i used to just write one row per point but d1 is just too expensive so i want to reduce the rows written

esselungo•1/9/25, 8:55 PM

is d1 even the best for that

Bailiwic•1/9/25, 9:56 PM

My build keeps looking for DATABASE_URL environment variable, but I'm using settings/binding to bind my D1 instance. I can create the variable, but don't know what to put in it since the binding doesn't have a url.

BBailiwic My build keeps looking for DATABASE_URL environment variable, but I'm using sett...

lambrospetrou•1/10/25, 9:48 AM

Are you using a framework? What is asking for that env?

Bailiwic•1/10/25, 11:46 AM

Next v14, Prisma v6. During build, error: Environment variable not found: DATABASE_URL. In settings | bindings I have D1 database, so not using wrangler to create a worker. I understand that there is no url for this binding.

BBailiwic Next v14, Prisma v6. During build, error: Environment variable not found: DATABA...

lambrospetrou•1/10/25, 1:17 PM

This error is probably coming from Prisma then. I am not familiar with Prisma, unfortunately, so hopefully someone else can chime in. In pure Worker projects nothing asks you for a database URL, since as you said D1 doesn't have a database URL.

besimking•1/10/25, 1:19 PM

Is there any possiblity for cloudflare to serve convex as a baas in the near future? Since it is open source

besimking•1/10/25, 1:22 PM

I kind a need a realtime db, that's why I asked this question

mihaaai•1/10/25, 2:00 PM

Does

maximum sql statement length

maximum sql statement length

100,000 bytes (100 KB)

100,000 bytes (100 KB)

also includes binding values? Since

Maximum string, BLOB or table row size

Maximum string, BLOB or table row size

2MB

2MB

, are values ignored from the previous constraint?

Bailiwic•1/10/25, 2:01 PM

For anyone interested, Prisma requires DATABASE_URL environment variable, even in production and using D1 binding. The value of the variable doesn't seem to make a difference.

BBailiwic For anyone interested, Prisma requires DATABASE_URL environment variable, even i...

harshil1712•1/10/25, 2:34 PM

Hey, are you using Prisma's D1 Adapter? I have used it with Remix, and got no errors on build. If you want to take a look, here's the link to the repo: https://github.com/harshil1712/remix-d1-auth-template

GitHub

GitHub - harshil1712/remix-d1-auth-template: A Remix template that ...

A Remix template that uses Cloudflare D1 for storing user data - harshil1712/remix-d1-auth-template

JoeDoe•1/12/25, 3:41 PM

Is there d1 performance issues?

JoeDoe•1/12/25, 3:41 PM

queries are taking very long atm

Viacheslav•1/12/25, 7:07 PM

hello, guys. Can anyone give me advice what wrong in my code https://github.com/Alex1998100/CloudflareD1

why this code get me 12, 000 seconds to load 1,000 records to DB.

GitHub

GitHub - Alex1998100/CloudflareD1

Contribute to Alex1998100/CloudflareD1 development by creating an account on GitHub.

Viacheslav•1/12/25, 7:10 PM

1000 rows loading 12,000 seconds

Screenshot_from_2025-01-12_18.24.21_1.png

majestic•1/13/25, 9:03 AM

Hello,
npx wrangler d1 execute --remoe
does this command works on cloudflace pages development ?

Mmajestic Hello, npx wrangler d1 execute --remoe does this command works on cloudflace p...

Isaac McFadyen•1/13/25, 12:13 PM

This command runs some SQL on a remote D1 database. It works regardless of where the database is linked. If that database is linked to Pages then yes this will work.

Leo•1/13/25, 8:57 PM

Why is the number of read rows so high again? For 24 hours, I managed to optimize my database by adding indexes, but since 5 P.M. UTC everything is like before.

Leo•1/13/25, 8:57 PM

The number of queries did not grow btw and the site usage is like normal.

LLeo Why is the number of read rows so high again? For 24 hours, I managed to optimiz...

lambrospetrou•1/13/25, 9:09 PM

Are you sure your changes on the index are applied? The workload before and after don't seem similar since pre-17:00 it's close to zero basically.
What is your database ID?

Llambrospetrou Are you sure your changes on the index are applied? The workload before and afte...

Leo•1/13/25, 9:10 PM

c35ed856-6db5-4c84-8ed4-f1da79b17926

Leo•1/13/25, 9:11 PM

I'm also confused af

LLeo c35ed856-6db5-4c84-8ed4-f1da79b17926

lambrospetrou•1/13/25, 9:16 PM

Your database is fine, no errors at all. You have two SELECT queries that are causing this I think probably due to lack of index. Make sure you applied your changes/optimizations on the remote database and you didn't only update a local test database if using wrangler.

Leo•1/13/25, 9:17 PM

I used the web dashboard to directly apply these changes to prod, and everything was fine until 17:00

LLeo I used the web dashboard to directly apply these changes to prod, and everything...

lambrospetrou•1/13/25, 9:19 PM

Check the D1 insights in the dashboard for slow queries to see your slow queries and confirm if the indexes you added apply to those queries (their where filters).

Leo•1/13/25, 9:22 PM

I can't find the insights you mean, I just have:

Tables
Console
Time Travel
Metrics
Settings

LLeo I can't find the insights you mean, I just have: Tables Console Time Travel Met...

lambrospetrou•1/13/25, 9:23 PM

Ah, they are through the API or wrangler: https://developers.cloudflare.com/d1/observability/metrics-analytics/#query-insights

Leo•1/13/25, 9:29 PM

The indexes worked yesterday and if I query the DB using the dashboard, a fairly normal row count appears... and I did not change anything since 12:00 today. I still don't see where the issue is and how to optimize these away.

Thanks for the insights btw

https://developers.cloudflare.com/api/resources/d1/

Similar Threads