https://discord.com/channels/595317990191398933/992060581832032316/1174472811927052299

K

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

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

Y

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

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

Do you have GitHub repository somewhere with code?

X

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?

W

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]

K

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

Have you already tried it?

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

B

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

B

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

B

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

G

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(

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()


        )
            .bind(userId)
            .first()


        )
            .bind(userId)
            .first()

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

R

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

M

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

.first()

.first()

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

LIMIT 1

LIMIT 1

LIMIT 1 can be significantly more efficient if you know there are lots of results

A

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

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

Z

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.

Z

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

A

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

M

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

G

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

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

K

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

M

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

M

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

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

X

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

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

W

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 = 1

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

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

but got unrecognized token

W

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

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

W

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

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

W

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

solved it

W

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

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.

G

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.

G

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

M

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

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

S

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 😅

J

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

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

J

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

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

J

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

M

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

M

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.

G

Gagan Suie•1/9/24, 8:53 PM

if i have an array of primary keys, how do i search using IN?
will this work? or do i need to format the array to a comma delimited string?

            const { results: usersFromUserIds } = await this.env.DB.prepare(

            const { results: usersFromUserIds } = await this.env.DB.prepare(

            const { results: usersFromUserIds } = await this.env.DB.prepare(

            const { results: usersFromUserIds } = await this.env.DB.prepare(

SELECT *
FROM user
WHERE _id IN (?1)


            )
                .bind(uniqueUserIds)
                .all()


            )
                .bind(uniqueUserIds)
                .all()


            )
                .bind(uniqueUserIds)
                .all()


            )
                .bind(uniqueUserIds)
                .all()

A

ALECKS•1/9/24, 9:03 PM

Trying to understand how local D1 runs a bit and I'm a bit confused. To run D1 locally it seems you have two options:

as part of
```
wranger dev
```
wranger dev
```
wranger dev
```
wranger dev
using miniflare

I'm trying to find a way to have my local D1 instance run it, but be able to query it from a separate process. I thought I could start it using #1, and connect to it from another process using the D1 Client via miniflare, but this doesn't seem to work.

How can I achieve this?

https://discord.com/channels/595317990191398933/992060581832032316/1174472811927052299

Similar Threads