We will eventually deprecate that backend: there should be almost no limits that are higher there, a

IIsak You can bind local MiniFlare during dev see here https://github.com/cloudflare/m...

C

Cy•12/16/23, 9:43 PM

Thank you. I’ll look into the documentation soon

D

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

Hi! So I was able to make a fully working version locally thanks to you guys however, when deployed, I'm wondering cause some of the WRITE (insert) requests do not register, and I wanna know why.. It doesn't give me any error messages as well.. and it does it randomly any idea why?

MMatt Silverlock We will eventually deprecate that backend: there should be almost no limits that...

D

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

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

K

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

D

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

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

D

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

D

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

D

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

T

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

You are missing an 'await' for the query

D

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

D

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

D

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

M

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

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

I

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

D

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

K

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

run

run

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

K

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

K

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

Yeah - I have no idea when it stopped returning errors like

D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query?

D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query?

D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query?

D1_ERROR: Error: SQL execute error: Execute returned results - did you mean to call query? but it's probably going to be a pain to return to it's original behaviour without breaking projects

K

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

Valve pls fix rapidfire

K

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

nvm they did

Original message was deleted

D

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

Thanks!

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

D

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

it says it returns the metrics only

Original message was deleted

D

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

D

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

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

D

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

D

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

D

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

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

D

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

S

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)

U

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

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

W

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

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

console.log('??', await env.DB.prepare('select "channels"."id", "channels"."created_at", "channels"."name", "channels"."app_id", "channels"."version", "channels"."created_by", "channels"."updated_at", "channels"."public", "channels"."disableAutoUpdateUnderNative", "channels"."disableAutoUpdate", "channels"."enableAbTesting", "channels"."enable_progressive_deploy", "channels"."secondaryVersionPercentage", "channels"."secondVersion", "channels"."beta", "channels"."ios", "channels"."android", "channels"."allow_device_self_set", "channels"."allow_emulator", "channels"."allow_dev", "secondVersion"."id", "secondVersion"."created_at", "secondVersion"."app_id", "secondVersion"."name", "secondVersion"."bucket_id", "secondVersion"."user_id", "secondVersion"."updated_at", "secondVersion"."deleted", "secondVersion"."external_url", "secondVersion"."checksum", "secondVersion"."session_key", "secondVersion"."storage_provider", "secondVersion"."minUpdateVersion", "version"."id", "version"."created_at", "version"."app_id", "version"."name", "version"."bucket_id", "version"."user_id", "version"."updated_at", "version"."deleted", "version"."external_url", "version"."checksum", "version"."session_key", "version"."storage_provider", "version"."minUpdateVersion" from "channels" left join "app_versions" "secondVersion" on "channels"."secondVersion" = "secondVersion"."id" inner join "app_versions" "version" on "channels"."version" = "version"."id" limit 1').all())

console.log('??', await env.DB.prepare('select "channels"."id", "channels"."created_at", "channels"."name", "channels"."app_id", "channels"."version", "channels"."created_by", "channels"."updated_at", "channels"."public", "channels"."disableAutoUpdateUnderNative", "channels"."disableAutoUpdate", "channels"."enableAbTesting", "channels"."enable_progressive_deploy", "channels"."secondaryVersionPercentage", "channels"."secondVersion", "channels"."beta", "channels"."ios", "channels"."android", "channels"."allow_device_self_set", "channels"."allow_emulator", "channels"."allow_dev", "secondVersion"."id", "secondVersion"."created_at", "secondVersion"."app_id", "secondVersion"."name", "secondVersion"."bucket_id", "secondVersion"."user_id", "secondVersion"."updated_at", "secondVersion"."deleted", "secondVersion"."external_url", "secondVersion"."checksum", "secondVersion"."session_key", "secondVersion"."storage_provider", "secondVersion"."minUpdateVersion", "version"."id", "version"."created_at", "version"."app_id", "version"."name", "version"."bucket_id", "version"."user_id", "version"."updated_at", "version"."deleted", "version"."external_url", "version"."checksum", "version"."session_key", "version"."storage_provider", "version"."minUpdateVersion" from "channels" left join "app_versions" "secondVersion" on "channels"."secondVersion" = "secondVersion"."id" inner join "app_versions" "version" on "channels"."version" = "version"."id" limit 1').all())

console.log('??', await env.DB.prepare('select "channels"."id", "channels"."created_at", "channels"."name", "channels"."app_id", "channels"."version", "channels"."created_by", "channels"."updated_at", "channels"."public", "channels"."disableAutoUpdateUnderNative", "channels"."disableAutoUpdate", "channels"."enableAbTesting", "channels"."enable_progressive_deploy", "channels"."secondaryVersionPercentage", "channels"."secondVersion", "channels"."beta", "channels"."ios", "channels"."android", "channels"."allow_device_self_set", "channels"."allow_emulator", "channels"."allow_dev", "secondVersion"."id", "secondVersion"."created_at", "secondVersion"."app_id", "secondVersion"."name", "secondVersion"."bucket_id", "secondVersion"."user_id", "secondVersion"."updated_at", "secondVersion"."deleted", "secondVersion"."external_url", "secondVersion"."checksum", "secondVersion"."session_key", "secondVersion"."storage_provider", "secondVersion"."minUpdateVersion", "version"."id", "version"."created_at", "version"."app_id", "version"."name", "version"."bucket_id", "version"."user_id", "version"."updated_at", "version"."deleted", "version"."external_url", "version"."checksum", "version"."session_key", "version"."storage_provider", "version"."minUpdateVersion" from "channels" left join "app_versions" "secondVersion" on "channels"."secondVersion" = "secondVersion"."id" inner join "app_versions" "version" on "channels"."version" = "version"."id" limit 1').all())

console.log('??', await env.DB.prepare('select "channels"."id", "channels"."created_at", "channels"."name", "channels"."app_id", "channels"."version", "channels"."created_by", "channels"."updated_at", "channels"."public", "channels"."disableAutoUpdateUnderNative", "channels"."disableAutoUpdate", "channels"."enableAbTesting", "channels"."enable_progressive_deploy", "channels"."secondaryVersionPercentage", "channels"."secondVersion", "channels"."beta", "channels"."ios", "channels"."android", "channels"."allow_device_self_set", "channels"."allow_emulator", "channels"."allow_dev", "secondVersion"."id", "secondVersion"."created_at", "secondVersion"."app_id", "secondVersion"."name", "secondVersion"."bucket_id", "secondVersion"."user_id", "secondVersion"."updated_at", "secondVersion"."deleted", "secondVersion"."external_url", "secondVersion"."checksum", "secondVersion"."session_key", "secondVersion"."storage_provider", "secondVersion"."minUpdateVersion", "version"."id", "version"."created_at", "version"."app_id", "version"."name", "version"."bucket_id", "version"."user_id", "version"."updated_at", "version"."deleted", "version"."external_url", "version"."checksum", "version"."session_key", "version"."storage_provider", "version"."minUpdateVersion" from "channels" left join "app_versions" "secondVersion" on "channels"."secondVersion" = "secondVersion"."id" inner join "app_versions" "version" on "channels"."version" = "version"."id" limit 1').all())

and I got. That presents a MASSIVE issue. Essentially that means that

"version"."id"

"version"."id"

"version"."id"

"version"."id" overwrites

"channels"."name"

"channels"."name"

"channels"."name"

"channels"."name" and

"version"."name"

"version"."name"

"version"."name"

"version"."name". That is not even the worst. I currently have

"channels"."secondVersion"

"channels"."secondVersion"

"channels"."secondVersion"

"channels"."secondVersion" set to null but I am 99% that when it's not null it's going to overwrite my

version.*

version.*

version.*

version.*

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

D

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

you can rename them to avoid the name collision:

select "channels"."version" as "channelversion"

select "channels"."version" as "channelversion"

select "channels"."version" as "channelversion"

select "channels"."version" as "channelversion"

D

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

note that this isn't specific to D1

W

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

Okay, thanks ^^

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

W

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

this is not going to work

W

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

I cannot get drizzle to remap this query like that

D

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

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

W

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

See

D

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

it's very simple then, drizzle has a

.as()

.as()

.as()

.as() : 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...

W

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)

W

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)

D

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

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

W

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

so can I remap this in a way that would make d1 return this correctly (so remap

"secondVersion"."name"

"secondVersion"."name"

"secondVersion"."name"

"secondVersion"."name" into

svName

svName

svName

svName for example) and then remap this in drizzle so that the final object structure does not change?

W

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?

W

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

S

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

What is the error?

SSam What is the error?

W

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

return "404 Not Found"

Wwebsellcn return "404 Not Found"

S

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

W

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.

We will eventually deprecate that backend: there should be almost no limits that are higher there, a

Similar Threads

Similar Threads

Similar Threads