Is it possible to restore data for a specific table in a D1 database? It looks like we experienced s

Is it possible to restore data for a specific table in a D1 database? It looks like we experienced some data loss during the recent outage for a specific table.

TTory Is it possible to restore data for a specific table in a D1 database? It looks l...

lambrospetrou•6/16/25, 3:44 PM

It looks like we experienced some data loss during the recent outage for a specific table.

Can you elaborate on this please? Feel free to DM me with as much details as you can. The recent incident could not lead to data loss for D1 from everything we have seen so far. Only startups were impacted and some writes not going through potentially.

You can restore using the bookmark API but that's for the database as a whole, not individual tables.

Gagan Suie•6/16/25, 7:30 PM

did D1 dashboard just remove "Table" tab? and replace it with "Explore Data"?

astra•6/16/25, 7:30 PM

yeah the update just went live to me just now aswell.. some of my columns are missing unless i explicitly search for it

Gagan Suie•6/16/25, 7:31 PM

freaked me out because i was actively making changes and thought i purged my entire DB accidentally. so i restored and lost some data. T_T

Aastra yeah the update just went live to me just now aswell.. some of my columns are mi...

Brayden•6/16/25, 7:51 PM

Can you elaborate a bit on this one? This doesn't sound like expected behavior.

GGagan Suie freaked me out because i was actively making changes and thought i purged my ent...

gruntlord6•6/16/25, 9:08 PM

you can also restore back to before you restored it

gruntlord6•6/16/25, 9:08 PM

time travel is magical

alphem•6/16/25, 11:29 PM

I'm not sure if this is the place to post, but I am not a fan of the front end updates through the dashboard. The fact that I cannot easily see what tables populate the db is very frustrating. Please bring this back. The user interface had a few issues, but this is not better.

GGagan Suie did D1 dashboard just remove "Table" tab? and replace it with "Explore Data"?

gruntlord6•6/16/25, 11:41 PM

I don't have a tab for that, I have to go to the other menu

gruntlord6•6/16/25, 11:42 PM

not exactly what I meant when I said I preffered the other way, I meant I wanted that to show on the table tab

Aalphem I'm not sure if this is the place to post, but I am not a fan of the front end u...

Visal .In•6/17/25, 12:56 AM

What do you mean you can’t see which table is populating the database? Do you see the “Explore Data” button on the right side?

alphem•6/17/25, 12:57 AM

I see that well enough. My point is that I can't just see everything from the dashboard now. I have to open a new tab in order to see it.

alphem•6/17/25, 12:58 AM

It would be best if "explore data" was just a tab on the dashboard.

Aalphem It would be best if "explore data" was just a tab on the dashboard.

Visal .In•6/17/25, 1:04 AM

Got it. Now I understand what you mean. We’ll continue to improve it.

VVisal .In Got it. Now I understand what you mean. We’ll continue to improve it.

alphem•6/17/25, 3:18 AM

TY. Don't mean to complain overmuch, you guys have an amazing product here.

�

😈 Donkey 💫•6/17/25, 3:45 AM

the table tab has gone, why?

dsds10•6/17/25, 7:10 AM

great job on adding the new tables viewer! that's A LOT better

kd•6/17/25, 8:59 PM

Hi! I'm looking for some clarity on D1 cold starts. I have a ~600MB database in D1 right now which will mostly be used as a read-only DB, fronted by a Worker-based react-router website. I have not rolled it out into production yet, but the cold starts of ~5 seconds after every 5-10 minutes of idling makes wonder if I made a right choice for a low-traffic use case. I mean, if there is only a couple visitors an hour, they will all get these huge delays on some of the interactions where I very much preferred a 50ms response that's happening after

Are there any rough numbers of when the D1 goes to sleep and how much traffic should be there to avoid cold starts?

kd•6/17/25, 9:02 PM

I am querying D1 from separate react-router's "API" routes, which I believe should be bundled altogether in a single worker. The routes that do not touch D1 have like a 50ms ttfb, while routes that query D1 have this super long cold start

kd•6/17/25, 9:03 PM

the worst part is that while I was writing this message (~1-2 minutes), it happened again. The subsequent requests are all 40-50 ms though, so I'd assume it's not the heavy joins or something like this (I almost don't have any heavy sql queries)

Kkd Hi! I'm looking for some clarity on D1 cold starts. I have a ~600MB database in ...

lambrospetrou•6/17/25, 10:42 PM

The databases go to sleep after 1-2 minutes of inactivity (due to the underlying Durable Object hibernation/eviction).
So, in your case you will experience booting up the database all the time if you query once every 5-10 minutes.

Now, in theory, unless the underlying machine your database is hosted is bad all the time, your boots should be hot after the first one, and startups should be faster without needing to fetch from cold storage all the time. If you share your database ID/account ID I can double check to see the cold starts you were having.

Kkd I am querying D1 from separate react-router's "API" routes, which I believe sho...

gruntlord6•6/18/25, 12:26 AM

if you are using react router anyway you can easily add in durable objects if you want faster performance

gruntlord6•6/18/25, 12:27 AM

they made it very trivial with the new vite plugin

gruntlord6•6/18/25, 12:28 AM

you could also have your parent route ping the d1 instance when you start serving requests to keep it warm

Delchan•6/18/25, 10:07 AM

what

Ggruntlord6 you could also have your parent route ping the d1 instance when you start servin...

kd•6/18/25, 6:08 PM

this actually sounds like a quick and easy solution to keep it warm, thanks for the help! \

Kkd this actually sounds like a quick and easy solution to keep it warm, thanks for ...

gruntlord6•6/18/25, 7:16 PM

no problem, I use something similar to keep a websocket connection in a header

Dev•6/19/25, 5:43 AM

Are d1 procedures available to use? I could only find an article about it from 3 years ago

DDev Are d1 procedures available to use? I could only find an article about it from 3...

lambrospetrou•6/19/25, 6:06 AM

Nope. Not on the roadmap for now.

Llambrospetrou Nope. Not on the roadmap for now.

Dev•6/19/25, 6:30 AM

so there's no way to use transactions-like in d1?

DDev so there's no way to use transactions-like in d1?

lambrospetrou•6/19/25, 6:41 AM

If you mean interleaving JavaScript code and SQL within the same transaction, then not at the moment. You can execute multiple SQL queries in a single transaction using the batch()batch() function, though, if that fits your use-case.
Otherwise if you need a lot of JS mixed with SQL, using SQLite Durable Objects is more suitable.

karenr•6/20/25, 4:17 AM

Hi, when working on openNext. Is there a way to use the --remote flag to fetch the data? If not specifying the flag. Other ways that you have tried and worked?

I have a large dataset in production that I'd like to use in the frontend to display.

fare•6/22/25, 6:35 PM

wg d1 list

 ⛅️ wrangler 4.20.5
───────────────────

✘ [ERROR] A request to the Cloudflare API (/accounts/:id/d1/database) failed.

  Authentication error [code: 10000]


Getting User settings...
👋 You are logged in with an OAuth Token, associated with the email .
┌───────────────────────────────────┬──────────────────────────────────┐
│ Account Name                      │ Account ID                       │
├───────────────────────────────────┼──────────────────────────────────┤
│ Account Name                      │ Account ID                       │
└───────────────────────────────────┴──────────────────────────────────┘
🔓 Token Permissions: If scopes are missing, you may need to logout and re-login.
Scope (Access)
- account (read)
- user (read)
- workers (write)
- workers_kv (write)
- workers_routes (write)
- workers_scripts (write)
- workers_tail (read)
- d1 (write)
- pages (write)
- zone (read)
- ssl_certs (write)
- ai (write)
- queues (write)
- pipelines (write)
- secrets_store (write)
- offline_access 
🎢 Membership roles in "EMAIL": Contact account super admin to change your permissions.
- Super Administrator - All Privileges

wg d1 list

 ⛅️ wrangler 4.20.5
───────────────────

✘ [ERROR] A request to the Cloudflare API (/accounts/:id/d1/database) failed.

  Authentication error [code: 10000]


Getting User settings...
👋 You are logged in with an OAuth Token, associated with the email .
┌───────────────────────────────────┬──────────────────────────────────┐
│ Account Name                      │ Account ID                       │
├───────────────────────────────────┼──────────────────────────────────┤
│ Account Name                      │ Account ID                       │
└───────────────────────────────────┴──────────────────────────────────┘
🔓 Token Permissions: If scopes are missing, you may need to logout and re-login.
Scope (Access)
- account (read)
- user (read)
- workers (write)
- workers_kv (write)
- workers_routes (write)
- workers_scripts (write)
- workers_tail (read)
- d1 (write)
- pages (write)
- zone (read)
- ssl_certs (write)
- ai (write)
- queues (write)
- pipelines (write)
- secrets_store (write)
- offline_access 
🎢 Membership roles in "EMAIL": Contact account super admin to change your permissions.
- Super Administrator - All Privileges

Whenever i run this command I get this error
this does not happen for any other commands except d1 list

Mirith•6/23/25, 6:18 PM

If I'm just saving strings to my D1 database, how much sanitizing do I need to do?

MMirith If I'm just saving strings to my D1 database, how much sanitizing do I need to d...

deleted•6/23/25, 6:21 PM

if ur using prepared statements and passing the strings via parametrized bindings, i.e. bind(), then you should be good

Mirith•6/23/25, 6:21 PM

Yeah, that is what I'm doing

Ddeleted if ur using prepared statements and passing the strings via parametrized binding...

Mirith•6/23/25, 6:22 PM

This is exactly what I was hoping, thanks!

Deda•6/24/25, 4:09 AM

is anyone familiar with this error
✘ [ERROR] Failed to create temporary directory to store built files.

Disciple of Caoximeihao•6/24/25, 4:21 AM

Can someone tell me why row write is 6 rows in 1 statement?

DDisciple of Caoximeihao Can someone tell me why row write is 6 rows in 1 statement?

Praefe•6/24/25, 5:18 AM

Writing to columns referenced in an index will add at least one additional row written to account for updating the index.

Unsure how they calculate that, but one would be the index transaction above.

Got any other indexes on that table?

PPraefe > Writing to columns referenced in an index will add at least one additional row...

Disciple of Caoximeihao•6/24/25, 5:22 AM

all column in table: transactionId accountId amount note devices createdAt merchantId billId

Praefe•6/24/25, 5:37 AM

Yeah cool, so it’s writing to each of those indexes for each write you do. So that’s 5.

The other one idk, maybe into a transaction log or something.

MMikkel-T Hi, are there any docs as to which datatypes are available in D1?

Brayden•6/24/25, 1:16 PM

You can reference the SQLite data types: https://www.sqlite.org/datatype3.html

BBrayden You can reference the SQLite data types: https://www.sqlite.org/datatype3.html

lambrospetrou•6/24/25, 2:19 PM

Read https://developers.cloudflare.com/d1/worker-api/#type-conversion as well! Important since it gets some people off guard.

Cloudflare Docs

Workers Binding API

You can execute SQL queries on your D1 database from a Worker using the Worker Binding API. To do this, you can perform the following steps:

Silvan•6/25/25, 9:11 AM

I created some dbs in the dashboard yesterday. and i just realized all their locations are just wrong. i even gave it location hints (euw) and they all ended in america :(

SSilvan I created some dbs in the dashboard yesterday. and i just realized all their loc...

lambrospetrou•6/25/25, 9:20 AM

What account did you create this database in?

Llambrospetrou What account did you create this database in?

Silvan•6/25/25, 9:21 AM

id assume the one i have linked here on discord. unless i linked the wrong one lol

SSilvan id assume the one i have linked here on discord. unless i linked the wrong one l...

lambrospetrou•6/25/25, 9:23 AM

That's not a valid D1 UUID in the screenshot above. Can you DM me the UUID you get from the UI/API?

wg d1 list ⛅️ wrangler 4.20.5 ─────────────────── ✘ [ERROR] A request to the Cloudflare API (/accounts/:id/d1/database) failed. Authentication error [code: 10000] Getting User settings... 👋 You are logged in with an OAuth Token, associated with the email . ┌───────────────────────────────────┬──────────────────────────────────┐ │ Account Name │ Account ID │ ├───────────────────────────────────┼──────────────────────────────────┤ │ Account Name │ Account ID │ └───────────────────────────────────┴──────────────────────────────────┘ 🔓 Token Permissions: If scopes are missing, you may need to logout and re-login. Scope (Access) - account (read) - user (read) - workers (write) - workers_kv (write) - workers_routes (write) - workers_scripts (write) - workers_tail (read) - d1 (write) - pages (write) - zone (read) - ssl_certs (write) - ai (write) - queues (write) - pipelines (write) - secrets_store (write) - offline_access 🎢 Membership roles in "EMAIL": Contact account super admin to change your permissions. - Super Administrator - All Privileges

Is it possible to restore data for a specific table in a D1 database? It looks like we experienced s

Similar Threads

Similar Threads

Similar Threads