I am querying D1 from separate react-router's "API" routes, which I believe should be bundled altog

K

kdOP•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 ...

L

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...

G

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

G

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

they made it very trivial with the new vite plugin

G

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

D

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

what

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

K

kdOP•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 ...

G

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

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

D

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...

L

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

Nope. Not on the roadmap for now.

Llambrospetrou Nope. Not on the roadmap for now.

D

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?

L

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()

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.

K

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.

F

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

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

M

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...

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

M

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...

M

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

This is exactly what I was hoping, thanks!

D

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

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

D

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?

P

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...

D

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

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

P

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?

B

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

L

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:

S

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...

L

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

What account did you create this database in?

Llambrospetrou What account did you create this database in?

S

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...

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?

Llambrospetrou That's not a valid D1 UUID in the screenshot above. Can you DM me the UUID you g...

S

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

wait how? its the exact same i have in the dashboard

S

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

cc6ec804-ca57-43ba-b61d-a807523851ca

SSilvan wait how? its the exact same i have in the dashboard

L

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

Weird. The mac image to text got it right but added an invalid invisible character...

S

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

yea it does that often x)

btw its fine theres no data on it yet really i can recreate it until its in europe. just wanted to give the feedback

SSilvan yea it does that often x) btw its fine theres no data on it yet really i can re...

L

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

From what I see, the location hint that came through to the D1 API was WNAM

S

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

hm weird. maybe i did click the wrong one afterall

SSilvan hm weird. maybe i did click the wrong one afterall

L

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

I created one in WEUR in the dashboard and it works, so maybe it was a misclick indeed. If you manage to reproduce it let us know, though, to dig deeper.

S

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

yea very well possible i just read west and clicked it. thanks for checking anyway!

A

ajgeiss0702•6/26/25, 12:30 AM

it looks like the new database studio thing removes newlines from strings when editing them

Aajgeiss0702 it looks like the new database studio thing removes newlines from strings when e...

B

Brayden•6/26/25, 12:38 AM

We'll investigate this

Aajgeiss0702 it looks like the new database studio thing removes newlines from strings when e...

V

Visal .In•6/26/25, 1:14 AM

At the moment, the studio hasn't implemented the multiple line editor yet. It is on our upcoming roadmap. Can expected it in the next 2 weeks.

S

silversoul•6/26/25, 3:20 PM

I just created my first d1 migration and I ran

wrangler d1 migrations create my-db "Migration message"

wrangler d1 migrations create my-db "Migration message"

wrangler d1 migrations create my-db "Migration message"

wrangler d1 migrations create my-db "Migration message", then it created a migration file with name:

0NaN_<message>

0NaN_<message>

0NaN_<message>

0NaN_<message> like this. Anyone else have this issue ?

wrangler 4.22.0 / typescript

S

silversoul•6/26/25, 3:23 PM

oooh, it seems that removing

"migrations_table"

"migrations_table"

"migrations_table"

"migrations_table" in wrangler.jsonc fixed it

J

jLynx•6/26/25, 10:48 PM

@Walshy seem to be getting massive timeouts on our D1 database via functions

J

jLynx•6/26/25, 10:48 PM

unsure if this is a D1 outage or pages outage

J

jLynx•6/26/25, 11:00 PM

seems to be fine now

S

Samantas5855•6/28/25, 4:16 PM

Other than

json

json

json

json what other datatypes are there

S

Silvan•6/28/25, 8:22 PM

its not a datatype but we do have the json extension https://developers.cloudflare.com/d1/sql-api/query-json/

Cloudflare Docs

Query JSON

D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:

S

Silvan•6/28/25, 8:36 PM

The SQLite JSON extension ↗, on which D1 builds on, has additional usage examples.

The SQLite JSON extension ↗, on which D1 builds on, has additional usage examples.

The SQLite JSON extension ↗, on which D1 builds on, has additional usage examples.

The SQLite JSON extension ↗, on which D1 builds on, has additional usage examples.

I am querying D1 from separate react-router's "API" routes, which I believe should be bundled altog

Similar Threads

Similar Threads

Similar Threads