Sure, I get your point and I agree that this is the way to go for cloudflare (prioritizing reliabili

Sure, I get your point and I agree that this is the way to go for cloudflare (prioritizing reliability over stuff like query depth). Still, it's a direct dealbreaker if most of my queries that are used in my backend simply won't work. But now that this has been increased, I guess I'll try again to migrate soon

DDenver James Duran Hi! So I was able to make a fully working version locally thanks to you guys how...

kian•12/16/23, 10:22 PM

We'd need more information - what's your code, what do you mean by not registering (writing in a deployed Worker isn't adding rows?), etc

Denver James Duran•12/16/23, 10:37 PM

my messages wont go through here I think discord is having a problem

Denver James Duran•12/16/23, 10:37 PM

Here's the deployed website: https://cafezinho.denvie.online/
I'm using sveltekit.

Basically, the user orders thru the website. The website then sends a formData to one of my API servers.
my server, runs an insert statement then returns order created when there's no error in inserting the data. I also used ZOD validation...

here's the server code:

Kkian We'd need more information - what's your code, what do you mean by not registeri...

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

Ahh sorry but discord wont allow me to send code here.. I'll send screenshots if it's okay

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

DDenver James Duran Ahh sorry but discord wont allow me to send code here.. I'll send screenshots if...

thiccvitalik•12/16/23, 10:41 PM

You are missing an 'await' for the query

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

I tried to follow this: https://developers.cloudflare.com/d1/platform/client-api/

got it, where do I put it, before platform?

Tthiccvitalik You are missing an 'await' for the query

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

Thank you .. I didn't realize I needed it cause it works sometimes.. Im gonna try it

Tthiccvitalik You are missing an 'await' for the query

Denver James Duran•12/16/23, 10:47 PM

Thanks so much @thiccvitalik I think it works fine now. I was so silly not adding it.

Ddivby0 Sure, I get your point and I agree that this is the way to go for cloudflare (pr...

Matt Silverlock•12/16/23, 10:53 PM

If you have specific queries that don’t run on the production backend, open a GitHub issue.

Isaac McFadyen•12/16/23, 11:03 PM

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.