I made a SvelteKit project but what I don't understand is how to work with D1 in development. I woul

Vveeque I made a SvelteKit project but what I don't understand is how to work with D1 in...

H

If you are using the Cloudflare Pages Adapter for SvelteKit, then it should be generating bindings for you in

pnpm dev

pnpm dev

if that is what you mean

HHello, I’m Allie!If you are using the Cloudflare Pages Adapter for SvelteKit, then it should be g...

V

veequeOP•8/17/24, 11:11 AM

In

src/routes/api/test/+server.ts

src/routes/api/test/+server.ts

src/routes/api/test/+server.ts

src/routes/api/test/+server.ts I have:

import type { RequestHandler } from '@sveltejs/kit';

export const GET: RequestHandler = async ({ request, platform }) => {
  const result = await platform?.env.db.prepare('SELECT * FROM users LIMIT 5').run();

  return new Response(JSON.stringify(result));
};

import type { RequestHandler } from '@sveltejs/kit';

export const GET: RequestHandler = async ({ request, platform }) => {
  const result = await platform?.env.db.prepare('SELECT * FROM users LIMIT 5').run();

  return new Response(JSON.stringify(result));
};

import type { RequestHandler } from '@sveltejs/kit';

export const GET: RequestHandler = async ({ request, platform }) => {
  const result = await platform?.env.db.prepare('SELECT * FROM users LIMIT 5').run();

  return new Response(JSON.stringify(result));
};

import type { RequestHandler } from '@sveltejs/kit';

export const GET: RequestHandler = async ({ request, platform }) => {
  const result = await platform?.env.db.prepare('SELECT * FROM users LIMIT 5').run();

  return new Response(JSON.stringify(result));
};

And in my

src/app.d.ts

src/app.d.ts

src/app.d.ts

src/app.d.ts:

declare global {
  namespace App {
    interface Platform {
      env: {
        db: D1Database;
      };
    }
  }
}

export {};

declare global {
  namespace App {
    interface Platform {
      env: {
        db: D1Database;
      };
    }
  }
}

export {};

declare global {
  namespace App {
    interface Platform {
      env: {
        db: D1Database;
      };
    }
  }
}

export {};

declare global {
  namespace App {
    interface Platform {
      env: {
        db: D1Database;
      };
    }
  }
}

export {};

(where does the

D1Database

D1Database

D1Database

D1Database type come from?)

but when running with

pnpm dev

pnpm dev

and I navigate to

localhost:5173/api/test

localhost:5173/api/test

localhost:5173/api/test

localhost:5173/api/test I get the following in the console:

TypeError: Cannot read properties of undefined (reading 'prepare')

TypeError: Cannot read properties of undefined (reading 'prepare')

TypeError: Cannot read properties of undefined (reading 'prepare')

TypeError: Cannot read properties of undefined (reading 'prepare'). If I build, then run

wrangler pages dev .svelte-kit/cloudflare --d1 db=[uuid-here]

wrangler pages dev .svelte-kit/cloudflare --d1 db=[uuid-here]

wrangler pages dev .svelte-kit/cloudflare --d1 db=[uuid-here]

wrangler pages dev .svelte-kit/cloudflare --d1 db=[uuid-here] the error is just because I haven't made the table, but would otherwise work.

I don't know about the binding it should be generating, because I don't seem to have any(?), but what also strikes me is that i can't just run

wrangler pages dev

wrangler pages dev

, but I have to specify both the folder and the

--d1

--d1

--d1

--d1 binding myself, despite this being my

wrangler.toml

wrangler.toml

file:

name = "[name-here]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[d1_databases]]
binding = "DB"
database_name = "prod-main"
database_id = "[uuid-here]"

name = "[name-here]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[d1_databases]]
binding = "DB"
database_name = "prod-main"
database_id = "[uuid-here]"

name = "[name-here]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[d1_databases]]
binding = "DB"
database_name = "prod-main"
database_id = "[uuid-here]"

name = "[name-here]"
compatibility_date = "2024-07-29"
pages_build_output_dir = ".svelte-kit/cloudflare"

[[d1_databases]]
binding = "DB"
database_name = "prod-main"
database_id = "[uuid-here]"

V

veequeOP•8/17/24, 11:13 AM

nevermind about the

--d1

--d1

--d1

--d1 thing, it works regardless of it

V

veequeOP•8/17/24, 11:14 AM

oh, maybe it solved itself after deleting node_modules and retrying

V

veequeOP•8/17/24, 11:29 AM

ok, the only real issue now is data not persisting between each

pnpm dev

pnpm dev

run. The documentation only tells me how to deal with this with

wrangler dev

wrangler dev

Vveeque ok, the only real issue now is data not persisting between each `pnpm dev` run. ...

H

Hello, I’m Allie!•8/17/24, 11:33 AM

Persistence should be enabled automatically. I don’t actually think you can disable it…

V

veequeOP•8/17/24, 11:36 AM

that made me check svelte's documentation. to show you all possible options for the adapter they give you a config with every value being used, and the

platformProxy.persist

platformProxy.persist

platformProxy.persist

platformProxy.persist was set to 'false'... and i just copy-pasted it all in a haste

H

Hello, I’m Allie!•8/17/24, 11:39 AM

Oh, that’ll do it

V

veequeOP•8/17/24, 11:39 AM

sorry for bothering you due to my stupidity

H

Hello, I’m Allie!•8/17/24, 11:39 AM

Though forgot that was exposed, tbh

Vveeque sorry for bothering you due to my stupidity

H

Hello, I’m Allie!•8/17/24, 11:39 AM

All good, you definitely aren’t alone on that front

V

veequeOP•8/17/24, 11:40 AM

just a question though, is it safe to put my wrangler.toml's config containing the database_id in the git history? is it kind of like an api token?

Vveeque just a question though, is it safe to put my wrangler.toml's config containing t...

H

Hello, I’m Allie!•8/17/24, 11:44 AM

Nope. Unless I have access to your account, then the ID is useless. In fact, everything in your

wrangler.toml

wrangler.toml

is safe to commit, assuming you are using secrets where appropriate

V

veequeOP•8/17/24, 11:44 AM

oh ok, that's nice

V

veequeOP•8/17/24, 11:44 AM

ty

V

veequeOP•8/17/24, 12:15 PM

@HardlyWorkin' how would i go about using the database outside of platform.env? (eg use drizzle) i tried looking everywhere but i just can't wrap my head around it

Vveeque @HardlyWorkin' how would i go about using the database outside of platform.env? ...

H

Hello, I’m Allie!•8/17/24, 12:20 PM

You construct the

drizzle

drizzle

instance with

platform.env.DB

platform.env.DB

platform.env.DB

platform.env.DB

V

veequeOP•8/17/24, 12:20 PM

but i have to do that for each api route?

V

veequeOP•8/17/24, 12:21 PM

don't i need to make one instance for the whole thing?

Vveeque but i have to do that for each api route?

H

Hello, I’m Allie!•8/17/24, 12:23 PM

You can construct one inside a Server Hook, but they need to be created fresh on each request

J

jacoblukewood•8/17/24, 12:57 PM

Hi, I'm using D1 in SvelteKit.

I want to prerender all of my pages because the content only needs to be updated occasionally (every few weeks), on build I want to fill in the content of my pages with the content in the DB.

I can't seem to get it to work with adapter-static or adapter-cloudflare because the platform.env.DB object isn't bound at build time. This happens both if I try building locally and on Cloudflare Pages.

Any advice?

Jjacoblukewood Hi, I'm using D1 in SvelteKit. I want to prerender all of my pages because the ...

H

Hello, I’m Allie!•8/17/24, 12:57 PM

Bindings like D1 are unfortunately not available at build time

J

jacoblukewood•8/17/24, 12:59 PM

Do you have any guidance on where I could go from here to be able to do a static build? The only thing I can think of is moving my svelte endpoints that access D1 to workers functions and calling those

HHello, I’m Allie!You can construct one inside a Server Hook, but they need to be created fresh on...

V

veequeOP•8/17/24, 1:17 PM

so it's fine if in a

+(*.)server.ts

+(*.)server.ts

+(*.)server.ts

+(*.)server.ts route i alway reinstantiate drizzle, right?

Vveeque so it's fine if in a `+(*.)server.ts` route i alway reinstantiate drizzle, right...

H

Hard@Work•8/17/24, 1:19 PM

Yeah, it's fine

Jjacoblukewood Do you have any guidance on where I could go from here to be able to do a static...

H

Hard@Work•8/17/24, 1:20 PM

You could make the queries via the D1 API? It's quite a bit slower, but I would think it is a bit easier than splitting up your app like that

V

veequeOP•8/17/24, 1:26 PM

if in my wrangler.toml file i put a

database_id

database_id

and a different

preview_database_id

preview_database_id

preview_database_id

preview_database_id (one is called

prod-main

prod-main

prod-main

prod-main the other

dev-main

dev-main

dev-main

dev-main, but in the file i have just

database_name = "prod-main"

database_name = "prod-main"

database_name = "prod-main"

database_name = "prod-main") will it still work?

V

veequeOP•8/17/24, 1:36 PM

also, migrations stored in the

migrations

migrations

folder don't get applied automatically if someone pushes a new sql file, right? if that's the case however, how can i disable that behaviour?

HHard@Work You could make the queries via the D1 API? It's quite a bit slower, but I would ...

J

jacoblukewood•8/17/24, 1:50 PM

great idea. thank you

Vveeque if in my wrangler.toml file i put a `database_id` and a different `preview_datab...

H

Hard@Work•8/17/24, 1:53 PM

In local mode?

Vveeque also, migrations stored in the `migrations` folder don't get applied automatical...

H

Hard@Work•8/17/24, 1:53 PM

I don't think there is a setting to have the automatically applied. I think you need to run the migrations yourself manually

X

X•8/17/24, 6:11 PM

h

O

Ottomated•8/18/24, 1:19 AM

Anyone know why BLOB fields return

number[]

number[]

number[]

number[] instead of

ArrayBuffer

ArrayBuffer

ArrayBuffer

ArrayBuffer? Seems weird because the docs show that they should map to ArrayBuffers.

FFini I ❤️ Cloudflare My production D1 has been down for 2 days and still no reply on ...

W

Walshy•8/18/24, 12:13 PM

what's your ticket id?

W

Walshy•8/18/24, 12:41 PM

I've escalated it to support to check on

S

shellsort•8/18/24, 3:16 PM

Using rusts prepare and all functions, I execute an sql statement in my scheduled worker using the --test-scheduled flag of wrangler and then running

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

curl "http://localhost:8787/__scheduled?cron=*+*+*+*+*"

to simulate a scheduled event instantly.

This returns an error:

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

Error: Error: D1_ERROR: no such table: image: SQLITE_ERROR - Cause: Error: D1_ERROR: no such table: image: SQLITE_ERROR

When executing the same statement via the REST API I get the expected result.

I tried wrapping the table name in ' ' marks, but get the same result.

Does anyone have an idea?
Yes it's the same database. Yes I double checked the table name.

S

shellsort•8/18/24, 3:18 PM

It's a really simple sql statement too. No joins or anything like that happening. Just good old select x from y when z.

S

shellsort•8/18/24, 4:04 PM

-> Fixed. Resolve was using the --remote flag/creating a local dev d1 db.

M

moonchav•8/18/24, 7:26 PM

is it possible to bind multiple D1 dbs to a single worker? And is it possible to bind a single D1 db to multiple workers?

Mmoonchav is it possible to bind multiple D1 dbs to a single worker? And is it possible to...

I

Isaac McFadyen•8/18/24, 7:26 PM

Yes and yes

I

Isaac McFadyen•8/18/24, 7:26 PM

Just bind it like normal in your wrangler.toml but specify multiple of them

M

moonchav•8/18/24, 7:27 PM

oh sweet, thank you! I should have just rolled the dice and tried it before asking

I

Isaac McFadyen•8/18/24, 7:27 PM

No problem :lul:

I made a SvelteKit project but what I don't understand is how to work with D1 in development. I woul

Similar Threads

Similar Threads

Similar Threads