I can't seem to get drizzle to work with D1, funnily enough I believe I'm already failing at the con

BBefus I can't seem to get drizzle to work with D1, funnily enough I believe I'm alread...

D

I got it to work, it's what I am using.. although I think they have limited support. I tried using it, I get trouble with JOINs.. and other queries, I end up just using the regular

D

Denver James Duran•2/21/24, 2:05 PM

Here's what I did to make it work (I am using Sveltekit deployed via cloudflare pages)

//hooks.server.ts

import { drizzle } from 'drizzle-orm/d1';

const injectD1 = async (event: RequestEvent<Partial<Record<string, string>>, string | null>) => {
    try {
        if (event.platform?.env?.DATABASE) {
            event.locals.DRIZZLE = drizzle(event.platform.env.DATABASE);
            event.locals.D1 = event.platform.env.DATABASE;
        }
        ...
    } catch (error) {
        console.log('🚀 ~ file: hooks.server.ts:27 ~ consthandle:Handle= ~ error:', error);
    }
};

//hooks.server.ts

import { drizzle } from 'drizzle-orm/d1';

const injectD1 = async (event: RequestEvent<Partial<Record<string, string>>, string | null>) => {
    try {
        if (event.platform?.env?.DATABASE) {
            event.locals.DRIZZLE = drizzle(event.platform.env.DATABASE);
            event.locals.D1 = event.platform.env.DATABASE;
        }
        ...
    } catch (error) {
        console.log('🚀 ~ file: hooks.server.ts:27 ~ consthandle:Handle= ~ error:', error);
    }
};

//hooks.server.ts

import { drizzle } from 'drizzle-orm/d1';

const injectD1 = async (event: RequestEvent<Partial<Record<string, string>>, string | null>) => {
    try {
        if (event.platform?.env?.DATABASE) {
            event.locals.DRIZZLE = drizzle(event.platform.env.DATABASE);
            event.locals.D1 = event.platform.env.DATABASE;
        }
        ...
    } catch (error) {
        console.log('🚀 ~ file: hooks.server.ts:27 ~ consthandle:Handle= ~ error:', error);
    }
};

//hooks.server.ts

import { drizzle } from 'drizzle-orm/d1';

const injectD1 = async (event: RequestEvent<Partial<Record<string, string>>, string | null>) => {
    try {
        if (event.platform?.env?.DATABASE) {
            event.locals.DRIZZLE = drizzle(event.platform.env.DATABASE);
            event.locals.D1 = event.platform.env.DATABASE;
        }
        ...
    } catch (error) {
        console.log('🚀 ~ file: hooks.server.ts:27 ~ consthandle:Handle= ~ error:', error);
    }
};

MMax (@rozenmd)That's not the error you're getting though: `FOREIGN KEY constraint failed`

D

Denver James Duran•2/21/24, 2:45 PM

so apparently the product that has 0 price just so happen to have 0 id which does NOT exist on my database... reason why I am getting an error. thanks for this I was able to debug it

I

Ian•2/21/24, 3:22 PM

Does db backup count into the storage quota and charged by it or will it be a different pricing.

IIan Does db backup count into the storage quota and charged by it or will it be a di...

I

itsmatteomanf•2/21/24, 3:24 PM

Backup, as in this (https://developers.cloudflare.com/d1/reference/time-travel/) is included.

Cloudflare Docs

Time Travel and backups · Cloudflare D1 docs

Time Travel is D1’s approach to backups and point-in-time-recovery, and allows you to restore a database to any minute within the last 30 days.

C

Chinoman10•2/21/24, 3:25 PM

I'm not sure what's going on here... for one of our tables (the PRD one) the list of tables never loads (and after a while it shows the default "Your database was successfully created!").
For the Dev DB (half the size) it loads just fine...

CChinoman10 I'm not sure what's going on here... for one of our tables (the PRD one) the lis...

I

itsmatteomanf•2/21/24, 3:25 PM

Does the DB load fine in the list of dbs?

TThenerox hello can i connect to D1 using dbeaver or something like that?

C

Chinoman10•2/21/24, 3:27 PM

Supposedly there's a VS Code extension... but I tried and it didn't work.

Iitsmatteomanf Does the DB load fine in the list of dbs?

C

Chinoman10•2/21/24, 3:27 PM

Yes.

C

Chinoman10•2/21/24, 5:13 PM

So... I deployed this https://github.com/Momentum-Free/d1-manager/
And I get the exact same experience... I can load the Dev DB and the PRD one is just 'blank'.

C

Chinoman10•2/21/24, 5:19 PM

Basically it's always returning an internal server error (500)

C

Chinoman10•2/21/24, 5:21 PM

I know Pages & Workers are having issues currently, but this has been going on for at least 3 days now...

CChinoman10 I know Pages & Workers are having issues currently, but this has been going on f...

M

Max (@rozenmd)•2/21/24, 6:04 PM

whats your databaseId?

PPinheiro Is there any limit on server locations when using D1? I'm from Brazil and there'...

K

Kosicki•2/21/24, 10:27 PM

Any news on that? Looking forward to have better Brazil latency

MMax (@rozenmd)whats your databaseId?

C

Chinoman10•2/21/24, 10:50 PM

C

Chinoman10•2/21/24, 11:11 PM

https://media.discordapp.net/attachments/772180657169760276/1209999820924653598/image.png
Found the issue... I downloaded the "entire DB" (it's just 30MB) using another tool, and then I opened it locally... looks like one of the tables is corrupted somehow.

C

Chinoman10•2/21/24, 11:11 PM

happy to send the DB over if you need Max (although I guess you can get it from the ID)

C

Chinoman10•2/21/24, 11:13 PM

I'd also like to understand when/how the backups work... when does it decide that a backup should be done (previously it was doing them several times per day, now sometimes even entire weeks go by without one).

C

Cyb3r-Jak3•2/21/24, 11:19 PM

Is your database an alpha one? The output of

wrangler d1 info <dbname>

wrangler d1 info <dbname>

wrangler d1 info <dbname>

wrangler d1 info <dbname> will tell you

Original message was deleted

K

Kosicki•2/21/24, 11:27 PM

Yes, I saw that, but I meant if there's any news on having this presence in south america

CChinoman10 I'm not sure what's going on here... for one of our tables (the PRD one) the lis...

I

impairedFelon•2/22/24, 2:15 AM

Why does this gentleman have different options to me? For example, he has a backup section and I don't, and I have time travel and metrics and he doesn't.

IimpairedFelon Why does this gentleman have different options to me? For example, he has a back...

C

Cyb3r-Jak3•2/22/24, 2:16 AM

I believe he is using the old database backend

C

Cyb3r-Jak3•2/22/24, 2:17 AM

Which is slower and not really supported anymore

CCyb3r-Jak3 I believe he is using the old database backend

M

Max (@rozenmd)•2/22/24, 6:04 AM

this

RRicardas Hey is anyone else experiencing those errors: D1_ERROR: Cannot resolve D1 due to...

M

Max (@rozenmd)•2/22/24, 9:07 AM

What's the output of

wrangler d1 info <dbname>

wrangler d1 info <dbname>

wrangler d1 info <dbname>

wrangler d1 info <dbname> for that DB?

S

Sej•2/22/24, 9:38 AM

Hi, I need help with my DB. I tried to use the time travel feature to restore some data and now I can't access the DB at all. The status on the dashboard just says:

Failed to reach database. Please try again later.

Failed to reach database. Please try again later.

Failed to reach database. Please try again later.

Failed to reach database. Please try again later. and when trying to access the url, it says the DB has just been successfully created. Any tips?

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

M

Max (@rozenmd)•2/22/24, 9:39 AM

What's the databaseId?

S

Sej•2/22/24, 9:40 AM

Can I safely put it here?

SSej Can I safely put it here?

M

Max (@rozenmd)•2/22/24, 9:40 AM

Yes, it's not a secret

S

Sej•2/22/24, 9:40 AM

Its 1b99b448-40c1-4ba5-8808-2949e2e52779

SSej Its 1b99b448-40c1-4ba5-8808-2949e2e52779

M

Max (@rozenmd)•2/22/24, 9:46 AM

Looks like that database is indeed stuck - I've forwarded this to our internal team to take a look, though they're on US-time so might be a few hours before they can help

MMax (@rozenmd)Looks like that database is indeed stuck - I've forwarded this to our internal t...

S

Sej•2/22/24, 9:47 AM

Alright, thanks for the help!

RRicardas Not the nicest output here 🙂 but looks like this, i've omitted id and name ├──...

M

Max (@rozenmd)•2/22/24, 10:26 AM

I'll need the id to be able to look anything up about your database

RRicardas Hey is anyone else experiencing those errors: D1_ERROR: Cannot resolve D1 due to...

M

Max (@rozenmd)•2/22/24, 11:41 AM

and when you say high write rate, how many requests per second are we talking? >400?

K

Kosicki•2/22/24, 12:05 PM

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

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

M

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

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

K

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

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

M

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

I have no idea

T

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

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

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

M

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

are you using a view by any chance?

T

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

well no, i don't use that feature

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 == '');

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 == '');

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 = '')

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 = '')

T

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

but when i tried to

EXPLAIN QUERY PLAN

EXPLAIN QUERY PLAN

EXPLAIN QUERY PLAN

EXPLAIN QUERY PLAN

I can't seem to get drizzle to work with D1, funnily enough I believe I'm already failing at the con

Similar Threads

Similar Threads

Similar Threads