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

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

L

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.

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"

, then it created a migration file with name:

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"

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

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.

S

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

pretty sure you have to compile with a flag to get this but dosent really matter

D

Dio•6/29/25, 11:44 PM

Are embedded replicas planned? I mean something like turso.

DDio Are embedded replicas planned? I mean something like turso.

L

lambrospetrou•6/30/25, 11:27 AM

No plans at the moment. There are some other companies trying to do sync engines ontop of DOs, so if that fits your use-cases you might want to explore those. I haven't tried any personally, so cannot recommend specific ones.

Original message was deleted

L

lambrospetrou•6/30/25, 11:29 AM

is using 'first-primary' the equiv of using not using sessions api at all - even if i have replication enabled?

For the first call, yes, they are the same.

If you continue using the same session object though, your subsequent queries will potentially be processed by a replica that is at least up-to-date as your last read/write. If you don't use the sessions API ALL requests are going to the primary (treated as

first-primary

first-primary

).

if 'first-unconstrained' detects a write through sessions will it be upgraded to a primary, thus adding extra latency?

Yes, if a query is a write, we will automatically forward it to the primary for execution. It still flows through the replica location though, so there might be some extra latency (or not) depending on these locations.

Llambrospetrou > is using 'first-primary' the equiv of using not using sessions api at all - ev...

L

lambrospetrou•6/30/25, 11:31 AM

We have plans to make both the replicas placement better, and also to make the routing smarter so that if writes are detected in the query we send you straight to primary but it's still some time away from being released.

L

lambrospetrou•6/30/25, 12:47 PM

Hey folks, we released a small improvement last week for read replication and would love to get some feedback, or unexpected encountered issues.

Until last week, requests flowing through your replicas would wait for the replica to startup instead of using the primary until the replica is up and ready, which led to some latency increase for applications without constant traffic.
As of last week, requests now flow to the primary instance while replicas boot up, therefore latencies are expected to be better.

Keep in mind that if your application is doing less than 1 query per minute, your primary will most likely have to cold start often too, this didn't change, so in those cases you will anyway have the same latencies.

Please try it out and let us know if you encounter any issues or unexpected behavior.

Llambrospetrou Hey folks, we released a small improvement last week for read replication and wo...

Z

Zack•6/30/25, 12:53 PM

Awesome! I will give it another go and report back sometime this week

Llambrospetrou Hey folks, we released a small improvement last week for read replication and wo...

V

Vero•6/30/25, 1:21 PM

@D1 Database

Llambrospetrou > is using 'first-primary' the equiv of using not using sessions api at all - ev...

A

ajgeiss0702•6/30/25, 3:14 PM

this reminds me.

With the http api, does that work the same as querying from a workers without a session, consistency wise?
i know the http api adds additional latency, but thats not a huge issue with what im using it for. Consistency can be though

Basically, I'm writing to the d1 database from a service running outside of cloudflare, then reading it from workers (on cf pages)

please ping me if you reply

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

Similar Threads

Similar Threads

Similar Threads