> Writing to columns referenced in an index will add at least one additional row written to account

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

PraefeOP•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?

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

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

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

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

cc6ec804-ca57-43ba-b61d-a807523851ca

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

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

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

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

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

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

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

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.

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

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

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

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

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.

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

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

oooh, it seems that removing

"migrations_table"

"migrations_table"

in wrangler.jsonc fixed it

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

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

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

unsure if this is a D1 outage or pages outage

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

seems to be fine now

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

Other than

json

json

what other datatypes are there

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:

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.

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

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

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.

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

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

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.

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

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

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

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

Aajgeiss0702 this reminds me. With the http api, does that work the same as querying from a ...

lambrospetrou•6/30/25, 4:06 PM

The HTTP API does not use Sessions API for now, so all queries go to the primary.
BTW, the latency for queries has improved a lot a few weeks ago so it's not far off from the Workers Binding (still a bit slower though).

ajgeiss0702•6/30/25, 4:06 PM

got it, thanks

SnowBall•6/30/25, 11:29 PM

huh

Original message was deleted

lambrospetrou•7/1/25, 8:41 AM

Yeah, this should work. Read more at https://developers.cloudflare.com/d1/worker-api/d1-database/#batch
Let us know if you find sometihng not working as expected.

Keep in mind the first-unconstrainedfirst-unconstrained means a replica will most likely process the query.

Jumaron•7/1/25, 5:16 PM

How many queries do i need until the read replicas kick in, i still have 0 :/
Using similiar code like quankitt3 from above.
platform.env.DB.withSession(first-unconstrained);
Tried even with bookmarks but sadly nothing works.
Is there a requirement one needs to hit?