What was the INSERT doing? You are billed for "rows" read/written by your query, not operations. Ass

What was the INSERT doing? You are billed for "rows" read/written by your query, not operations. Assuming you are referring to the SQLite DO.

Llambrospetrou What was the INSERT doing? You are billed for "rows" read/written by your query,...

Yota•9/30/24, 1:43 PM

this.

Yota•9/30/24, 1:43 PM

also, only this consume 26 read operation.

Yota•9/30/24, 1:44 PM

I tested several times in different condition and figured out that if the DO have multiple tables(8 tables in total) the number increased.
If i removed other tables, the read count reduced but it still count 6 read.

Noah•9/30/24, 3:24 PM

Hey, I can't make a new durable object :

Cannot create binding for class 'Trainer' because it is not currently configured to implement durable objects. Did you forget to apply a --new-class migration to it? [code: 10061]

Cannot create binding for class 'Trainer' because it is not currently configured to implement durable objects. Did you forget to apply a --new-class migration to it? [code: 10061]

But if I try to add it

npx wrangler deploy --new-class Trainer
✘ [ERROR] Unknown arguments: new-class, newClass

npx wrangler deploy --new-class Trainer
✘ [ERROR] Unknown arguments: new-class, newClass

In my wrangler I have

[[durable_objects.bindings]]
name = "DURABLE_TRAINER"
class_name = "Trainer"
[[migrations]]
tag = "v1"
new_classes = ["Trainer"]

[[durable_objects.bindings]]
name = "DURABLE_TRAINER"
class_name = "Trainer"
[[migrations]]
tag = "v1"
new_classes = ["Trainer"]

I already did it once and then I deleted my durable object via dashboard, how to remake one ?

NNoah Hey, I can't make a new durable object : ``` Cannot create binding for class 'T...

Hello, I’m Allie!•9/30/24, 3:27 PM

Try just running

wrangler deploy

wrangler deploy

Noah•9/30/24, 3:28 PM

Yeah that's what gives me

  Cannot create binding for class 'Trainer' because it is not currently configured to implement
  durable objects. Did you forget to apply a --new-class migration to it? [code: 10061]

  Cannot create binding for class 'Trainer' because it is not currently configured to implement
  durable objects. Did you forget to apply a --new-class migration to it? [code: 10061]

Noah•9/30/24, 3:28 PM

and I tried with different wrangler version, currently i'm on 3.78.12

NNoah Yeah that's what gives me ``` Cannot create binding for class 'Trainer' becaus...

cloudkite•9/30/24, 5:05 PM

Use a different tag, for example tag = “v1.1”

Noah•9/30/24, 6:19 PM

Well I finally resolved the issue by deleting the existing worker, made a new worker with different name, then migrate my page on the new worker

Noah•9/30/24, 6:20 PM

But ty! I'll try

Original message was deleted

Yota•9/30/24, 6:22 PM

I tired: durable-objects but the number was not changed.

YYota also, only this consume 26 read operation.

lambrospetrouOP•9/30/24, 7:29 PM

Hey, I suggest taking a look at the examples in https://developers.cloudflare.com/durable-objects/best-practices/access-durable-objects-storage/#examples

Aside from your billing question about the rows, you seem to be using promises when the API is synchronous, and also

one()

one()

does not return null, it will throw when it doesn't find a result.

YYota I tested several times in different condition and figured out that if the DO hav...

lambrospetrouOP•9/30/24, 7:30 PM

To clarify something again, the

rowsRead

rowsRead

you get is not the number of results. It's the number of rows read by SQLite to satisfy your query. So, if you do joins, scans, etc, and only end up with 1 row, you are not just charged for 1 row, but all the rows that had to be read to answer your query.
Having correct and good indices on your tables to answer your queries without scanning the whole table is important.

Llambrospetrou Hey, I suggest taking a look at the examples in https://developers.cloudflare.co...

Yota•9/30/24, 8:55 PM

Thanks but I have read all the materials you guys provided.
The reason why doing this is to remove errors.

Llambrospetrou To clarify something again, the `rowsRead` you get is not the number of results....

Yota•9/30/24, 8:59 PM

I understand that. But what I am saying is that only one read should not consume this number of read because it does not make sense to scan other tables when I just want to get one row. FYI, there is no foreign key in every 8 tables and there are only 6 records in total

Yota•9/30/24, 9:05 PM

I will try researching good indices anyway. Thanks for the answer.

Ggeelen FYI `.exec` takes a type parameter, so you can avoid casting: ```ts const user ...

Yota•9/30/24, 11:45 PM

Cool

thank you for the info!

Ggeelen FYI `.exec` takes a type parameter, so you can avoid casting: ```ts const user ...

Isaac McFadyen•10/1/24, 1:23 AM

Just an addendum here in case anyone sees this in the future that this is for typing only - if the row isn't actually a User no error will be thrown, it will show as a User to Typescript but not actually be a User object

1.1.1.1APP•10/1/24, 7:53 PM

DNS over Discord: GitHub

View the DNS over Discord source code on GitHub at https://dns-over-discord.v4.wtf/github

Suman!•10/1/24, 8:39 PM

Hi guys,
Is the latency between the Worker and the Durable object expected to be around 100-160ms provided that they both are in the same location?

Larry•10/1/24, 9:23 PM

Does write coalescing apply to SQLite storage? I'm particularly worried about the atomicity described in the docs (and quoted below) for non-SQL storage.

If you invoke put() (or delete()) multiple times without performing any await in the meantime, the operations will automatically be combined and submitted atomically. In case of a machine failure, either all of the writes will have been stored to disk or none of the writes will have been stored to disk.

LLarry Does write coalescing apply to SQLite storage? I'm particularly worried about th...

Hello, I’m Allie!•10/1/24, 10:10 PM

AFAIK, no, but it doesn’t have to, since the storage is synchronous anyway

HHello, I’m Allie!AFAIK, no, but it doesn’t have to, since the storage is synchronous anyway

Larry•10/2/24, 12:44 AM

I'm concerned about consistency. As a made up example, let's say I have to update the account balance which is a row in the accounts table whenever there is a withdrawl which is a row in the withdrawls table. If I do the one and something crashes before I can complete the other, does the 1st get rolled back?

LLarry I'm concerned about consistency. As a made up example, let's say I have to updat...

Isaac McFadyen•10/2/24, 12:57 AM

Theoretically this should be done in a batch (where a batch using the DO SQLite API is just semicolon-seperated statements I believe), and if it's done in a batch then yes it's automatically done as part of a SQLite transaction and would be rolled back.

IIsaac McFadyen Theoretically this should be done in a batch (where a batch using the DO SQLite ...

lambrospetrouOP•10/2/24, 9:33 AM

Yes, using the

.batch([query_1, query_2])

.batch([query_1, query_2])

function will use SQLite transactions under the hood so you can make sure both queries either commit or rollback. https://developers.cloudflare.com/d1/build-with-d1/d1-client-api/#dbbatch
edit: Oops, sorry, I thought you were talking about D1. But the same works for the DO by what Isaac mentioned.

Llambrospetrou Yes, using the `.batch([query_1, query_2])` function will use SQLite transactio...

Hello, I’m Allie!•10/2/24, 9:45 AM

Actually, haven't checked yet, but does

storage.transaction

storage.transaction

work with SQLite-engine DOs?

HHello, I’m Allie!Actually, haven't checked yet, but does `storage.transaction` work with SQLite-e...

Larry•10/2/24, 12:17 PM

storage.transaction

storage.transaction

working for "SQLite-engine DOs" is great! However, is that just for the old

get()

get()

put()

put()

, etc. calls or does it work for SQL statements also?

LLarry `storage.transaction` working for "SQLite-engine DOs" is great! However, is that...

Hello, I’m Allie!•10/2/24, 12:18 PM

Uh... I phrased that weirdly... I hope Lambros meant both?

Hello, I’m Allie!•10/2/24, 12:18 PM

Though not sure, might be a case of try it and see?

LLarry `storage.transaction` working for "SQLite-engine DOs" is great! However, is that...

lambrospetrouOP•10/2/24, 2:14 PM

It should work for everything. In SQLite DOs, the KV API is actually using the same SQLite database with a "secret-hidden-not-so-much" table automatically created in the same SQLite database. So, both the KV and SQL API are consistent with each other.
I wouldn't suggest mixing them arbitrarily though since I am not sure how multiple transactions would work, e.g. nesting them.

Also, as long as your are doing storage writes without any IO inbetween (e.g.

fetch

fetch

), you shouldn't even need explicitly making transactions. But anyway, without concrete examples, this is mostly theory so I will stop here

Llambrospetrou It should work for everything. In SQLite DOs, the KV API is actually using the s...

Hello, I’m Allie!•10/2/24, 2:20 PM

I think the idea was more that you have rollback support? Not sure if I've missed something, but don't think the SQLite API itself has anything for that?

Hhannes short question: D1 docs say "use prepare() for perf and defend against SQL injec...

lambrospetrouOP•10/2/24, 3:56 PM

The

.exec()

.exec()

method does the prepare statements for you. Soon they will be cached automatically as well.

Llambrospetrou It should work for everything. In SQLite DOs, the KV API is actually using the s...

Larry•10/2/24, 8:43 PM

It's going to be impossible for me to confirm this experimentially, so @kenton , does this hold true for

.sql.exec()

.sql.exec()

If you invoke put() (or delete()) multiple times without performing any await in the meantime, the operations will automatically be combined and submitted atomically. In case of a machine failure, either all of the writes will have been stored to disk or none of the writes will have been stored to disk.

xeon06•10/2/24, 8:58 PM

Hey folks, I'm confused about durable object bindings for Pages. I'm trying to setup the binding but there are no durable objects I can pick in the list, and when I go to the durable object section of the dashboard there's no obvious way to create them?

Xxeon06 Hey folks, I'm confused about durable object bindings for Pages. I'm trying to s...

Larry•10/2/24, 9:00 PM

There was talk of being able to create DOs in a Pages project and that may have been implemented since I last paid close attention, but if not, you need a plain old Workers project (with an empty Worker, if you wish) to deploy DOs.

xeon06•10/2/24, 9:02 PM

Wow I'm not sure how I completely missed that it wasn't available on Pages

xeon06•10/2/24, 9:03 PM

I am not seeing any mention of Pages in the docs now that you mention it, only Workers

Larry•10/2/24, 9:04 PM

One of the complexities had to do with the fact that DOs must specify migrations in the .toml file and .toml files weren't supported by Pages back then. I think I saw where that changed at some point, but that could also just be something I heard was planned.

xeon06•10/2/24, 9:06 PM

I believe toml files are now supported but am similarly not sure of how that impacts things here. Thanks for the comments though!

xeon06•10/2/24, 9:08 PM

https://blog.cloudflare.com/pages-workers-integrations-monorepos-nextjs-wrangler/

The Cloudflare Blog

Announcing Pages support for monorepos, wrangler.toml, database int...

Today, we’re launching four improvements to Pages that bring functionality previously restricted to Workers, with the goal of unifying the development experience between the two. Support for monorepos, wrangler.toml, new additions to Next.js support and database integrations!

xeon06•10/2/24, 9:09 PM

Maybe I just need to recheck my deploy script, it might just be using the old "way"

LLarry One of the complexities had to do with the fact that DOs must specify migrations...

DaniFoldi•10/2/24, 9:23 PM

That wasn't the complexity with Pages, and the compatibility matrix shows that defining DOs is still not supported in Pages: https://developers.cloudflare.com/workers/static-assets/compatibility-matrix/#_top

Cloudflare Docs

Workers vs. Pages (compatibility matrix) | Cloudflare Workers docs

Compatibility matrix for asset hosting on Cloudflare Workers and Pages.

LLarry It's going to be impossible for me to confirm this experimentially, so @kenton ,...

kenton•10/2/24, 9:40 PM

yes, this applies to

sql.exec()

sql.exec()

DDaniFoldi That wasn't the complexity with Pages, and the compatibility matrix shows that _...

xeon06•10/2/24, 10:32 PM

Implying they can be defined in workers and used in pages? Do I just need to add them to a worker's wrangler.toml?

Larry•10/2/24, 10:35 PM

Yes, they can be defined in a Worker, then bound to the Pages app in the console (but maybe that can now be done in the .toml, I don't know), then called from the Pages app.

xeon06•10/2/24, 10:48 PM

Ahh I see, it looks like I can probably bind it directly in the UI in Pages now, just didn't know how to "define" the worker!

Larry•10/2/24, 10:50 PM

That's well covered in the getting started for DOs

What was the INSERT doing? You are billed for "rows" read/written by your query, not operations. Ass

Similar Threads

Similar Threads

Similar Threads