cloudflare D1 database with drizzle

[d1d4r]

Describe the problem

when init a new svelte project the CLI ask how u would like setup your new project.
this is great DX, but i think this would be better if you add cloudflare D1 and D1 driver with drizzle

Describe the proposed solution

| sveltekit-adapter: Which SvelteKit adapter would you like to use?
│ cloudflare
│
◇ sveltekit-adapter: Are you deploying to Workers (assets) or Pages?
│ Workers
drizzle: Which database would you like to use?
│ cloudflare D1
│
◇ drizzle: Which SQLite client would you like to use?
│ d1

Importance

would make my life easier

[sacrosanctic]

can you link to the packages and docs in question?

[d1d4r]

can you link to the packages and docs in question?

https://orm.drizzle.team/docs/connect-cloudflare-d1

https://developers.cloudflare.com/d1/

[sacrosanctic]

I can set it if if you can show me what the output files are supposed to look like

[d1d4r]

I can set it if if you can show me what the output files are supposed to look like

https://medium.com/full-stack-engineer/how-do-you-connect-drizzle-orm-to-a-cloudflare-d1-database-in-a-worker-1eff33177f73

you can look this

[sacrosanctic]

I don't know how D1 works, this guide is not specific to svelte, is it supposed to run in a worker? If you have a I can git diff from the template, that would be best.

[d1d4r]

I don't know how D1 works, this guide is not specific to svelte, is it supposed to run in a worker? If you have a I can git diff from the template, that would be best.

It's very straightforward and easy nothing special.

I'll create a simple project as soon as possible and i'll show you

[d1d4r]

@sacrosanctic

here is the demo

https://github.com/d1d4r/d1-demo

and feel free to ask question if u do not understand anything

[sacrosanctic]

@d1d4r can you explain why auth is now factory?

[d1d4r]

@d1d4r can you explain why auth is now factory?

Because D1 bindings are available via event.platform.env.DB, you cannot define auth at the top level of your file using a static db import.

[sacrosanctic]

does it matter whether you pick worker or pages?

drizzle: Which database would you like to use?
│ cloudflare D1
│
◇ drizzle: Which SQLite client would you like to use?
│ d1

is the second prompt necessary?