https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/ https://github.com/elithrar/svelte-d

https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/
https://github.com/elithrar/svelte-demo-d1

CCyb3r-Jak3 https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/ https://github.c...

schwartzmj•8/31/23, 12:47 AM

At a glance, it looks like these only work in production. I can't seem to find examples that include the local dev setup / workflow. Apologies if I missed anything in either of those examples from my phone here. Plan to research and look more when I get back

Sschwartzmj At a glance, it looks like these only work in production. I can't seem to find e...

Cyb3r-Jak3OP•8/31/23, 12:49 AM

The docs are in production but you basially use the pages dev command locally with a D1 binding and it will run locally

Sschwartzmj At a glance, it looks like these only work in production. I can't seem to find e...

Dahoom•8/31/23, 12:58 AM

The only way it can work locally is if you build it after each new change running

npm run build

npm run build

and then running wrangler pages dev .svelte-kit/cloudflarewrangler pages dev .svelte-kit/cloudflare

Dahoom•8/31/23, 12:58 AM

Make sure you have included your d1 binding on wrangler.toml so it can use the local d1 you have

DDahoom The only way it can work locally is if you build it after each new change runnin...

schwartzmj•8/31/23, 1:00 AM

Does this cause issues with HMR? I'll test this out in a bit

Dahoom•8/31/23, 1:01 AM

It's not possible with HMR

Dahoom•8/31/23, 1:01 AM

That's the issue

Dahoom•8/31/23, 1:01 AM

I'll give you my npm command you can use after each new change though

Dahoom•8/31/23, 1:03 AM

in package.json I have this for scripts:

        "scripts": { 
                 "dev": "wrangler pages dev .svelte-kit/cloudflare --local", 
                 "live": "vite build -w", 
                 "build": "run.bat & vite build",

        "scripts": { 
                 "dev": "wrangler pages dev .svelte-kit/cloudflare --local", 
                 "live": "vite build -w", 
                 "build": "run.bat & vite build",

Dahoom•8/31/23, 1:04 AM

This is the contents of run.bat:

rmdir /s /q .svelte-kit\cloudflare

rmdir /s /q .svelte-kit\cloudflare

Dahoom•8/31/23, 1:05 AM

run.bat is used as a workaround and sometimes I had an issue where the cloudflare build file is not fully cleared each time I wanted to run the pages local build

DDahoom run.bat is used as a workaround and sometimes I had an issue where the cloudflar...

schwartzmj•8/31/23, 1:05 AM

Ok thank you! I'll try this all out. Really appreciate it

Dahoom•8/31/23, 1:07 AM

no problem, @ me with a question if you had any because there isn't much documentation regarding this aspect and I had to work most of it out myself

addison•8/31/23, 2:12 AM

Hey, does D1 have FTS now? I haven't checked it out since open alpha launched

Aaddison Hey, does D1 have FTS now? I haven't checked it out since open alpha launched

Dahoom•8/31/23, 3:02 AM

What's FTS?

DDahoom What's FTS?

addison•8/31/23, 3:15 AM

Full Text Search

Aaddison Hey, does D1 have FTS now? I haven't checked it out since open alpha launched

Max (@rozenmd)•8/31/23, 5:54 AM

yes

riskiidrus•8/31/23, 8:19 AM

Hi, I wanted to ask about the reliability of D1 in case I ever need to add a new column to a large table.

Let's assume I have a "users" table containing 1 million rows. One time I wanted to add a new column to the table. Is the process as fast as I imagined?

Although I have never experienced something like that before, I will definitely experience it someday. And it's probably not just me.

Rriskiidrus Hi, I wanted to ask about the reliability of D1 in case I ever need to add a new...

itsmatteomanf•8/31/23, 8:22 AM

Adding a column, which is empty at the start, is very fast on any SQL database.

itsmatteomanf•8/31/23, 8:22 AM

You'll then need to do up to a million writes to fill it.

riskiidrus•8/31/23, 8:29 AM

Thank you for your answer. I was very relieved to hear that.

But when can we use D1 for production? I'm really looking forward to it

Elliot Hesp•8/31/23, 9:30 AM

Does anyone know how you're supposed to run Drizzle Kit migrations on D1? https://orm.drizzle.team/kit-docs/quick

Elliot Hesp•8/31/23, 9:31 AM

No issues making the migration, but I'm not sure how it's going to connect to the DB outside of the wrangler / fetch handler

Elliot Hesp•8/31/23, 9:40 AM

Got it: https://sat0shi.dev/posts/drizzle-migration/

Type-Safely database migration on Cloudflare D1 with Drizzle ORM

Drizzle Kit allows you to easily migrate your database schema on Cloudflare D1.

itsmatteomanf•8/31/23, 10:39 AM

I'm not sure there is a way, but can you get the keys from a JSON object within D1? I know I can get the values, but not sure about the keys.

Iitsmatteomanf I'm not sure there is a way, but can you get the keys from a JSON object within ...

Isaac McFadyen•8/31/23, 10:40 AM

https://stackoverflow.com/questions/70759212/select-distinct-keys-from-a-json-column-in-sqlite not sure if D1 exposes them specifically but SQLite's JSON1 allows for it.

Stack Overflow

select distinct keys from a json column in SQLite

a TEXT column of a SQLite database contains json values like these one:
[{"key1":"116"},{"key2":"260"},{"key3":"123"},{"key4":&...

itsmatteomanf•8/31/23, 10:40 AM

Oh, that looks promising.

Matt Silverlock•8/31/23, 11:25 AM

json_eachjson_each - https://developers.cloudflare.com/d1/learning/querying-json/#supported-functions

Query JSON · Cloudflare D1 docs

D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:

MMatt Silverlock `json_each` - https://developers.cloudflare.com/d1/learning/querying-json/#suppo...

itsmatteomanf•8/31/23, 11:43 AM

Yeah, that one above worked

I didn’t think it returned the key, too. It works, it’s not the fastest but it’s 10s of keys on tens of thousands of rows

itsmatteomanf•8/31/23, 11:44 AM

@rozenmd adding to the request for indexes, maybe show views, too

Epailes•8/31/23, 12:10 PM

Are there any examples of a popular CMS setup with D1 yet?

EEpailes Are there any examples of a popular CMS setup with D1 yet?

Cyb3r-Jak3OP•8/31/23, 1:24 PM

I mean someone made a CMS on workers https://discord.com/channels/595317990191398933/783765338692386886/1133082793962909846

CCyb3r-Jak3 I mean someone made a CMS on workers https://discord.com/channels/59531799019139...

Epailes•8/31/23, 3:10 PM

Ooh I'd missed that post thanks for sharing!
Was mainly looking to see if there was a full CMS, not headless, but interesting read none the less!

Unsmart•8/31/23, 5:53 PM

It wont be removed just higher 100s of GBs. Can probably do a search and find the messages about it specifically

Unsmart•8/31/23, 5:57 PM

I mean D1 isnt a global db. Eventually it will have read regions sure but its single region writer so

Unsmart•8/31/23, 6:09 PM

Afaik eventually they are working on a thing that will allow dynamic creation of D1 similar to durable objects where you can do env.D1.get("table-id").query("SELECT something from 'my-table'"). But thats probably very long out goal

Unsmart•8/31/23, 6:10 PM

Would have to find that message where they said that

https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/ https://github.com/elithrar/svelte-d

Similar Threads