Using D1 for my World of Warcraft site, working great for storing population statistics gathered via

Using D1 for my World of Warcraft site, working great for storing population statistics gathered via the official Blizzard API

https://atlasforge.gg/wow-classic/population
Biggest DB is around 200 MB, should have plenty of space still

AtlasForge Wow Classic Armory

World of Warcraft Classic Season of Discovery Armory

AtlasForge is a tool to let you view World of Warcraft Classic Season of Discovery character equipment and statistics

RRabid Using D1 for my World of Warcraft site, working great for storing population sta...

Matt Silverlock•1/6/24, 9:10 AM

This is cool! The realm population data is nice.

JJumping Back Any idea on how to go about using prisma

Jumping Back•1/6/24, 1:31 PM

is there something regarding this

Nightelf9•1/6/24, 1:50 PM

hey guys im a beginner and am trying to build an animal fact app for my kids
im trying to use D1 database to store the animal names, facts, image url (to R3 bucket public link)
my issue is that I can't for the life of me figure out how to interact with the D1 database in my page or html/js
https://javascript-website.pages.dev/
it's still a while away from something semi decent, i figured it out with python locally but now im trying to turn it into JS and deploy it online with cloudflare because of the D1 integration it has. Thanks in advance!

Dj_Laag•1/6/24, 3:25 PM

Hey guys,

i need some advice on how to use d1 binding in combination with staticFormsPlugin.
I figured out how to access the formdata. But when trying load data to d1 it cannot find the context properly

Any Ideas?

Yiwan•1/6/24, 3:49 PM

Hey guys, does D1 support returning fields after inserting, i.e.
INSERT INTO Table(field) VALUES(?) RETURNING id
(or different syntax for this stuff)?

kian•1/6/24, 3:53 PM

Yes

Yiwan•1/6/24, 3:57 PM

Yey thank you

JJumping Back Any idea on how to go about using prisma

Jumping Back•1/6/24, 4:32 PM

I wonder if anybody got any idea regarding this

Jumping Back•1/6/24, 4:33 PM

I have a giant schema I do not want to switch

Jumping Back•1/6/24, 4:33 PM

Possible to use drizzle queries but prisma for schema migration

Jumping Back•1/6/24, 4:34 PM

But it will still require massive refactoring

JJumping Back Any idea on how to go about using prisma

Matt Silverlock•1/6/24, 5:32 PM

Prisma doesn’t yet support D1, primarily because Prisma doesn’t run in edge serverless environments like Workers (or Bun, or Deno) yet.

MMatt Silverlock Prisma doesn’t yet support D1, primarily because Prisma doesn’t run in edge serv...

Jumping Back•1/6/24, 5:33 PM

Does it still matter even if I do prisma migrate and use prima client for queries

JJumping Back Does it still matter even if I do prisma migrate and use prima client for querie...

Matt Silverlock•1/6/24, 5:57 PM

Prisma has no way to talk to a D1 database, so I don’t know how this would work.

sSr•1/7/24, 9:50 AM

How do i access D1 in normal function in sveltekit app ? I don't care about a local replica for development. I just want to be able to read and write to D1. I have got D1 defined in wrangler.toml, I was able to get example working but I am so lost how to get it working in sveltekit. This is a typical code to lucia auth: https://v3.lucia-auth.com/database/sqlite

// ~/username-and-password/src/lib/server/auth.js
import { Lucia } from "lucia"
import { D1Adapter } from "@lucia-auth/adapter-sqlite";
import { dev } from "$app/environment"

const adapter = new D1Adapter(D1, {
user: "user_info",
session: "user_session"
});

export const lucia = new Lucia(adapter, {
sessionCookie: {
attributes: {
secure: !dev
}
},
getUserAttributes: attributes => {
return {
username: attributes.username
}
}
})

SsSr How do i access D1 in normal function in sveltekit app ? I don't care about a lo...

Matt Silverlock•1/7/24, 3:17 PM

https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/

Query D1 from SvelteKit · Cloudflare D1 docs

SvelteKit is a full-stack framework that combines the Svelte front-end framework with Vite for server-side capabilities and rendering. You can query …

CCole Xemi Is there a way to use batch statements with the http d1 api?

K•1/7/24, 3:49 PM

I think someone said that http API does not have batch endpoint. So you'd have to do it from worker.

SsSr How do i access D1 in normal function in sveltekit app ? I don't care about a lo...

K•1/7/24, 4:05 PM

There are two things here. One is setting up Lucia and second is getting data from D1 in svelte kit.

If you want to get things from D1 you have to use "+server.js" files in kit.

KK There are two things here. One is setting up Lucia and second is getting data fr...

sSr•1/7/24, 4:07 PM

I got Lucia setup got it working with with a few different databases ... i think the root problem is I am not able to understand how "connection string" gets setup for D1 !

sSr•1/7/24, 4:08 PM

i.e. platform.env.DB.prepare is undefeined for me!

sSr•1/7/24, 4:10 PM

if i am already installing cloudflare-adaptor in sveltekit why do i need to run cli cmd wangle xyz .... then do all the gymnastics to get it to work

Yongyi•1/7/24, 4:12 PM

any estimation on when D1 will increase the max database size? currently it's at 2GB. I understand a lot of testing are needed to make sure there's no delay when querying the data. hope we get update soon

kian•1/7/24, 4:14 PM

d1-database

kian•1/7/24, 4:15 PM

It's likely to raise when D1 goes into general availability, and the goal for that is Q1.

Yongyi•1/7/24, 4:15 PM

that will be amazing!

SsSr if i am already installing cloudflare-adaptor in sveltekit why do i need to run ...

K•1/7/24, 4:17 PM

Do you have GitHub repository somewhere with code?

xeon06•1/8/24, 12:32 AM

I need to add a constraint to a column, which isn't allowed in SQLite without dropping the table, but I have a foreign key on the table and data elsewhere. Any way to backup and restore data only, and not the table structure?

Will•1/8/24, 2:16 AM

is it possible to remove multiple item in a json in one query?
json_remove('[60,70,80,90]', '$[0], $[2]' )
the result should be [70,90]

kian•1/8/24, 2:25 AM

Have you already tried it?

MMatt Silverlock https://developers.cloudflare.com/d1/examples/d1-and-sveltekit/

Bobakanoosh•1/8/24, 3:20 AM

What about Nuxt?

Running d1 locally just seems pointless when combined with something like Nuxt. Because I have to run

wrangler dev

wrangler dev

I just lose hot reloading making it basically pointless to use from a DX perspective. Am I missing something? Or am I expected to rebuild the application over and over to test..?

Bobakanoosh•1/8/24, 4:23 AM

yea I know nothing about nuxt internals so unfortunately this is a complete turn off to use d1 for now

Bobakanoosh•1/8/24, 6:45 AM

Guess I found this: https://github.com/Atinux/nuxt-todos-edge/tree/main
which has a working dev example that I'll follow

GitHub

GitHub - Atinux/nuxt-todos-edge: A full-stack application with auth...

A full-stack application with authentication, SSR and SQLite, running on the edge with Nuxt 3. - GitHub - Atinux/nuxt-todos-edge: A full-stack application with authentication, SSR and SQLite, runni...

Gagan Suie•1/8/24, 7:17 AM

hi! new to D1. do we need to do LIMIT 1 if we're already doing .first()? will it be faster if we do LIMIT 1?

const lastStream = await env.DB.prepare(

const lastStream = await env.DB.prepare(

SELECT *
FROM analytic_stream
WHERE userId = ?1
ORDER BY start DESC
LIMIT 1


        )
            .bind(userId)
            .first()


        )
            .bind(userId)
            .first()

Kkian https://discord.com/channels/595317990191398933/992060581832032316/1174472811927...

Rakhim•1/8/24, 10:18 AM

Thanks! Is there an estimate of the future upper limit? I am working on a product which requires a constant increase in data storage, and was wondering which ceiling I should design for.