Tip for the future: there should almost never be a reason to cast into `unknown` and then another ty

Tip for the future: there should almost never be a reason to cast into

unknown

unknown

and then another type. If it won't cast without the unknown then it's likely something else is wrong.

IIsaac McFadyen Tip for the future: there should almost never be a reason to cast into `unknown`...

Denver James Duran•12/16/23, 11:19 PM

uhm, can you help me overcome it? cause I followed the set up but on my app.d.ts, the D1Database isn't defined... so my platform.env.database.prepare.bind.run() is always unknown

kian•12/16/23, 11:30 PM

shouldn't actually return anything (https://developers.cloudflare.com/d1/platform/client-api/#await-stmtrun) but iirc it's broken and does.

kian•12/16/23, 11:30 PM

kian•12/16/23, 11:31 PM

Yeah - I have no idea when it stopped returning errors like but it's probably going to be a pain to return to it's original behaviour without breaking projects

kian•12/16/23, 11:32 PM

Valve pls fix rapidfire

kian•12/16/23, 11:32 PM

nvm they did

Original message was deleted

Denver James Duran•12/16/23, 11:38 PM

Thanks!

Kkian `run` shouldn't actually return anything (<https://developers.cloudflare.com/d1/...

Denver James Duran•12/16/23, 11:39 PM

it says it returns the metrics only

Original message was deleted

Denver James Duran•12/16/23, 11:42 PM

this is so helpful.. what I previously did was to create my own type where I pass in the type of my rows

Denver James Duran•12/16/23, 11:43 PM

using this knowledge, means that I really dont need this interface.. right?

Denver James Duran•12/16/23, 11:44 PM

but I guess I'll keep it for cases like this.. so I dont have to write <row> everytime

Denver James Duran•12/16/23, 11:44 PM

or there's a proper method for this? where there are multiple bindings

Original message was deleted

Denver James Duran•12/17/23, 12:07 AM

Im not sure it addresses my problem where I need to have multiple bindings

Denver James Duran•12/17/23, 12:52 AM

like in my code... I have a condition where the query changes depending on the searchParams... basically, if there's a status given, the arguments in bind() will be status, from and to.. but if it doesn't, it will be from and to only

Sebastián / UGame Studio•12/17/23, 2:00 AM

Hi, can someone explain me this please?
if D1 is "serverless" and this is billed by usage, why this limits? https://developers.cloudflare.com/d1/platform/limits/ i do not understand ... (mainly the maximum database size)

Unsmart•12/17/23, 2:00 AM

What about it do you not understand? Every service has limits. Serverless doesnt mean no limits

WcaleNieWolny•12/17/23, 8:45 AM

Is there any way to do joins in d1? I did

and I got. That presents a MASSIVE issue. Essentially that means that overwrites and . That is not even the worst. I currently have set to null but I am 99% that when it's not null it's going to overwrite my

WWcaleNieWolny Is there any way to do joins in d1? I did ```ts console.log('??', await env.DB.p...

DaniFoldi•12/17/23, 9:23 AM

you can rename them to avoid the name collision:

DaniFoldi•12/17/23, 9:23 AM

note that this isn't specific to D1

WcaleNieWolny•12/17/23, 9:24 AM

Okay, thanks ^^

DDaniFoldi you can rename them to avoid the name collision: `select "channels"."version" as...

WcaleNieWolny•12/17/23, 10:00 AM

this is not going to work

WcaleNieWolny•12/17/23, 10:00 AM

I cannot get drizzle to remap this query like that

DaniFoldi•12/17/23, 10:05 AM

okay, so you're using drizzle, that was not clear to me before lul

WcaleNieWolny•12/17/23, 10:06 AM

See

DaniFoldi•12/17/23, 10:06 AM

it's very simple then, drizzle has a : https://orm.drizzle.team/docs/sql#sqlast

Drizzle ORM - next gen TypeScript ORM

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

DDaniFoldi it's very simple then, drizzle has a `.as()` : https://orm.drizzle.team/docs/sql...

WcaleNieWolny•12/17/23, 10:07 AM

yes it does, for raw sql. But unfortunately not for something like I am doing (see screenshot above)

WcaleNieWolny•12/17/23, 10:08 AM

besides, I need those fields to have the same name (at least in js)

WWcaleNieWolny besides, I need those fields to have the same name (at least in js)

DaniFoldi•12/17/23, 10:09 AM

you get an object, and you can have one thing with a given name

WcaleNieWolny•12/17/23, 10:10 AM

so can I remap this in a way that would make d1 return this correctly (so remap into for example) and then remap this in drizzle so that the final object structure does not change?

websellcn•12/18/23, 7:43 AM

Hi! I have some issues here. There is no problem inserting data, but there was an error updating the data. Could you please help me check if I made a mistake?

websellcn•12/18/23, 7:44 AM

thanks

Wwebsellcn Hi! I have some issues here. There is no problem inserting data, but there was a...

Sam•12/18/23, 8:32 AM

What is the error?

SSam What is the error?

websellcn•12/18/23, 9:35 AM

return "404 Not Found"

Wwebsellcn return "404 Not Found"

Sam•12/18/23, 9:39 AM

Weird, also does D1 not support ON CONFLICT? You can have a single query using this, instead of the current 3

SSam Weird, also does D1 not support *ON CONFLICT*? You can have a single query using...

websellcn•12/18/23, 9:49 AM

A single query still returns the same result. There is too little information about updates in the official documents. I’m not sure if I wrote it correctly.

Wwebsellcn return "404 Not Found"

Max (@rozenmd)•12/18/23, 10:11 AM

D1 doesn't throw 404 - are you hitting the right URL of your API?

Wwebsellcn return "404 Not Found"

Matt Silverlock•12/18/23, 11:15 AM

Are you making a POST request? Your Hono route is and you don’t appear to have any other routes.

websellcn•12/18/23, 11:37 AM

Okay, thank you everyone. There is an extra bracket in the code, but the editor did not remind me.

Original message was deleted

Matt Silverlock•12/18/23, 11:45 AM

D1 has a REST API - see the docs: https://developers.cloudflare.com/d1/

Cloudflare D1 · Cloudflare D1 docs

D1 is Cloudflare’s native serverless database. D1 allows you to build applications that handle large amounts of users at no extra cost. With D1, you …

Original message was deleted

Max (@rozenmd)•12/18/23, 12:20 PM

https://developers.cloudflare.com/api/operations/cloudflare-d1-query-database

Cloudflare API Documentation

Interact with Cloudflare's products and services via the Cloudflare API

Shroom•12/18/23, 4:05 PM

Is there any way to interleave two tables on disk? I have a table that has a 1 to many relationship with another table. I'm never going to query the "many" table to ask if it connects to the "one" table, always the other way around. I'd like to tell Cloudflare that they can optimize it by keeping the records from the 1 table next to the corresponding records from the many table by interleaving the rows on disk. That way it only needs to pull 1 disk block up when I query for data. Is this possible?

Shroom•12/18/23, 4:06 PM

Also, any way to bump up the 2 GB limit? Ikr it's not production ready, but I'd like to use it for a purely non-profit idea and I'm not sure if I'll stay under that limit

SShroom Is there any way to interleave two tables on disk? I have a table that has a 1 t...

kenton•12/18/23, 5:37 PM

D1 is built on SQLite, so this is only possible if SQLite itself contains such a feature. I don't think it does. But at the same time, I suspect this kind of feature would not have so much benefit given we're running SQLite backed by a local SSD. It'd be more important for a distributed database that might split data across many machines, but D1 doesn't do that.

Shroom•12/18/23, 8:16 PM

It doesn't do that? I thought the big advantage of d1 is that it's present at all your cdns. Does it just replicate the whole db everywhere?

SShroom It doesn't do that? I thought the big advantage of d1 is that it's present at al...

Isaac McFadyenOP•12/18/23, 8:21 PM

D1 is currently single location (either close to where you are when you create your DB, or in a geographic area of your choosing selected when you create the DB).

Isaac McFadyenOP•12/18/23, 8:22 PM

In the future there will be read replication support. But for now it's single location.

kian•12/18/23, 8:25 PM

Smart Placement will always run your Worker near the D1 DB

Original message was deleted

Max (@rozenmd)•12/18/23, 8:29 PM

I would use integers

IIsaac McFadyen D1 is currently single location (either close to where you are when you create y...

Shroom•12/18/23, 8:30 PM

Good to know. Most of my data can also be modeled as key-value pairs so I'll use that + hyperdrive.