if i am already installing cloudflare-adaptor in sveltekit why do i need to run cli cmd wangle xyz .

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 …

GGunnar Are there any D1 Rust examples out there? I only see examples in TS: https://dev...

Max (@rozenmd)•1/9/24, 1:11 PM

https://github.com/cloudflare/workers-rs#d1-databases

Sam•1/9/24, 2:47 PM

Does D1 have any implementation for Levenshtein? (like postgres does with fuzzystrmatch). Thanks

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

Jason Hostetter•1/9/24, 4:51 PM

You can append to an array using ‘$[#]’ to denote the insert position

Jason Hostetter•1/9/24, 4:51 PM

https://www.sqlite.org/json1.html

Jason Hostetter•1/9/24, 4:51 PM

See section 3.2

SSam Does D1 have any implementation for Levenshtein? (like postgres does with fuzzys...

Max (@rozenmd)•1/9/24, 5:51 PM

not exposed as a function, but I think FTS5 uses it under the hood: https://www.sqlite.org/fts5.html

Matt Silverlock•1/9/24, 7:09 PM

Sharing here too: a neat TV show by season rating viewer built on D1 - https://discord.com/channels/595317990191398933/783765338692386886/1194047275681452123

code at https://github.com/docyx/imdb-table

GitHub

GitHub - docyx/imdb-table: IMDb rating tables and watch times for T...

IMDb rating tables and watch times for TV shows. Contribute to docyx/imdb-table development by creating an account on GitHub.

if i am already installing cloudflare-adaptor in sveltekit why do i need to run cli cmd wangle xyz .

Similar Threads

Similar Threads

Similar Threads