If you’re just starting the project would recommend using the drizzle beta which should be stable in

If you’re just starting the project would recommend using the drizzle beta which should be stable in 1-2 months. Saves having todo a big refactor later when you decide to upgrade to v1

cloudkiteOP•9/10/25, 5:01 AM

Also worth considering if DO SQLite is a better fit for your project, we recently migrated and it simplified our code while improving reliability and performance

Ccloudkite If you’re just starting the project would recommend using the drizzle beta which...

Joey9•9/10/25, 5:14 AM

do you have a link to track progress of the beta? where you see it will be stable in 1-2 months

JJoey9 do you have a link to track progress of the beta? where you see it will be stabl...

cloudkiteOP•9/10/25, 5:32 AM

Their discord server has info on beta and timelines

maj•9/10/25, 2:34 PM

QQ. on the Queries overview for D1: are the "Rows Read/Written" the total for the "count" number of requests? Or average values? I'm trying to understand how those number can be mapped to the numbers given at the top of that page. Because there I have 30M rows read. And I wonder how come I would reach that number, given the top four requests are only in the thousands. And there's not that huge tail with millions of smaller queries.

Mmaj QQ. on the Queries overview for D1: are the "Rows Read/Written" the total for th...

lambrospetrou•9/10/25, 5:03 PM

Let me clarify with the team and get back to you.

OOr We're starting to see an increase in internal errors again, is D1 having known i...

lambrospetrou•9/10/25, 5:43 PM

Are you getting these in some specific location? There isn't any service wide issue at the moment. There was a blip of network issues for 1-2 minutes in eeur for a tiny % of requests, from what I see.

Llambrospetrou Let me clarify with the team and get back to you.

lambrospetrou•9/10/25, 5:46 PM

Currently the column Rows Read is using averages, so 45.6K*662=30M45.6K*662=30M, which matches what you said. We should probably make that sum as well, but it might confuse folks with the count in that case.

OOr Not as far as I can see, our main DBs are all located in ENAM, we turned read r...

lambrospetrou•9/10/25, 5:48 PM

Replication shouldn't cause this. Maybe your errors were from the replica in eeur during that blip of errors?
If you continue seeing consistent errors let us know (account+DB IDs, and some rough timerange).

OOr We're seeing again lots of internal errors, right after I enabled read replicati...

lambrospetrou•9/11/25, 7:22 AM

Yeah, please do if you are still seeing these.

Mukesh•9/11/25, 7:28 AM

I have a use case where I need to connect my D1 database from outside worker, is there possibility to do that?
I searched on google but no luck.

lambrospetrou•9/11/25, 2:15 PM

Hey folks, for those that don't read changelogs, we documented the automatic retries we do for read-only queries. https://developers.cloudflare.com/changelog/2025-09-11-d1-automatic-read-retries/

This has been asked many times over the past few months, so we rolled out our first iteration in the past few weeks.
Read only queries are now retried automatically when the errors are retryable, so your app code should mostly retry idempotent write queries that you deem necessary, or if you want more than two retries that we are doing.

Read the changelog for the full details.

Cloudflare Docs

D1 automatically retries read-only queries

D1 now detects read-only queries and automatically attempts up to two retries to execute those queries in the event of failures with retryable errors.

Silvan•9/11/25, 2:26 PM

damn i just implemented auto retry it all my d1 projects

but nice change

Jun•9/11/25, 2:35 PM

Application-level retries are still recommended for idempotent queries (https://developers.cloudflare.com/d1/best-practices/retry-queries/)

Silvan•9/11/25, 4:43 PM

oh is that page new? never saw it before but good to know

Ehbraheem•9/11/25, 10:45 PM

@Jun I'm curious are the retried queris billable?

What I mean is, if I send a single read, and CF did a retry. Does that count as 2 reads in my bill

EEhbraheem @Jun I'm curious are the retried queris billable? What I mean is, if I send a ...

Larry•9/12/25, 12:42 AM

If it happens often enough to be detectable in your bill, you have bigger things to worry about.

Llambrospetrou Hey folks, for those that don't read changelogs, we documented the automatic ret...

James•9/12/25, 1:33 AM

This is an awesome addition to D1 :MeowHeartCloudflare:

EEhbraheem @Jun I'm curious are the retried queris billable? What I mean is, if I send a ...

lambrospetrou•9/12/25, 6:57 AM

Fair question we did think about. Short answer is that it should not happen in practice, although in theory it is possible.
There is a very rare case that attempt 1 executed on the underlying database, published stats about rows read/written, and then the response failed to be returned back to our D1 worker (what your code is calling through the D1 worker binding), so the worker will retry the query.
In our experience with the errors we see is that the vast majority of them is literally not even reaching the database in the first place (or failing before start execution), and the retries are meant to solve that problem mostly in case of transient errors. Also, if the response failed to come back to us, probably the retry will fail too since it is probably a network issue.

I haven't notice this being an issue in a few accounts I have been spot checking over the past few weeks, but please, if you do notice in your case some billing issue, let us know. We are still monitoring the retry success ratios and considering more improvements to do over time, so any feedback is welcome.

Remember, D1 is not billing on requests, but on actual rows read and written successfully.

Original message was deleted

lambrospetrou•9/12/25, 7:42 AM

I will ping the team about this. Is the beacon_minorbeacon_minor column newly added through the Studio or did it exist before you made changes through the Studio UI?

Original message was deleted

Visal .In•9/12/25, 7:55 AM

Could you provide the schema of your table?

Visal .In•9/12/25, 8:06 AM

I see. Trigger editor support is also on our roadmap for this month. Glad you figured it out! We’ll continue improving the studio experience, and please feel free to share here if you encounter any issues or have suggestions for specific areas of improvement.

Llambrospetrou Fair question we did think about. Short answer is that it should not happen in p...

Ehbraheem•9/12/25, 10:23 AM

Awesome, thank you @lambrospetrou for the detailed response

Perry•9/12/25, 1:29 PM

i m currently using cloudflare workers and Kv , and some other DB just for the sake of GUI, i would love to use Cloudflare D1 is there a way to have some GUI on D1??

PPerry i m currently using cloudflare workers and Kv , and some other DB just for the ...

Brayden•9/12/25, 1:34 PM

There is a Studio (SQL browser) interface inside of Cloudflare for D1. Click the blue "Explore data" button when inside a D1 instance, or the "..." menu next to an item in the resource list page when you first click D1 from the sidebar.

dev.itsarun•9/12/25, 9:28 PM

https://github.com/cloudflare/workers-sdk/issues/10638

Guys Please have a View and Share your Reactions ?

GitHub

Support Exporting D1 Data in JSON & CSV Formats with Encoding Optio...

Describe the solution Currently, wrangler d1 export supports exporting schema and data in SQL format only. It would be very helpful if wrangler could support alternative export formats such as JSON...

Original message was deleted

Praefe•9/12/25, 9:36 PM

Surely someones created a worker template for this by now

gruntlord6•9/13/25, 1:13 AM

I'm pretty sure sqlite can do that once you export the .sql

PPraefe Surely someones created a worker template for this by now

Brayden•9/13/25, 11:22 AM

I made one if you go to D1 in the dashboard there are templates on the right side where you can one click deploy.

You can also find it here: https://github.com/Brayden/d1-secret-rest

GitHub

GitHub - Brayden/d1-secret-rest: Fetch results or execute queries a...

Fetch results or execute queries against a D1 CRUD REST API - Brayden/d1-secret-rest

blyedev•9/14/25, 10:10 AM

HI Team I'm prototyping some very simple database running sql queries manually, it seems that on safari if the sql is long enough it overflows and the screen is not scrollable so i can only see the top part of the query itself not even the result.

blyedev•9/14/25, 10:11 AM

To be more precise only the summary is not scrollable the query result is perfectly fine. I think the query I executed may have resulted in an error as well, if that's relevant

Sb•9/14/25, 10:21 AM

Hello

The d1 pricing is based on rows read and write.

What if I read something but it does not result in any row (no row exist for that query in the db)

Will it be counted in the billing ???

maj•9/14/25, 11:16 AM

How are the SQL lower()lower() and upper()upper() supposed to work with non latin or accented characters? select lower('Édith Piaf');select lower('Édith Piaf'); returns "Édith piaf" - which obviously isn't lower case. Therefor many of my exact searches fail.

SSb Hello The d1 pricing is based on rows read and write. What if I read something...

Isaac McFadyen•9/14/25, 1:21 PM

What if I read something but it does not result in any row (no row exist for that query in the db)

Rows are still read to search for that row, so yes it will count.

Isaac McFadyen•9/14/25, 1:22 PM

Either a full table scan (which you should try to avoid as it reads every row and is also slow) or an index read (which is billed like a row read)

IIsaac McFadyen Either a full table scan (which you should try to avoid as it reads every row an...

Sb•9/14/25, 2:04 PM

Can you please explain with some example (using numbers) ?

1. I queried, but no matching row found. What will be the rows read value in it ??
2. I queried, 5 matched out of 1M, what will happen ?

SSb Can you please explain with some example (using numbers) ? 1. I queried, but no...

Isaac McFadyen•9/14/25, 2:10 PM

It's going to heavily depend on your queries and DB schema so we won't be able to give a concrete answer, you'll have to make the queries and check the metrics D1 returns.

Roman•9/14/25, 3:27 PM

i need some help with understanding how to access a d1 db binding in astro

Roman•9/14/25, 3:57 PM

okay i think i got it

SSb Can you please explain with some example (using numbers) ? 1. I queried, but no...

James•9/14/25, 4:34 PM

Rows retrieved has nothing to do with rows read.

JJames Rows retrieved has nothing to do with rows read.

Sb•9/14/25, 5:43 PM

So, doesn't it make the system little negative?

Because, to find the rows to be retrieved.
It must scan all the rows (read all the rows to see if they are valid for the query )

And it will exponentially grow the billing as the db grows.

Am I correct?

SSb So, doesn't it make the system little negative? Because, to find the rows to be...

Isaac McFadyen•9/14/25, 5:47 PM

It does not scan all the rows if you have an index on the rows.

Isaac McFadyen•9/14/25, 5:47 PM

In that case only the index will be searched (much fewer rows read)

Roman•9/14/25, 7:06 PM

why cant better-auth just work with d1

RRoman why cant better-auth just work with d1 😭

gruntlord6•9/15/25, 12:40 AM

it works with sqlite and drizzle so I imagine you can get it going

gruntlord6•9/15/25, 12:40 AM

I always used clerk though

SSb So, doesn't it make the system little negative? Because, to find the rows to be...

lambrospetrou•9/15/25, 8:00 AM

I suggest you do a read of this guide: https://developers.cloudflare.com/d1/best-practices/use-indexes/
D1 bills for rows read and written, not returned.
You can significantly decrease the amount of rows read for each query by using indexes and optimizing your queries to avoid scans of entire tables.
Using EXPLAIN <yourSQLquery>EXPLAIN <yourSQLquery> also helps you figure out what SQLite will do and see if you miss indexes.

BTW, most LLMs nowadays are really good with SQL and can tell you how to optimize your queries based on your schemas.

Cloudflare Docs

Use indexes

Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) the database has to scan when running a query.

If you’re just starting the project would recommend using the drizzle beta which should be stable in

Similar Threads

Similar Threads

Similar Threads