How do i access D1 in normal function in sveltekit app ? I don't care about a local replica for deve

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...

sSrOP•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 !

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

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

sSrOP•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.

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

Max (@rozenmd)•1/8/24, 10:32 AM

.first().first() returns the first result after fetching the entire query result (https://github.com/cloudflare/workerd/blob/main/src/cloudflare/internal/d1-api.ts#L231-L257), explicitly adding LIMIT 1LIMIT 1 can be significantly more efficient if you know there are lots of results

Amr Yasser•1/8/24, 1:55 PM

Can d1 be used outside workers?
from node.js with express for example

zegevlier•1/8/24, 1:56 PM

While you could, it's generally not recommended. It is much slower than if you use it via workers.

zegevlier•1/8/24, 1:57 PM

Although if you just need it for administration stuff, that should be fine to do via the API

Amr Yasser•1/8/24, 2:05 PM

I am using it with next-auth so I was wondering how to use it out of workers

AAmr Yasser I am using it with next-auth so I was wondering how to use it out of workers

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

next-auth doesn't have to be out of workers btw https://github.com/cloudflare/next-on-pages/tree/main/packages/next-on-pages

Gunnar•1/8/24, 2:29 PM

hi, what's your typical latency in d1-beta?

kian•1/8/24, 2:55 PM

Hovers around 40-50ms personally, sometimes as low as 20ms.

RraRaRa Hi everyone. Is it possible to use D1 outside of Workers? E.g. if I run NextJS i...

Max (@rozenmd)•1/8/24, 5:00 PM

You can write your own Worker that exposes an API to NextJS: https://github.com/elithrar/http-api-d1-example

Max (@rozenmd)•1/8/24, 5:01 PM

using the public API directly also works, but isn't as performant

Xazu•1/8/24, 6:28 PM

Guys, can i use data from d1 in getStaticPaths on Astro framework?

Will•1/9/24, 6:50 AM

I am trying to add an element to an array

UPDATE daily SET schedule = json_insert(schedule,$[json_array_length(schedule)],'16.00') WHERE day = 1UPDATE daily SET schedule = json_insert(schedule,$[json_array_length(schedule)],'16.00') WHERE day = 1

but got unrecognized token

Will•1/9/24, 6:51 AM

how can I insert the element without knowing the array length?

Will•1/9/24, 6:54 AM

I have tried to use $[-1] , but it doesn't work

Will•1/9/24, 6:59 AM

solved it

Will•1/9/24, 6:59 AM

UPDATE daily SET schedule = json_insert(schedule,'$[' || json_array_length(schedule) || ']','16.00') WHERE day = 1

UPDATE daily SET schedule = json_insert(schedule,'$[' || json_array_length(schedule) || ']','16.00') WHERE day = 1

Kkian Hovers around 40-50ms personally, sometimes as low as 20ms.

Gunnar•1/9/24, 11:16 AM

Hi, when using D1, would it make sense to use Cache-Aside pattern with KV?
Cache-Aside pattern:
"Load data on demand into a cache from a data store. This can improve performance and also helps to maintain consistency between data held in the cache and data in the underlying data store."
https://learn.microsoft.com/en-us/azure/architecture/patterns/cache-aside

Cache-Aside pattern - Azure Architecture Center

Learn how to load data on demand into a cache, which can improve performance and maintain consistency between cached data and the underlying data store.

Gunnar•1/9/24, 11:56 AM

Are there any D1 Rust examples out there? I only see examples in TS:
https://developers.cloudflare.com/d1/examples/d1-and-remix/

Query D1 from Remix · Cloudflare D1 docs

Remix is a full-stack web framework that operates on both client and server. You can query your D1 database(s) from Remix using Remix’s data loading …

How do i access D1 in normal function in sveltekit app ? I don't care about a local replica for deve

Similar Threads

Similar Threads

Similar Threads