Hey @Max (@rozenmd) any dates planned to release D1 on South America? - Cloudflare Developers

© 2026 Hedgehog Software, LLC

More

Communities Docs About Terms Privacy

Kosicki

KKosicki Hey @Max (@rozenmd) any dates planned to release D1 on South America?

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 12:07 PM

Cloudflare doesn't give ETAs, but it'll come once DOs launch there

Kosicki

K

KosickiOP•2/22/24, 12:07 PM

Could you give a spoiler in terms of "this year", "in five years"? something like that?

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 12:10 PM

I have no idea

Tony Leung

T

Tony Leung•2/22/24, 1:59 PM

hi guys, it seems like D1 does not use any of my indexes

Tony Leung

TTony Leung hi guys, it seems like D1 does not use any of my indexes

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 1:59 PM

are you using a view by any chance?

Tony Leung

T

Tony Leung•2/22/24, 2:00 PM

well no, i don't use that feature

Tony Leung

T

Tony Leung•2/22/24, 2:01 PM

I've created an index like

CREATE INDEX project_tiktok_link_is_empty_idx ON project (tiktok_link IS NULL OR tiktok_link == '');

CREATE INDEX project_tiktok_link_is_empty_idx ON project (tiktok_link IS NULL OR tiktok_link == '');

Tony Leung

T

Tony Leung•2/22/24, 2:01 PM

and my query is like:

SELECT * FROM project WHERE id = '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

SELECT * FROM project WHERE id = '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

Tony Leung

T

Tony Leung•2/22/24, 2:01 PM

but when i tried to EXPLAIN QUERY PLANEXPLAIN QUERY PLAN

Tony Leung

T

Tony Leung•2/22/24, 2:02 PM

the result is this:

Screenshot_2024-02-22_at_9.01.54_PM.png

Tony Leung

T

Tony Leung•2/22/24, 2:02 PM

it only uses primary key index

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 2:02 PM

sqlite uses the best index where possible

Tony Leung

T

Tony Leung•2/22/24, 2:02 PM

i tried

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link IS NULL OR tiktok_link == '', id);

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link IS NULL OR tiktok_link == '', id);

Tony Leung

T

Tony Leung•2/22/24, 2:03 PM

and

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, id);

CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tiktok_link, id);

Tony Leung

T

Tony Leung•2/22/24, 2:03 PM

but none of them work

Tony Leung

T

Tony Leung•2/22/24, 2:03 PM

i'm aware that index is left-most so i also changed my condition order but none of them work

Tony Leung

T

Tony Leung•2/22/24, 2:04 PM

this table is large and this query is burning the rows readrows read

Max (@rozenmd)

MMax (@rozenmd)sqlite uses the best index where possible

Tony Leung

T

Tony Leung•2/22/24, 2:05 PM

well no more than one index will be used?

Sej

SSej Hi, I need help with my DB. I tried to use the time travel feature to restore so...

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 2:29 PM

can you try accessing the DB again?

F0rce

F

F0rce•2/22/24, 3:45 PM

I noticed the following error / was able to reproduce it https://github.com/cloudflare/workers-sdk/issues/3160#issuecomment-1943795347 - has this been deployed yet (because the error is still open)

F0rce

FF0rce I noticed the following error / was able to reproduce it <https://github.com/clo...

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 3:53 PM

It was released, where were you able to reproduce it?

Max (@rozenmd)

MMax (@rozenmd)It was released, where were you able to reproduce it?

F0rce

F

F0rce•2/22/24, 3:53 PM

D1 and using Drizzle.

F0rce

F

F0rce•2/22/24, 3:53 PM

so it could be an drizzle error / they didnt update their part yet

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 3:53 PM

D1 as in through a Worker, or via wrangler d1 execute?

F0rce

F

F0rce•2/22/24, 3:53 PM

through a worker

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 3:54 PM

using .raw().raw()?

F0rce

F

F0rce•2/22/24, 3:54 PM

I dont know what drizzle uses at the end, 1 sec let me check

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 3:54 PM

Oh, yeah they'd need to update on their end

F0rce

F

F0rce•2/22/24, 3:55 PM

probably they are not using .raw().raw()

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 3:55 PM

To include an array of column names in the results when using raw(), use raw({columnNames: true})raw({columnNames: true}).

F0rce

F

F0rce•2/22/24, 3:55 PM

ahhhh let me bump the issue on their end again, sorry for the false alarm

F0rce

F

F0rce•2/22/24, 3:55 PM

thanks for the fast answer

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:00 PM

Actually let me double check with the workerd team internally

F0rce

FF0rce ahhhh let me bump the issue on their end again, sorry for the false alarm

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:12 PM

It's on us actually, it's live in main but not released in the workerd package + workers-types

F0rce

F

F0rce•2/22/24, 4:13 PM

wait, so the fix has not been released yet ?

F0rce

F

F0rce•2/22/24, 4:13 PM

and thats probably why the issue is still open ?

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:13 PM

if you use raw directly, you're interacting with the live runtime, which has the fix

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:14 PM

we reopened that issue because the workers-types package hasn't been bumped yet

F0rce

F

F0rce•2/22/24, 4:14 PM

thats probably why it hasent been fixed in drizzle yet, because they wait for the types

F0rce

F

F0rce•2/22/24, 4:14 PM

as the latest comment in the issue states

F0rce

F

F0rce•2/22/24, 4:15 PM

then is there an ETA on when the package & types will be bumped ?

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:15 PM

I've nudged the workerd folks for a release

Tony Leung

TTony Leung and ```sql CREATE INDEX project_tiktok_link_is_empty_and_id_idx ON project (tikt...

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:31 PM

what if idid is first in your index?

Max (@rozenmd)

MMax (@rozenmd)what if `id` is first in your index?

Tony Leung

T

Tony Leung•2/22/24, 4:32 PM

sorry, my actual query is:

SELECT ... FROM project WHERE id < '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

SELECT ... FROM project WHERE id < '01HQ81GRDX539N2EJSW1ECGRMY' AND (tiktok_link IS NULL OR tiktok_link = '')

Tony Leung

T

Tony Leung•2/22/24, 4:33 PM

i've tried swapping the position of idid and the expression (tiktok_link IS NULL OR tiktok_link = '')(tiktok_link IS NULL OR tiktok_link = '')

Tony Leung

T

Tony Leung•2/22/24, 4:33 PM

both in the query and the index

Tony Leung

TTony Leung sorry, my actual query is: ```sql SELECT ... FROM project WHERE id < '01HQ81GRDX...

Max (@rozenmd)

M

Max (@rozenmd)•2/22/24, 4:33 PM

it's the less than

Tony Leung

T

Tony Leung•2/22/24, 4:33 PM

but none of them work

Tony Leung

T

Tony Leung•2/22/24, 4:34 PM

i've tried

SELECT ... FROM project WHERE (tiktok_link IS NULL OR tiktok_link = '') and id < '01HQ81GRDX539N2EJSW1ECGRMY'

SELECT ... FROM project WHERE (tiktok_link IS NULL OR tiktok_link = '') and id < '01HQ81GRDX539N2EJSW1ECGRMY'

i do aware that sqlite id <id < will not use other columns in the index after that