You can bind local MiniFlare during dev see here https://github.com/cloudflare/miniflare/pull/639#is

MMax (@rozenmd)you basically have to run `wrangler pages dev ... --d1=DB` and set `preview_dat...

R

RyanD•12/16/23, 2:27 PM

Thanks, that worked! For search history I also added --persist-to=./db to the wrangler dev for the worker and the pages command so it was easier to point them both to the same state dir

S

Sia•12/16/23, 3:06 PM

Hey, what is the price of D1? I can't find it on the website?

What are the limits?

C

Cyb3r-Jak3•12/16/23, 3:09 PM

Pricing: https://developers.cloudflare.com/d1/platform/pricing/ and Limits: https://developers.cloudflare.com/d1/platform/limits/
Still public beta so free for now and limits will increase

D

divby0•12/16/23, 3:34 PM

I have one database on a production project that is still the "old" version where you had backups instead of this point-in-time recovery. This old database version does work, but I guess I should upgrade it for better performance and future updates.

Now, last time I tried, I got hit by a 20 query-depth something limit that made me spent 2 days without any result, so I had to roll back and forget about it.

Now that this got increased, what are some other points where I could potentially be negatively surprised? Are there any other things that work better on the old version?

Ddivby0 I have one database on a production project that is still the "old" version wher...

M

Matt Silverlock•12/16/23, 7:56 PM

We will eventually deprecate that backend: there should be almost no limits that are higher there, and beyond that, the old backend was just unreliable. All the query depth in the world doesn’t matter if you can’t query a database reliably after it grows beyond 50MB.

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 Silverlock•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?

You can bind local MiniFlare during dev see here https://github.com/cloudflare/miniflare/pull/639#is

Similar Threads

Similar Threads

Similar Threads