Cloudflare Developers•6mo ago

Yes

mrcubiOP•7/24/25, 12:25 PM

Silvan•7/24/25, 12:25 PM

?billing

SuperHelpflare•7/24/25, 12:25 PM

Cloudflare's billing system is undergoing some changes/migration. During this period, you may notice extra bills, incorrect bills, or other issues.

To resolve these issues, create a Support ticket by using the following link (you must be logged into your Cloudflare account): https://dash.cloudflare.com/?to=/:account/support

Note that all accounts, even Free plan accounts, can create billing tickets. Tickets are the only way to resolve billing issues; we cannot help you in this Discord.

Silvan•7/24/25, 12:25 PM

best to ask them then

< Sun8ox />•7/24/25, 6:23 PM

Hi, I have a question, how do I use Astro with D1 using bindings? (how do I access database binding) Im searching anywhere for any good documentation but cant find any. Nothing really works.

<< Sun8ox />Hi, I have a question, how do I use Astro with D1 using bindings? (how do I acce...

Silvan•7/24/25, 7:24 PM

you need the cloudflare adapter. rest can be found here https://docs.astro.build/en/guides/integrations-guide/cloudflare/#cloudflare-runtime

Docs

@astrojs/cloudflare

Learn how to use the @astrojs/cloudflare adapter to deploy your Astro project.

SSilvan you need the cloudflare adapter. rest can be found here https://docs.astro.build...

< Sun8ox />•7/24/25, 7:31 PM

thanks

Mmrcubi Yes

1984 Ford Laser•7/25/25, 1:17 PM

Line items on invoices don't show the included quota with your plan. So you actually used 25+37billion rows

1984 Ford Laser•7/25/25, 1:17 PM

Best to check D1 metrics via GraphQL API to dig deeper

George•7/25/25, 6:42 PM

Hi, may I ask for some help?
So I'm using worker with D1 just fine and want to utilize the Read replication feature. I changed my worker code of

SELECT

SELECT

statements to use env.DB.withSession() but get this error:

[UNKNOWN_ERROR] POST /login: Error: Cannot read properties of undefined (reading 'withSession')Internal cause: N/A
Stack: TypeError: Cannot read properties of undefined (reading 'withSession')
at index.js:3007:28
at async dispatch (index.js:929:17)
at async cors2 (index.js:3204:5)
at async dispatch (index.js:929:17)
at async logger2 (index.js:2495:5)
at async dispatch (index.js:929:17)
at async index.js:1773:26

I confirm I've enabled Read replicationRead replication in the D1 setting, any clue what's wrong?
btw I'm using hono.dev framework but I don't think it's related. Thanks

James•7/26/25, 1:39 PM

Can you share your full code and a way to reproduce? From that error,

env.DB

env.DB

is undefined.

Pepper•7/26/25, 3:18 PM

I was trying to add rows to my table and I somehow ended up with 6 rows that all have the same value for the primary key, which I didn't think was possible. The issue is that I am now unable to edit any of them. Whenever I make edits in the cloudflare d1 studio they all get reverted when I refresh the table (I am hitting save changes). Deleting the rows also doesn't work, they all reappear when I refresh the table. Does anyone know how I can get rid of these rows? Thanks.

Pepper•7/26/25, 3:28 PM

I think that part of the issue is that when I try to run an sql query selecting by the duplicate primary key it returns no results. But when I select * all of the duplicates appear. So when the d1 studio is trying to make delete requests it isn't able to delete anything because it isn't finding anything

Pepper•7/26/25, 3:34 PM

Since my primary keys were numbers, I was able to fix the problem and delete all of the duplicates by doing:
WHERE primary_key > 499
instead of:
WHERE primary_key = 500

Larry•7/26/25, 5:18 PM

I'm still more than simply curious to understand how an impossible thing happened. Can you run, PRAGMA table_info(table_name)PRAGMA table_info(table_name) and show us the output? I'm wondering if the table was originally created with a different primary key and changed your code to something like, CREATE TABLE IF NOT EXISTS...CREATE TABLE IF NOT EXISTS... with the primary key that you now think is the primary key but it actually isn't.

LLarry I'm still more than simply curious to understand how an impossible thing happene...

James•7/26/25, 5:19 PM

definitle not default behavior, messing w the key / rowid / pragma settings could get you there

LLarry I'm still more than simply curious to understand how an impossible thing happene...

Pepper•7/26/25, 6:27 PM

Here is the output (num is what I expected the primary key to be, in my earlier message I wrote primary_key just for the example). It originally happened when I used d1 manager to add rows to the table but didn't enter any values. But I was able to replicate this by doing:
INSERT INTO queue DEFAULT VALUES;
What that query does for me is insert everything as null except for the primary key, which it sets to be equal to the largest primary key in my database.

Larry•7/26/25, 7:11 PM

Ohh, I remember that bug in SQLite that allows null primary key values unless you create the table with that column set to

NOT NULL

NOT NULL

. https://sqlite.org/quirks.html#primary_keys_can_sometimes_contain_nulls

Larry•7/26/25, 7:20 PM

Wait, I'm still confused...

The value of an INTEGER PRIMARY KEY column must always be a non-NULL integer because the INTEGER PRIMARY KEY is an alias for the ROWID. If you try to insert a NULL into an INTEGER PRIMARY KEY column, SQLite automatically converts the NULL into a unique integer.

Ddandoen if only there was a way – as a work around – to do point in time recovery of a d...

dandoen•7/28/25, 8:33 AM

hi all, are there any cloudflare PMs that can shed some light whether this is something on the roadmap for this year? feels fairly important to be able to export a d1 db without blocking all reads/writes.

Original message was deleted

dandoen•7/28/25, 11:12 AM

thanks nora, just worried to go down this path w/ some of my d1 instances being fairly large (and the upperl imit being 10gb)

Ddandoen thanks nora, just worried to go down this path w/ some of my d1 instances being ...

gruntlord6•7/28/25, 3:39 PM

Reading your data is pretty straightforward so you shouldn't really have any issues with checking the integrity of your copy etc. I prefer the d1 dump but the file lock is a big downside for production data

Ggruntlord6 Reading your data is pretty straightforward so you shouldn't really have any iss...

dandoen•7/28/25, 3:43 PM

yeah i don't really see it being feasible for my use case mentioned earlier in the thread; i want to export it and use it in duckdb to power a few analytics heavy queries. i don't need real time, but something like per hour snapshots is what i'm looking to do. exporting by manually reading every row on every table i have is sure possible but a) costly and b) can't achieve fresh enough analytics (as i suspect the exports in this way would take hour+ when applied to a 10gb size db)

really eager to get some guidance from anyone at CF to see if this is something actually in the works for the remainder of this year. multiple docs mention there's but this d1 channel seems abandoned from PM perspective compared to the other channels

gruntlord6•7/28/25, 3:47 PM

Isn't it the same amount of reads to dump the entire database?

gruntlord6•7/28/25, 3:49 PM

D1 isn't abandoned, they just launched read replication the other month. Both d1 and durable objects are actively developed and share a lot of backend technology with each other (d1 is based on durable objects and durable objects use SQL storage based on d1)

dandoen•7/28/25, 4:35 PM

ah i mean this channel, not the product

depends on the implementation on the backend i suppose. in the way i understand how the sqlite instances are stored in a DO (largely based on this), i imagine it would be easier to save the d1 row in its entirety to "cold" storage (which essentially r2 would be) than to first read it to in memory, then iterate over each row in the db, export it etc.

Ddandoen yeah i don't really see it being feasible for my use case mentioned earlier in t...

lambrospetrou•7/28/25, 4:59 PM

Exports and some form of cloning a D1/DO DB's data into a separate D1/DO are on our roadmap. Other priorities unfortunately pushed them out of the past two quarters, but I am hoping that we will get to them by end of the year.
This is not a promised ETA, just to be clear, but it's been on our roadmap since the start of the year, just pushed down due to other things.

Llambrospetrou Exports and some form of cloning a D1/DO DB's data into a separate D1/DO are on ...

James•7/28/25, 5:56 PM

This is definitey something i'm highly interested in for DOs.

my strategy up to now is to send key events to an analytics store outside CF for cross DO analytics, but it would be a big plus to run the heavy stuff against an offline store.

JJames This is definitey something i'm highly interested in for DOs. my strategy up to...

dandoen•7/28/25, 10:04 PM

understood, thx @lambrospetrou . helps plan ahead architecturally knowing this is tracked and will make it in soon enough. thx!

Ddandoen ah i mean this channel, not the product 🙂 depends on the implementation on the ...

gruntlord6•7/28/25, 10:30 PM

That's actually the approach I take right now in my app that needs to backup user durable objects. We have a daily alarm that each durable object uses to dump itself to r2

Mmrbarletta Can't even delete the table using the UI 😐

lambrospetrou•7/30/25, 8:55 AM

Where did you get that error? From the REST API, from the Worker binding, through some other library/framework? That doesn't seem like something D1 throws. There wasn't an incident or service issue in D1 either.

Dean•7/30/25, 9:58 AM

is d1 replication relatively stable now? i've put off trying it after a few had some issues originally

DDean is d1 replication relatively stable now? i've put off trying it after a few had ...

lambrospetrou•7/30/25, 11:07 AM

There have been several bugfixes shipped over the past few months since the initial release, so more folks stress testing it would be great. Apart from improvements we have on the roadmap there isn't any active issue right now that should scare you off.
As always with any major feature, my suggestion is to first roll it out in your staging/test environment to make sure your use of the Sessions API is correct and you see replica usage, and then to production. Since, simply enabling replication should still work without using Sessions API, but you will start to be proxied by the nearest replica.

Please send us feedback or details if you find something not working as expected.

Llambrospetrou There have been several bugfixes shipped over the past few months since the init...

Dean•7/30/25, 11:08 AM

Will do! Thanks

Dean•7/30/25, 11:13 AM

Does it work on pages or is it only workers? I haven’t migrated everything over to workers yet

Noobie☺•7/30/25, 11:38 AM

hi. i need help with monorepo setup(https://github.com/waptik/woym-template). i have a packages/dbpackages/db where a
wrangler.jsonc
wrangler.jsonc
with d1 bindings is present(without app name), and a apps/serverapps/server with another
wrangler.jsonc
wrangler.jsonc
with d1 bindings and app name.
I use the db package to perform operations in packages/apipackages/api(orpc) which is attached to the server app. In my web app, i was trying to perform some queries(todos and authentication with better-auth) but was getting internal error code with some logs saying the table could not be found which was weird. after days of debugging, i just found out that a local db file also being created inside apps/server/.wranglerapps/server/.wrangler. so wrangler was using the local db inside the server directory instead of the one in db.

How do i make wrangler in server use the local db from packages/dbpackages/db instead?

UPDATE: i figured it by using --persist-to--persist-to flag like this "dev": "wrangler dev --persist-to ../../packages/db/.wrangler/state""dev": "wrangler dev --persist-to ../../packages/db/.wrangler/state"

DDean Does it work on pages or is it only workers? I haven’t migrated everything over ...

lambrospetrou•7/30/25, 12:20 PM

As long as you use the D1 Binding from your worker, or Pages function, it should work.

Reed Hewitt•7/30/25, 7:10 PM

Hello, I have run into an issue with tables that reference each other. I need to change column constraint on table X, which happens to have foreign key constraints pointing to tables Y and Z. Y and Z also have constraints pointing to table X. I used to be able to create a new version of the table named X_new, copy the data over from the original X, rename the original X to X_old and rename X_new to X. That would all happen in one transaction with PRAGMA defer_foreign_keys = truePRAGMA defer_foreign_keys = true. I could then confirm that all data was identical between X and X_old, then drop X_old. But now this doesn't work and I get the error FOREIGN KEY constraint failed: SQLITE_CONSTRAINT [code: 7500]FOREIGN KEY constraint failed: SQLITE_CONSTRAINT [code: 7500]. I see that D1 now updates the references on Y and Z so that they point at X_old instead of the newly created version of X. If I do the same copy/rename trick on Y and Z, then my new X ends up referencing Y_old and Z_old. I can't figure out how to get a clean reset with the new X, Y, and Z pointing to each other and nothing pointing to the old tables so that they can be deleted. Is there a way to disable the auto-renaming of foreign key constraints so that the previous behavior would work?

Reed Hewitt•7/30/25, 7:29 PM

Ok, I figured it out... I have to create new versions of the tables that reference each other by their new names (X_new, Y_new, Z_new). After creating all the new tables, then I do all the data copying. Then rename everything (old and new). The new versions of the tables will follow the renaming of each other. That allows the old versions of the tables to be dropped, because none of the new tables hold on to renamed foreign key constraints pointing to them.

James•7/30/25, 8:47 PM

sounds like a modeling problem more than a database constraint problem

WTDawson9•7/31/25, 12:30 PM

I wish this was called D2-database instead so we could have R2D2

WTDawson9•7/31/25, 12:31 PM

https://tenor.com/view/scream-gif-14892509196082257073

Tenor

dvddvd300•7/31/25, 6:58 PM

hi, i have multiple d1 DB, but 1 primary, with +5GB of data, in the list of dbs shows as 1gb, and also in billing, but in the actual stats for the db shows as 5.3GB, i don't know what number to believe i hope its the 5.3gb and the billing is giving free +4gb, but the 1gb number scares me if some data was lost

Robert•8/1/25, 3:27 PM

Is there a way to enforce my Worker function has read-only access to data stored in D1 on an API/network level?
I don't think there is, but wanted to confirm

RRobert Is there a way to enforce my Worker function has read-only access to data stored...

Larry•8/1/25, 5:30 PM

You are correct. No way to do it directly. You could proxy it through another worker where you did that or you could use a DO and save a network hop compared to the Worker only proxy

RRobert Is there a way to enforce my Worker function has read-only access to data stored...

Larry•8/1/25, 5:33 PM

D1 is implemented in DO so that approach would be just as efficient but it’s more work for you and you lose read replication

Yes

Similar Threads